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

access commands

ResolvedVersion 2003

Pete has attended:
Access Advanced course

Access Commands

Where can you find a great big list of all the commands you'd want to use with in the visual basics section that covers what we did today, without joining another course? (Just covering what we did today?)

RE: Access Commands

Hi Pete

Thank you for your question

If you open the VBE and click on the Object Browser button located on the top toolbar, then the object browser will replace the code window. You can the search through the different objects and their resulting properties and methods.

When you find what you are looking for, select the item in question and press F1. This will provide you with detailed help for the item, together with examples of its use.

Regards

Stephen

Wed 11 Mar 2009: Automatically marked as resolved.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.