Prevent Uncomplete records

R

Ron

Hi all,

I have a form with few fields that create the record.
How can I force/notify the user to fill all fields?

Is the method of (If IsNull........then..... exit sub ) is the only way?

There must be better way to do it.

Thanks,

Ron
 
J

John W. Vinson

Hi all,

I have a form with few fields that create the record.
How can I force/notify the user to fill all fields?

Is the method of (If IsNull........then..... exit sub ) is the only way?

There must be better way to do it.

Thanks,

Ron
Click to expand...

Well, what's wrong with it? I take it you're using the Form's BeforeUpdate
event.

It's less work for you to open the form's Table in design view and make each
such field Required; however, that is harder on the user because they get a
possibly-confusing error message, rather than one that you handcraft ("please
select a vendor"... setfocus to the vendor combo box, vs. "Unable to save
record: validation failure on VendorID" or some such).


John W. Vinson [MVP]
 
T

Todos Menos [MSFT]

with SQL Server, you can reuse FIELD VALIDATION in a concept called
_RULES_

Access MDB has nothing simliar
If you really care about data integrity; you should be using SQL
Server and not MS Access

FILE, NEW, PROJECT EXISITING DATA
 
T

Tony Toews [MVP]

Todos Menos said:
with SQL Server, you can reuse FIELD VALIDATION in a concept called
_RULES_

Access MDB has nothing simliar
If you really care about data integrity; you should be using SQL
Server and not MS Access

FILE, NEW, PROJECT EXISITING DATA
Click to expand...

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
T

Tom

Thanks Tony,
I have no clue in SQL.
Is it possible to connect Access with MySql?
Is MySql is object oriented like Access?

Thanks
 
T

Tony Toews [MVP]

Tom said:
I have no clue in SQL.
Is it possible to connect Access with MySql?
Click to expand...

Yes, it is possible. You need to install a MySQL ODBC driver though. And it won't
integrate quite as well as SQL Server will.
Is MySql is object oriented like Access?
Click to expand...

No idea.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
T

Todos Menos [MSFT]

Tony

yeah no shit you don't know how to spell SQL

why don't you STFU and go and play with your baby database


if you give a shit about your data, you should be using a database
SERVER
 
T

Todos Menos [MSFT]

Tony

yeah no shit you don't know how to spell SQL

why don't you STFU and go and play with your baby database


if you give a shit about your data, you should be using a database
SERVER
 
Top