I have a MS access database table for which I regularly need to import
fixed width text data. At present I have to to cut and paste the text
data from its source to a text file, save the file, import the text
file as fixed width text [it is not naturally delimited], and then run

I am designing an order database at work and am having problems
creating a specific report I'm after.
Basically, each order has an 'order type' and what I would like is a
report which lists the order types and simply gives a number as to the

I have two questions here:
(1) what is the difference of close form and close table?
(2) How "Prompt" works
I  used close form macro in my database. I hope when a user close the

I am sure this is an easy question for most people, but I can't seem to
figure this out. I am running a report and would like to count the
specific number of people with a given status. My report lists 248
people that I work with, and their statuses are either Temporary or

I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update query
to run in the background, and not ask the user for any perrmissions. I
was thinking to run the query as part of the autoexec macro.

I'm fairly new to Access and SQL.
My sense is that my question is fairly basic, but I still need help
with it.
I have a table with players who are listed either in the fields

I have a table of customers who may have purchased numerous types of
products. Finding out who purchased what is easy. However, what I need
to determine is which customer has purchased ONLY one or two
particular products and NOTHING else.

G'day ppl
Is there a process whereby I can copy the text labels of all the files in a
root directory?
I recall going back a long way seeing something about it but did not take

Using Acess2003; when writing code, etc. and when attempting to use the help
files while in visual basic window, I recently started to get this message-
"A runtime error has occurred. Do you wish to debug? Line 114 Error:
Operation is not allowed when the object is closed." So if ...

I have a database on a server that many people access repeatedly during
the day. I have set up the switchboard form with code to minimize the
database window, but when I try to open the database window it opens
off screen so far that I have to close the switchboard and go find the

I have a MS access database which has entries (each of which has a name
field)  and uses a form to make new entries. I would like to put
together code that will run when a new entry's name is entered that
does the following:

Any help on this one will be greatly appreciated as I have spent too
long banging my head against the screen trying to get it sorted.
Basically I would like to have a select all records option in a combo
box that is used in an unbound form for my report parameter.  I have

Am I correct in that I need to purchase Microsoft Visual Studio Tools for
Office 2003 in order to create a runtime module. I own Office 2003 Pro as
well as a stand-alone Access 2003.
Thanks,

I have a split db that on the dev versions w/ test data in the tables i
have edited the relationships.
Is there a way to move the relationships I have created in the dev db
to the production db?

I can't seem to figure out how to creat a one to many relationship
access 2k
in the relationships window i drage the primary key from one table to
the forgien key of another.