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

tables

ResolvedVersion 2007

Tables

I am trying to create a table that when you enter one field, it automatically populates other fields.

Can you help.

RE: Tables

Hi Anita,

Thank you for your question.

This cannot be achieved in a table and would have to be done on a form.

However you would have to write some VBA code to update the other fields.

I hope this answers your question.

Regards

Simon

Thu 24 Sep 2009: Automatically marked as resolved.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



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.1 secs.