acess

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Acess

Acess

resolvedResolved · Low Priority · Version 2007

Kelly has attended:
Access Introduction course

Acess

Whilst in the course I asked why, when I open up an existing database at work, it is often not in the same lay out as when I last worked on it. No one else has opened the file but the columns are all our of order.

If I go into design view and change something e.g. add a new column, when I go back into the table everything is back in the correct order but it is frustrating having to do this every time.

In the course I was told this probably had something to do with a 'start up macro' and holding the shift button down whilst iopening the file would correct it. But this doesn't work so does anyone have any other ideas?

RE: Acess

Hi Kelly

Sorry for not getting back sooner. Can I check - do you get a dialog box asking you if you wish to save changes to the layout of the table? Saying Yes normally keeps the new arrangement of columns in the table.

Regards

Doug Dunn
Best STL

RE: Acess

Hi Doug,

thanks for your reply, I don't get a dialog box before I close a table, because I don't alter the order of any columns.

It seems completely random that sometimes when I open a table back up again, everything will be out of order.

- if things are out of order when I open the file, I go into design view and I've got a text column in there I can change round, so I change it from text to memo, for example, save the change, go back into table view and everything is back in the order I left it in. i just have to make a change to the design and everything goes back to how it should be. But this is bit irritating!

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Insert The Current Date

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)

View all Access hints and tips


Server loaded in 0.08 secs.