We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Any MS Access Guru's out there

Options
Hi all

I have created a new data base for work, just to give a quick idea, i have also created a form to input the data to the table.

the form is in tabular format and on the left there is the persons name, then across the screen boxes to enter dates, however the boxes that go across the screen mean that you have to use the scroll bar to see the rest of the boxes,

What i am trying to do is lock the name on the left hand side of the form so that when you use the horizontal scroll bar the names always stay on the page,

Is there any way of doing this, Many thanks

Lee

Comments

  • Dejay
    Dejay Posts: 55 Forumite
    Hello Lee634,

    To freeze colums: Select columns, right click mouse button or select the Format menu. Click Freeze Columns.

    To unfreeze colums: Select Format menu, click Unfreeze All Columns.

    HTH
  • lee634
    lee634 Posts: 1,030 Forumite
    many thankss for that but i think you are referring to the datasheet view,

    I am trying to do the same in a form
  • nickmack
    nickmack Posts: 4,435 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    Use the design button to change the format of the form.
  • donny-gal
    donny-gal Posts: 4,660 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    In Access 2003 there are two ways of telling the form which order to tab around.
    If you click on the black square in the top lh corner of the design view there is a Tab Order option and you can drag the fields around, alternatively, if you click on each individiual field then you can set a tab stop number in it starting a 0.

    Hope this helps, I am sure the latter option is in the earlier versions too.

    Cheers
    Member #8 of the SKI-ers Club
    Why is it I have less time now I am retired then when I worked?
  • johnmc
    johnmc Posts: 1,265 Forumite
    Create a main form with the personal details down the left based on the Personal Details table.
    Create another form with the dates on.

    On the main form "insert a subform" and link it to the Main by the Index Number of the Personal record.

    You will have less scrolling if you put the name at the TOP of the Main screen, though.
  • wonka
    wonka Posts: 484 Forumite
    Part of the Furniture 100 Posts Combo Breaker
    Does anyone know of a good Access tutorial on the Internet?
    Of course, I may just be talking b****cks!
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.