advanced micorosoft access training - Form

Resolved · Low Priority · Version Standard

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

Vishal has attended:
Access Intermediate course
Access Advanced course

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.

Thu 22 Mar 2007, 15:53 Trainer 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!

Thu 22 Mar 2007, 16:21 Delegate 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.

Fri 23 Mar 2007, 13:26 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips