Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Data Entry

Posted on 2011-10-07
2
Medium Priority
?
302 Views
Last Modified: 2012-05-12
I have a form called “Scheduling-Add” which is used to schedule a patient. This form has a “Patient Name” button when clicked will open a “Patients” form used to add a new patient. I want to use the following criteria to check for duplicate records before saving a new patient record

If the new record has No “first name” Null but has a “DOB”, it checks the “last name” with the “DOB” and any other field filled to see if it exist. If it does message is displayed “name exist and cannot save” or if not duplicate save record.

If the new record has No “DOB” Null but has a “First Name”, it checks the “last name” with the “First Name” and any other field filled to see if it exist. If it does message is displayed “name exist and cannot save” or if not duplicate save record.

If the new record has a “first name” & a “DOB”  (Not required fields), it checks the “First name”, “DOB” and “last name” and any other field filled to see if it exist. If it does message is displayed “ name exist and cannot save” or if not duplicate save record.

Lastly if nothing is entered, don’t save. Display message saying “Data required or close to Exit”.

Invoice-7-7-2001-91611.accdb
0
Comment
Question by:Chrisjack001
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 36932945
This question is very similar to your other question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27383499.html
Is here any difference?
0
 

Author Closing Comment

by:Chrisjack001
ID: 36933192
It is . Glad that you solved it.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question