Hi. My problem is that one of my tables will not allow me to add new
records.
My tables (and relevant fields) are as follows:
tblContacts

I have two seperate records in a table: Month (mm) and
Year (yyyy)
Is there a way to format/update these seperate records
using current Month and Year as individual data? I am

I am calling the following procedure in a module to print
a report and save it but it always runs the DoCmd even if
the user chooses vbNo.  Any suggestions?
Public Function printoptions()

Access 97
I have a table that has only one row.  I have a form that allows the user to
edit the values in the table.  However, I also want to prevent the user from
adding additional rows.  Is there any way to do that?

I am wrestling with this question. I am building a database with customer
info. The customer lists come from 4 sources:
1.Customers that have done business in the past
2.Customers that have NOT purchased but visited the business (walk ins)

The rookie's at it again:
Forms
  Assets
     Click depreciation

Is it possible to store entire documents, such as a
resume created in Word, in Access?  I am trying to add a
feature to our corporate intranet that will allow
employees to browse resumes and writing samples by

I am attempting to import a tab separated text file into
access as a new table.  There are the equivalent of
374 "columns" (variables) in this text file, and of
course Access will only store 255 of them.  I don't care

I am not able to open the lookup wizard in table design
view. I am using access 2000. I newly upgraded my os from
windows 2000 pro. to Windows XP when this problem started.
This message comes - "Microsoft Access can't start the

I am designing a small rent property database in access 2002
i have my designe all normalised but i am having a little problem in
recording the rent payments and the amount paid.
the property table contains the rental amount per week

Have 6 digit employee ID numbers in excel. Need to import
to table in access. They will be primary key. Majority
begin with 00. They are fine as "text" but when I change
to number, the zeros drop off. I am sure the answer is

I want to have two fields for each record in tTable:
DateCreated
DateLastUpdated
I use a form to update the table.  Can someone please point me to the design

I have a database that has up to 30 users updating a table
consistently throughout the day. The table locks up
multiple times during the day. Why does this happens and
what can I do to avoid the table locking?

Is there any way to make the contents of a cell in a
table a specific color?
thank you!

Lost one of my tables during a power spike.  How can I
retrieve it back??