While attempting to insert a duplicate record into an indexed field using the
DoCmd.OpenForm method after clicking on a command button I, of course,
receive a key violation warning. Based on that warning, I would like to open
a form that lists all of the records rather than ...

Is there any easy way to get the columns and there data types out of Access
in a report type format???
Are there any like "canned" reports in which you can get the contents of the
table??? The columns that make up the table and their corresponding data

I've been running into this recurring issue lately and I'm wondering if
someone has any feedback/direction they can give.
I find that there are situations where, in an app, I might want to attach
someone's name to a particular record yet I know they will never need

I'm importing data from a text file into a table.  The downpayment amounts
for each record are shown as 000068800 for $ 688.00 or 000201400 for $
2,014.00.  I've t ried every format option and changing the decimal place in
my table design but just can't get the text data that I'm ...

I am working with an access 2003 database that contains comments that are
updated on a regular basis in a form method. I am looking for a way to add a
new field to the record once a new comment is added that will be linked to
the project ID number and also include a time stamp.  ...

All of a sudden SQL linked tables do not show up in Linked Table Manager
(Access 2003). I have run regsvr32.exe "c:\Program Files\Microsoft
Office\OFFICE11\Accwiz.dll" and rec'd the message DllRegisterServer in
c:\Program Files\...\Accwiz.dll succeeded. However, the tables still ...

How do I enter vertical text in an label in Access? I would like the text to
be read vertically instead of horizonally.
S
h

I am thinking of creating a database in Access 2003 for a restaurant.
I need it to be able to handle constant use every day and night to
record all orders and bookings (10 or so tables). There should not be
masses of data involved. Security (from unauthorised access) is not

I am running the following code to import all text files that all start with
the same 12 characters:
' Set the parameters to import the text file
      If Right(Me!txtFilePath, 1) = "\" Then

I have a calculated "Total" field in my form. It calculates just fine but,
the value will not populate to the table. I open the table, see the field but
it remains BLANK.
Need assistance, s.v.p

I have a memo field in table A that contains " (special character).  I need
to update table B with the memo field from table A.  However, Access
compalins that the string used to update table B is not formatted properly
because the memo field in table A contains " characters.   ...

Access 2000 & Excel 2000
I have 6 linked dbf tables to MS Access on a server which are
automatically updated each day
Queries are written in Access and Excel is used to extract data

Hello newsgroup,
i have a microsoft access 2000 database. Now, i have to install it on
the pc of our customer. The customer has installed 2003. I can export
all data, but i can not open the reports of this database.

Hello experts,
Is there an easy way to covert a text box to a combo box.
I have a completed form based on a table.  I want to change a text box
on the form and insert a few lookup fields in the row source.  I

I have created a music database and would like to be able to hear a sound
byte of the music when I view the titles. Is it possible to include or attach
a soundbyte to db records? If so how is it done? I can create individual
sound files of approximately 10 seconds, but once it is ...