I'm helping someone implement security for a small office.  They
would like to use just one sign-on for the people at the front desk -
so 3 individuals would be signed on as the same  user at the same time.
Will security allow this, are will each individual need a different

I tried the following code to prevent a checkbox from being
updated (going from a value of Null to True, from True to
False or from False to True). I was surprised it did not work.
Can anyone offer a sensible, logical, insightful reason as to

I want to create a custom auto number in a form that looks like
"CRA05001" where "CR" are fixed characters, then "A" should be for
January as "B" for February and so on...(this part will change
depending on the month, "05001" is the year "05" and "001" a sequential

I have a table with only two columns (created from query of a much
larger database). The first column contains many "duplicate" names
or ID, and the second column contains values which need to be
summarized by by each name or ID. How can I do this automatically?

A query based on TblEmployee shows TblEmployee in the query window. Is there
a way in design view to change this query to self join T1 and T2 on
EmployeeID or does it have to be typed in in SQL view? This question is
about getting T1 and T2 for the names of the tables in the ...

I have split an Access 2000 database which is about 25 mb (lots of memo
fields) into 2 DBs by making two copies of the DB and deleting the (large)
table from one of the copies and linking that DB to the DB which still
contains the table - ie I now have:

I need to automaticaly print new records/reports in an Access database
to a labelprinter. Can this be done?
The records are added with asp code.
The Labelprinter is a Brother QL-550

I need to produce a macro for a project that I have to do in my course in IT
"Certificate III IT (Software Applications) Unit ICAITUO18C". The macro
needs to validate previously imported data from Text Files. I have already
written the macro to import the data and now this ...

How can i select a directory on my hard disk and second
How can i have in one list the files from one directory (c:\data)

My company has recently migrated from NT to Xp and in the process from
Access 97 to 2003.
One minor problem (but major annoyance) we are encountering is the Security
Warning when you open Access databases in 2003.

I have an application that produces examination scores.  Candidates have a
choice of sitting 1 of 2 subjects or both.  I have produced a query that
gives all the results for candidates that sat subject A.  This contains some
fairly complex calculations.  My problem is that I need ...

I have three tables and the way they are currently set up violates good
normalization, but I'm having trouble figuring out a better way. Can someone
suggest a more elegant solution?
My tables are:

How do I import the records from one database table to another?
Can anyone tell me the steps to do it

I am using Access97.
I wanted some VBA code to run each time the Access MDB is opened.
I was looking for an Database_Open() type function but I can not seem
to find one.

Once in a blue moon Access 97 or Word 97 has been causing the whole computer
to go extremely slow. E.g. 2-3 minutes fro the Access 97 splash screen to
appear.
Has anyone else experienced this and found a cause?