I am trying to devise a system for checking out files and
I have four tables 1)Files in file room 2)People who check
out files 3)People who deliver files 4)File Check Out
Table (This table include barcode (Lookup frm Table 1)

Here's my situation. I am working on a new data design for tracking the
reasons an application gets rejected. There was previously a paper form with
a bunch of categorized reasons. The person who originally built the database
only put in enough room for 3 categories and 2 reasons ...

... Word, Excel and Publisher
I would like to create a database for mailing (snail mail) using Access and
then interact with Word for my client's mail, with quick client data
selection, print my envelopes and bank forms in publisher, and invoices in

I have been given a project that was done by an intern who no longer works
at my company. In his database design, he put the master table in a seperate
file from the supporting tables and forms. The only thing in this other file
is the master table. He then linked the table into ...

I have a problem with my access program. The problem is
that data were allready entered in the program without an
ID number. How can I include the ID number without doing
it manually?

I accidentally created a table field name with a space in
it. Is there a way to remove the space in VBA? I've
already distributed the application to end users and I
don't have access to their back-end data except through

I have this simple bat file that does the following
del file1.txt
rename file.txt file.txt
This text file is on a server and I am trying to set it up so that I can do

I have a column that contains the first and last name.  
How can I seperate into two columns, one for first name
and one for last name?

I need to show my husband how to use Microsoft access and wouldlike to
download a copy of an instructional manual or pamplet.

I posted the below message on the board Saturday and I
haven't received any help at all.  Just wondering if it's
too complicated, I didn't explain myself, etc. I just need
some type of direction and I was hoping to get some help.  

Please help,  I am trying to open a new file in Access to create some tables
and forms for school.  However, it is asking me for my SQL driver that I want
to use.  I don't know where to look for that or find what it is to input that
information.  Where do I look? How do I find ...

I have a table tenants, that has the following
fields: "OccLName" & "OccFName" and i like entering the
info this way. However, to join it with another table, i
need to have the names "OccLName, OccFName" as this other

I have a DB that I acquired from someone at work. This DB
is used to track employee training on company procedures.
The DB is not set up properly. Example: In the employee
table, there are not separate fields for employee name.  

Hello folks. I'm relatively new to MS Access and I'm having a Dickens of a
time figuring out whether materialized views are supported in MS Access, or
even virtual views for that matter. I suspect they are, but...
Cheers,

I have been tasked to do this program that should compare
data that is on the same table. On the following example
it would be shown ideally what the answer should be for
the Time Frame field: