Subject is extremely vague, let me explain:
Have a table with the following fields:
ItemID (Pkey)
Price1

I am trying to delete a table prior to rebuilding it in code. Thsi works fine
the 1st time I run the app after loading the database:
   DoCmd.DeleteObject acTable, "Commonality"
On subsequent runs, however, I get Run-time error '3211': "The database

I'm trying to create a combo box that has the only the field names from
a table in it and not the items in that field.  So for example I have a
table with 40 fields in it like Account#, Name, address, phone # etc...
I want to click on the combo box and have the option to choose a ...

How can I set up a database to display a decimal input as a fraction.  I
would like to type in .5 and the database will show this as 1/2.

When I run this code it takes up 100% of my cpu time.  I think it's because
for the find first but don't know how to change it to work properly.
Any advise would be appreciated.
' Find the record that matches the control.

MS Access 2K/2003; Win XP Pro
The rowheight in a datasheet in Access can be dragged and resized by the
users - but how can this functionality be disabled??
thanks for any ideas you may have

I need to compare two ADP files A and B.  I need to incorporate the
differences in file B into file A.  Is there a tool I can use that will
assist me with this?  I tried using Windiff but it appears that only works
with text files. Any help would be appreciated.

Please forgive cross-posting, also posted in
'microsoft.public.access.modulescoding'.
I have 'inherited' a part complete Access 2000 database which has in it the
module shown below. The idea is, I think, to take a number of days and a

I have a string that is like:
"Self-Assessment 3 which covers:  MFG14, MFG15"
or
"Self-Assessment 5 which covers:  MFG19"

can anyone tell me why the following code causes access to crash?  the
control in question is unbound, fyi.  strangely, i ran through the code step-
by-step and it didn't seem to crash until after it finished executing but if
i remove the code, it won't crash.  i'm not a developer ...

Access 2002 SP3 on Windows XP-Pro. All critical updates.
Access 2002-format single user database, split front+back ends.
One instance of Access running.  
No relevant LDB files before or after run.

By oversight I named one of my fields "Date" in the SQL stmt for a form. I
realized the error of my ways so I changed the name of the field from "Date"
to "ApptDate" so as not to conflict with the system's Date() function. I also
replaced all instances of the field name "Date" in ...

I'm so close! This will be HUGE if someone has a clever way of doing this. I
have a graph that shows sales data. The date is on the x axis and sales are
plotted on a line graph. Pretty standard graph. The source data is a table
called Shipments. It has two fields: DayDesc which ...

What API call do I need to use to capture the system time from another
computer (server)
example:
something like the DOS command:

For simplicity, I've slimmed the scope of my problem down to three fields...
1.  I have a form that is bound to a table with a couple fields - PersonID,
FirstName, LastName.
2.  I don't have a control on the form that is bound to PersonID, but I can