Results 1 to 3 of 3
  1. #1
    burt1215 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    34

    Setting The Position Of The Horizontal Scroll Bar

    Hello,

    So what I have is a main form, containing navigation tabs, and one of those navigation tabs contains a form, with twelve more navigation tabs (one for each month).
    We use this to track attendance for our employees.



    Each field in my datasheet
    Code:
    Forms!frmMain!fsubNav.Form!fsubDatasheet
    represents a shift.

    When I load the database, and switch into the attendance tab, I want the horizontal scroll bar to scroll over so that the first field (minus the field containing employees, which I have frozen) (so I guess that means the second field) is the field representing the current, or next shift.
    For example. If I opened up the database today, the first field would be employee name, the second field would the field representing Tuesday the 26th.

    Don't worry about obtaining the name of the current shift, I can do that no problem.
    I'm just looking for VBA that will move the horizontal bar over to a certain field.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Dd you set the text box tab index to zero? That becomes the 1st box the cursor starts in.

  3. #3
    burt1215 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    34
    Dd you set the text box tab index to zero? That becomes the 1st box the cursor starts in.
    What that ended up doing is move the changed tab over to the start.
    Click image for larger version. 

Name:	changedTabs.JPG 
Views:	5 
Size:	18.7 KB 
ID:	25280

    So my next thought was to rearrange the index of all of the fields, however, that would make days 19-31 first followed by 1-18.
    I want to keep the order of the fields, I just want to change where the view starts.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. horizontal scroll bar
    By sdel_nevo in forum Programming
    Replies: 2
    Last Post: 05-28-2015, 08:03 AM
  2. Replies: 2
    Last Post: 10-01-2014, 09:10 PM
  3. Replies: 13
    Last Post: 07-19-2013, 08:34 AM
  4. Position of scroll bar
    By VictoriaAlbert in forum Access
    Replies: 2
    Last Post: 04-14-2011, 04:29 PM
  5. Control of horizontal scroll bar
    By smthomer in forum Programming
    Replies: 3
    Last Post: 08-25-2010, 10:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums