Recent content by Accessless

It's actually a query with a pop up message that says "Enter Client Number" Then, once the number is entered and you press OK, it displays the info in a form. If the number is not found, it just goes to a blank scree (which is what I'm trying to avoid!) The initial thread started here Query...

Hi, in a previous post, I was helped to design a form that retrieves Client info from a table using a query. SELECT [MASTER KEY LIST].[Key No], [MASTER KEY LIST].[Client Name], [MASTER KEY LIST].Address, [MASTER KEY LIST].Comments, [MASTER KEY LIST].[M-1], [MASTER KEY LIST].[M-2] FROM [MASTER...

I see what you're saying! The way we operate is like this: A company calls us on behalf of a client, leaves a message using only a client number. We record this number and give it to a driver who is dispatched. Using his onboard laptop, he finds the appropriate info about the client (while...

Well your method works really well but has one drawback (maybe it can be fixed) The arrow displayed in the combo box allows you to see the rest of the records. So if someone types in 38, it will complete it and find a record but if the user opens up the arrow, he might select the wrong client...

Thanks, I tries both methods and they both work fine. But, I still haven't figured out the Client Number "Not found" thing if I use the Query. Is there a way to compress this into a little file so you don't have to open Access every time? Thanks

Nice, thanks for your help! I did what you said and it seems to be working great! (let's burn the binders!! :D ) 2 questions: - When i enter a Client Number that doesn't exist, it takes me to a blank screen, how would I create a pop up message that says " Not Found, Please Enter Client...

Andrew, first of all, thanks for tutoring me! :D I tried exactly what you said and it worked (of course) I tested many numbers and even if there are numbers such as 3, 33, 333, 1033: it will only pull what I input--> Which is perfect!! So this is my Query. When I put a number in, it...

Great forum!! Hope I someone on here can help me! Here's the situation. I have a Database in Excel (~3000 rows & 7 Columns) The first Column has numbers like this (3-10-34 or 223-7-45) the other columns have names, addresses and other stuff. What I'm trying to do is to eliminate the use of...