Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47

    Making a control have a fixed control


    Is it possible to make a control have a fixed position so that when the form is vertically scrolled the object stays in the same position?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Not in the detail section. The form header and footer sections don't scroll
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47
    Yeah the control is in the header but the header does scroll vertically. So if you scroll far enough you can no longer see some of the controls

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Having a Form sized so that the user has to scroll, to view all of it, is one of the most user-unfriendly things a developer can do! If you're having problems with real-estate the general answer is to use a Tabbed Control and spread your controls out over several Pages. If you have a given Control that you always want visible, place it above or to the side of the Tabbed Control.

    Exactly how many Controls are we talking about, here?

    Linq ;0)>

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    As Linq, says, your form is too long. The form scroll bar is to scroll records in the detail section. I presume you are having to use the app scroll bar to view the entire form. Do you have a number of subforms one after another down the form? Put them on pages of a tab control to condense the form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47
    My bad I have been saying vertically scroll when I meant horizontal scroll, that probably caused some confusion

    Its actually only one control which is a button that returns you to the homepage. The form is a continuous form that shows records based on criteria that the user puts into an earlier form. You have to horizontally scroll because of the amount of fields that are there. In the form users select a record and a subform opens with all the details for that record, I think a tabbed control would be more relevant for this form but it is not needed here.

    I'm thinking the only way around this would be to reduce the amount of fields in the continuous form?

    Thanks for the replies

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    The controls are all on one 'line'? Why not rearrange to multiple lines? Define separate records with a line control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47
    Hi

    I just tried that now yeah it does work. Do you know of any other work arounds though just so I can see what way I prefer?

    Thank you

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    That's all I have.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    What is your control button doing? Can you put your control button on the main form? If it is specific to a record within a continuous form can you use the double click event on a text box or a control that is NOT a button?

  11. #11
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47
    The control is a button that closes the form.

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Should not be in the Detail section.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47
    Its in the header but because there are so many fields in the continous form you can scroll hoirzontally. Thats why arranging the fields to mutiples lines worked because you no longer had to scroll horizontally.

  14. #14
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Create an unbound form. Create a subform that has your continuous form as its source object. Place your close control on your main form.

  15. #15
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    The subform is a valid approach but whenever I can, I like to avoid making users scroll to view data, especially horizontal scroll.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 05-07-2013, 02:43 AM
  2. Replies: 10
    Last Post: 02-20-2013, 07:04 AM
  3. Replies: 3
    Last Post: 03-29-2012, 12:40 PM
  4. Replies: 5
    Last Post: 10-13-2011, 03:36 PM
  5. Replies: 6
    Last Post: 03-14-2011, 09:37 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