ACCESS 2000 SEARCH FACILITY ON FORM

[Scunningham99]

Hi

On a standard form ACCESS2000, say a tabular form with customer details (forename, surname etc)

We would like to use a text box, so that when text is entered into it it searches on surname. For example if i was to type in Cunni in the text box it would narrow down the customers and diaplay all with Cunni proceeding.

Im not sure if this is possible using code on say the on change event of the text box or something??


Thanks in Advance
Sy UK

 

[Dreamboat]

I like to put mine in the form header:

Control Toolbox.
Combo box.
Draw the box in the header.
The wizard should pop up and if it doesn't, you didn't install wizards, go do that.
Now, the wizard pops up and gives you 3 choices. Pick the one that says something like find a value and show me the record on my form... Anne Troy

http://www.TheOfficeExperts.com

 

[Dreamboat]

You inspired me. LOL

http://www.theofficeexperts.com/access.htm#SearchForm

Anne Troy

http://www.TheOfficeExperts.com

 

[Scunningham99]

great thanks!! Sy UK

 

[smurf01]

Dreamboat, is it possible to tell it to show say the last 6 records containg the data Regards

Paul

 

[Dreamboat]

I think you need a QBF. Try these:

thread701-472565

http://support.microsoft.com/default.aspx?scid=/support/access/content/nwind/T-Art_093.asp

http://www.experts-exchange.com/Databases/MS_Access/Q_20278815.html

I think you'll figure it out from there.
Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: WordX Addin!

 

[smurf01]

Dreamboat, sorry i may have mislead you slightly, I have created the parameter query which retuns the data i require however, sometimes this can be as many as 20 records and what I was hoping to do was to show the 6 most recent Regards

Paul

 

[smurf01]

Dreamboat, I am going to start again

I have a table which contains a field called "completed" the purpose of the field is to show whether the record is complete or outstanding. The values are as follows
0 = outstanding
1 = completed
I have created a parameter query which asks the user which value to use, if the user chooses "0" then the query runs and if there are no records the query is blank, if this is the case they will then need to look for records that are complete,they then have to use "requery and enter the value of "1". What i would like to achieve is that i put some code in that firstly automatically queries for "0" but if there are no records it will automatically requery using the value of "1".

To further enhance this if the query uses "1" then it only displays the last 6 records entered

Hope I have not confused you too much

Regards

Paul

 

[Dreamboat]

No. But I'm not a coder. You might want to try the Access or VBA topic areas.

Sorry.
Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: WordX Addin!