Is it possible to provide an input mask or a validation rule so that the
entry must have at least one alpha character?  Any number of characters is
acceptable.
And, would it also be possible that it start with a digit?

I would like to dedup a file but ignore nulls.  So there are 15,000 records
with a IDnumber, state and reportNO - some of the IDnumbers are null.  If I
make the table key for those fields it sees the nulls as a dup and doesn't
append.  Any ideas?

I previously posted this question.
I am using the SendObject method to email a report as a Snapshot. The name of
the report is rptBilling. It names the Snapshot the same thing. How do I
rename this? I would like to name it “Bill For (first and last name of person

I am working on a project that has 80 users working with an mdb file that
only has linked tables in it. Via our gui the users query, insert, delete and
update rows in the linked sql server tables. For some reason the mdb file has
been growing to a very large size which has caused ...

I have used Access since version 97 and now investigating what 2007 offers. I
am stuck at a point that should not be stopping me.   I have spent hours
searching but without luck.   My issue is:
I created the Contacts example database.   AutoExec, opens the Getting

I am testing a system and using an access 2007 database to hold tests and
issues information. When a test fails, I store the details along with any
references (screenshots in a word document) in an "attachments" field on my
database. I then send reports (snapshot format although ...

I am working on an access database. I am receiving a “record to large” error
on a table, which contains 970 records. This error is affecting how that
information is pulled into the reports and forms. It is not allowing me to
change the data in the fields or rows due to the error. ...

I want to log the details of the computer user ie user name, when they use
the data base.
Can some one please point me in the right direction.
I am using access 97 but moving to 2003 shortly.

I am entering data into a table which has an AutoNumber field as Key. After
record number 176 the field is generating a new sequence starting by 1299356.
I wonder what the reason could be and how to solve this issue?
Thanks.

I have been doing my Access development om a 'normal' desktop but I need to
go portable. Anyone using a laptop and can recommend one?
RAID 1 if possible?