Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » courses in microsoft access - Queries on Forms
|
|
|
Bookmark this page|
The UK's most regular 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. |
courses in microsoft access - Queries on Forms
Resolved · Low Priority · Version Standard
Reply
Queries on Forms
I have created two queries, first for bank accounts and countries and the second for bank contacts and countries. Both queries have a Find function based in the country field. I have created a form with the two page function, the 1st page form being made up of country bank contacts and the 2nd page form being for country bank accounts (I wanted this form to show accounts via datasheet i.e. all accounts on the one page). The form works fine however as both queries have the find function when the form opens you have to type in the country twice to show the data. Is there anyway that I can just have one find function via a macro?Thanks
For upcoming training course dates see: Pricing & availability
RE: Queries on Forms
try typing this wild card querieWildcards allow you a degree of flexibility when specifying criteria. When you don't know exactly what you are looking for you can use wildcards to give the query a "clue".
For a single wildcard:
Like [type prompt here] & "*"
this will show you all your data
|
 |
|
» Forum post: Templates |
If I want to change a template how do I do this? I've gone back into the original (I think), amended it and saved it, but the amendment didn't stick. I'm obviously doing it wrong.
