Mr. Kempf, in view of the impending demise on 6/1/2010, I suggest you copy
the message you posted here, use it to create a web page, and make it
available to all as "'All you need to know about Access' by Aaron Kempf".
As your advice is invariably the same, you wouldn't need to invest in
anything more than a "starter" website package.

Doesn't it bother you to be recommending something (ADP) that is no longer
recommended by the Access team, and a strong candidate for deprecation in
the near future? Or, do you enjoy luring unknowledgeable new users down a
dead-end path, just for the fun of it?

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"a a r o n . k e m p f @ g m a i l . c o m" wrote in
message
...
I don't think that it's practical to store payment information in an
Access (Jet) database.

It's just not possible to secure a jet database

Move to SQL Server if you want to keep your data secure. I really
reccomend Access Data Projects, they allow you to use Access forms and
reports.. and additionally seamlessly use Stored Procedures, Views,
Functions, Triggers, etc






On May 25, 9:34 am, Bardia wrote:
Access 2003 form with several controls including following:
1- Payment Type (combo box) that contain three entrees: CASH, Check,
Credit
Card
2- Check Number (text box)
Question:
What procedure or code I have to apply and to which event in property of
Check Number Control that if user chose the Check in Payment Type combo
box
to be forced to enter a check number into Check Number control before
record
could be saved?

--
Bardia