How do I add leading zeroes to a field? For example I have
a field named "Course_ID" when a user enters 10 I would
like to show it as 00010.
Your help is appreciated,

I have two questions:
1) I am creating a table with a SQL statement that takes data from another
ODBC linked table. The PK of the source table is created as a non-PK number
in the created table everytime the SQL is executed. How can I ensure that

I don't see the purpose of an autonumber field since a
record cannot be linked to another table with it because
the numbers wouldn't tally.  I know I'm missing something
but I can't see what!

Since security is not something I can do easily (someone
will do the job in november), but I do need sóme sort of
security soon, I have created an external database with
the variables DATA_ENTRIST (name of the person who does

I've been told that you can improve the performance of a Jet database if you
index all fields used as criteria fields in queries.
Of course I'd always like to speed up my databases, but I'd also like to
know if there's any drawback to creating lots of indexes in the database.

I received error 3197 when I tried to start my access database.  It stated
that the jet engine could not continue because another user and myself were
trying to access the same data.  However, I am the only person trying to
start the database.(it is stored on a removeable ...

I have a list of water users in a city and some of these
users own several properties in this city.  I need to
make an unique list showing the users and their multiple
addresses all on one form along with the problem

When I try to open a table I receive an error message "Type Mismatch in
expression" followed by a notice that theTable cannot be opened in table
View.
Can anyone suggest what I should look for. I haven't made any changes to the

I have a database which is for recording inspection criteria...code, lot
number, result, date reconciled. In order for the system to report if a code
is to have a lowered inspection criteria i have to examine the last 10 code
entries on the database but at the moment i cant find ...

How can I stop users from copying my back end data base to different
locations. I still need all of them to be able to access it with the front
end.

How would I get the drop-down to display the recognizable Name and input the
corresponding Key?
I've got a couple of tables, one for expenses, and one for payee
information.  Rent Check -> Condo Asso.  So I've got a one to many

I need to set up a database in access which will allow me to report out
various fields regarding our after school programs.

Have migrated from old pc (win 2k, O2K) to new PC with WinXP and OfficeXP
Pro.  Brought over old Access databases to the new machine.  The reports will
no longer print and display error:   "Problem retrieving printer information
for the object.  The object may have been sent to a ...

Having a problem exporting an Access DB to a DBase file, I
get a dialog pop up saying:
"Field will not fit in record" and the export fails.
Is this because there is a field in Access that contains

I am having a problem using the Link Table Manager with Access 2003. I found
Microsoft Knowledge Base Article - 835519 and followed the instructions to
register the DLL. However, it still does not show the list of the linked
tables.