473,396 Members | 1,933 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Determine if searched for customer exists in table

15
I found a terrific thread in this forum called "How to create Search form for database" that shows the VBA code (with an example program) needed to create a search Form using a textbox.

This is the link to the original thread:
https://bytes.com/topic/access/answers/696948-how-create-search-form-database

Jim Doherty posted the solution and example and it was very much appreciated!

While the code accounted for an empty textbox, one thing missing was a way to make sure that whatever the user entered in the textbox would be checked against the table to be sure there would be a matching record. I could use some help modifying the code to make sure that if there isn't a match a message could pop up stating this and asking the user to try again.

Thanks for any help you can offer!
Feb 17 '16 #1
1 800
NeoPa
32,556 Expert Mod 16PB
Add an AfterUpdate event procedure that checks the data entered against the table. At it's simplest this could use the DLookup() function.
Feb 17 '16 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: OvErboRed | last post by:
Hi, I'm trying to determine whether a given URL exists. I'm new to Python but I think that urllib is the tool for the job. However, if I give it a non-existent file, it simply returns the 404 page....
3
by: Daniel Borden | last post by:
Big hello to my fellow programmers - I'm new to javascript and PHP and I am wondering if there is a method or function to capture a 404 error in the event a particular html file cannot be found. I...
6
by: TTD | last post by:
Hello, I need to create a directory in code, but when de directory already exists, I get err.number 75. Since the creation already is in the part where a former error is sent, I can't catch...
6
by: Opie | last post by:
What would be a more efficient way for me to determine if a record in an SQL DB table exists? Right now, I have a try/catch like this: try {...
2
by: Tom | last post by:
Is there a clean way of determining if a propery exists in a form/class at run time? I know I could do something like: Try If form/class_property=something Then 'Do exists processing Else 'Do...
2
by: Wayne Wengert | last post by:
I am trying to determine if a file exists on a web site but I cannot get a match. I have verified that the file does exists in the specified directory (I verified the case of the file and directory...
2
by: yofnik | last post by:
How do you check if a function exists in IE? If I try the following: if(document.selectSingleNode) { document.selectSingleNode(xpath); } I get an error saying the wrong number of arguements...
1
by: Blue Lagoon Products - Customer Services | last post by:
Hi, We have an inhouse database that I designed in access 2000 with the help of all you guys some time ago. It stores orders and prints packing slips etc. I would like to put onto the packing...
5
by: newP | last post by:
Hi, I have to programmatically determine if Oracle Schema (Database) exists. Is there any query I can use for that? e.g. in SQLSERVER 'Use myDB' would work and give me an error if myDB doesn't...
1
by: sampalmer21 | last post by:
Is there a way I can find out if a database I have created exists in the sql server using ado.net methods? How about determining if a table exists, or any other database object for that matter? ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.