search for criteria and doing checks

[Epsilon101]

Hi, there are a couple of things i am wanting to do, i wanted to ask someone who has most likely done this before some pointers on how to actually do it.

I have a table holding a customers lead info, in this case it is their first name, last name, proposal number (optional), date customer entered into dbase, and a customer ID (just primary key made by Access).

I have 3 other separate tables each related to the customer lead table by the customer ID. These 3 are the details we keep on the customer.

I wanted to work on a form for entering a new customer, where you enter the surname and firstname in separate text boxes, click a button and then it will search the lead table for a record which holds a first name and last name matching what has been entered, then have a msgbox that says existing customers have been found by that name (maybe even a count of how many where found), then an option for the person to create without looking at the ones found, or clicking yes to view them and going to a form with a continous setup for a query that displays these customers with matching names, with just their lead info, and a details button that you can click while the record is selected in the query to view all their details,
so you can check the customer already exists or not.

I also wanted to try and do a form where you can do a search criteria where i have several text boxes where you enter what you want to look for and that filters the search more and more, ie i want to find tom brown, date created 12/05/2004, etc. the more entered the smaller the results will be, to do an accurate search.

Any help on this would be good
Thanks

---------------------------------------
If God is a DJ, Life is the dancefloor, we are the music, then who are the dancers??
.........

Neil

 

[PHV]

Take a look at Query By Form (QBF)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Epsilon101]

Hi i have just been checking the help system i am using Access 2002, i typed in query by form in the vb help and the Access help it didnt bring up anything called that, also did it for (qbf) is it called something similar?

---------------------------------------
If God is a DJ, Life is the dancefloor, we are the music, then who are the dancers??
.........

Neil

 

[Epsilon101]

I have setup a query to run off the first and last names that are entered into the new customer form, how do i get it to come up with a msgbox when something is found?? Do i need to use database.openrecordset command and type the sql statement into vb or can i do this off the query??

I am trying to get it to say:
Matching criteria found would you like to view, yes or no.

If no then it goes to msgbox asking if they want to create this as new customer.

If yes it goes to the form showing the query results.

If no matches it goes straight to the msgbox asking if they would like to create as a new customer.


---------------------------------------
If God is a DJ, Life is the dancefloor, we are the music, then who are the dancers??
.........

Neil

 

[PHV]

Take a look at the FAQ area of the Access forms forum:

http://www.tek-tips.com/faq.cfm?spid=702

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244