I am having a problem with a function that I have created in the past in
Access2000.
Now I am using Access2003 and some somereason this fonction does not update
my table at all, the db does not generate any error at all. I use Step by

I have a form that is set up as a Continuous Form. It's based on a query
which has multiple tables joined together. The Views Allowed property is set
to Both, Allow Edits is set to Yes (I only want to allow updates, not
additions or deletions). None of the fields are locked, ...

Ok, I have a database that will be passed around corporate and nationwide
which asks users to select pictures, which will return its respected file
address into a table.  Understandably, most users have these addresses
mapped, thus a common address would be H ...

In one of my tables I have a field that is 'AutoNumber'. I would like to
reset the number, before delivery to clients. Please tell me how to reset
this field.

I've developed an application that will accept data inpurt from a scanner.
The method I've used to take in data and process it is by using the
_AfterUpdate event of a text box contol that has focus. Now, this works well
until the system somehow changes focus to another control on ...

I've got scads of DAO "set rs = db.openrecordset(..." calls throughout my
application, and I thought that it might be a good idea to centralize the
connection for all of these calls into a single function so that if/when I
change my datasource (e.g. from MS Access to SQL) I can ...

How do you reference a control on a parent form from a subform?
My subform is not tied with a unique identifier.  The sub form is like a
valid value table and I want to update a table that need the parent forms
uniqueID.

Dear,
On a form I have 2 fields, both originating from the table that is the
RECORD SOURCE for the form.  Let's say these fields are FIELD-A (text box)
and FIELD-B (combo box).

When I use the 'Delete record' command the system message appears 'You are
about to delete one record etc, etc'.
In one particular instance I do not want this message to appear.
How can I turn off this message in this one instance.

OH SMALL PROBLEM ARE BIG PROBLEM. ANYWAY I HAVE A STATEMENT IN VBA
SOMETHING LIKE THIS
"C:\BUSINESS\FURUC SPC\CUSTOMER FILES\ME.PART_INFORMATION.[PART_NUMBER].ACCDB"
WHAT I AM DOING IS CREATING NEW DATABASE, THERE IS FORM CALLED PART

2 questions related to the usage of DLAST.
1) How do I trap that the record I am looking for does not exist?
2) I need to fill up several fields based on the last retrieved record.  
Currently for each of those values I am applying the DLAST equation

I need urgent help to solve a VBA problem. What is the syntax of the Select
case statement for the following:
I have to fields in a subform...One is a combo box which has values A,ItemA;
B,ItemB etc

I am at a loss why I can't get a simple price.
Public Function ServiceZone(Mileage) As Currency
   'created 8.22.2007
   Dim Crit

I have an application in Access 2007 in accdb format.  I am on a stand alone
workstation with 1tb disk and 4gb ram, running as administrator in Windows
Vista Ultimate.
The current problem is when I try to copy a database using copyobject or

I have a subform that has a combo box.  When someone enters an item not in
list I would like to open a custom form (which I created) and allow the user
to fill it in with the new data.
Here's the tricky part.  Once the custom form is closed I would like the new