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

forms

ResolvedVersion 2003

Sam has attended:
Access Introduction course

Forms

What are the main uses of forms?

RE: Forms

Hello Sam
Thank you for your question

A form is a graphical replresentation of a table. You wouldnt want users of a database to go straight into the tables. You want to present them with an attractive form which can contain search functionality, possibly buttons with links to reports and navigation through the records etc. Users can add records through the forms rather than directly into the database records so you can also put validation on the form fields.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Mon 2 Mar 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.