The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced micorosoft access training - Form

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

advanced micorosoft access training - Form

Resolved · Low Priority · Version Standard

ReplyWed 21 Mar 2007, 08:47Delegate Vishal said...

Form

How do I turn a Form in to a Search tool once ive created it?

My form is liked to a Query, so I would like to be able to update the Query without changing the Forms search ability.

For upcoming training course dates see: Pricing & availability

ReplyThu 22 Mar 2007, 15:53Trainer Pete said...

RE: Form

Hi Vishal,
I think that you could create a combo box on your form, (in design view) from the Toolbox select the combo-box button, and click in some spare space on your form. Decide which field in your query you wish to search in, from the options on the first page choose "Find a Record on my form based on the value I selected in my combo box" Follow the instructions, and when finished, change back to Form View and click the drop down arrow, make your choice and your form should change to the selected criteria. Hope that helps!

ReplyThu 22 Mar 2007, 16:21Delegate Vishal said...

RE: Form

Thanks for the help, it worked fine, but now that ive dont this i would also like to be able to use the form on its own without having to open access. that why someone can search for data without having to know how to use access.

ReplyFri 23 Mar 2007, 13:26Trainer Pete said...

RE: Form

Hi Vishal,
I think you will find that you will have to open Access to use the form, however if you go to Tools, Startup and have a look at some of the options available, you will find an option to open a form when you open Access. Or you can create an autoexec macro (a macro named autoexec) which will run as you open the database and this macro can be actioned to open the form, dont forget to Maximise or you will see all the "gubbins" below the window. May I suggest that you create a copy of your database before switching off some of the functions, as it can be difficult to get some of them back. Further to this, you would have to allow administrators access in order to populate/edit the database.

Access articles

· MS Access and Database Normalisation
· How To Create Navigation Forms In Microsoft Access
· Practice Microsoft Access Database Decorum To Reap The Rewards
· Innovation with Microsoft Access
· How To Use A Parameter Query In Access

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

Can you tell me if there is additional information about graphs in the intermediate course?