98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced micorosoft access training - Form
advanced micorosoft access training - Form
Resolved · Low Priority · Version Standard
Wed 21 Mar 2007, 08:47Delegate 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: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!
Thu 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.
Fri 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.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create An Inaccessible Field On A FormThere 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: |
