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

forms

ResolvedVersion 2007

Charlotte has attended:
Access Introduction course
Excel VBA Introduction course

Forms

Hi there,

I am looking to create an access database for our training team, essentially we want to create something user friendly for the team to input exam results into which we are then able to manipulate. We have come up with several ideas and would like to know what the pros and cons are of forms? Also whether creating one form for all 20 exams to then be dumped into a large raw data set (through data validation on the forms) or 20 forms for each exam would be more ideal as you are able to sit each exam up to 3 times.

Thanks in advance

Charlotte

RE: Forms

Hi Charlotte, thanks for your query. I'm going to be visiting PruProtect on Friday and a conversation about this project (and your other one) would probably be a good idea! Mention this to Monica van der Horst and lets try to have a quick chat when I'm around.

Anthony

Wed 11 Jul 2012: Automatically marked as resolved.

 

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:

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.