I have a query that has a field called "vaultNo" and a variable from a form
called lngreleasenumber.  I'm trying to set the filter to the vaultno that
equals the variable I supply.  I call myself following the example in the
"ApplyFilter" help with no luck.

Does anyone know how to get rid of this error or avoid this error:
Data has been changed.  # 7878
It usually occurs when I'm deleting records in a form.
Thanks,

Hello, Could someone help me with this problem, I have a form with
product displayed on it from a product table. I want to be able to add
that one record that is in view to another table for ordering when the
user clicks on a  button for "Order Part". I have tried everything I

I have a stand alone application written in MS ACCESS.
In Appointment form I have now the problem - cursor spontaneoucly jumps to
the very left upper corner of form.  What would be the reason for it and if
there is a way to fix it?

Right now I've got a text box on my form that is formated mm/yy.  In the
table in the date field it is formatted mm/yy (even though I know it's really
stored mm/dd/yy).  When users go to enter info, they think they just need to
enter mm/yy, but access reads that as mm/dd, and ...

When I enter a level 1 value I want a drop down box to show what choices are
available for the level 2 value.  Then based on level 2 value another drop
down box and continue this through 5 levels.  From level 3 on I want the next
available unused value.  Example:

Hi - I have a unbound form / subform - works fine - but do not like the
appearance of it.
I prefer 'Northwind - Categories' form. I have been trying to copy this, but
cannot think how to code reading from a query and putting text in appropriate

I have a form with text boxes, combo boxes and a sub-form.  Whenever the
user scrolls to the last record on the main form using the navigation
buttons and then moves to the empty (new) record and then scrolls back to
the previous record, Access attempts to save the blank record ...

In a multi-user environment with users in different locations with different
printers is there any way to programmatically set the paper size in a report
for each user based on their printer selection?
On the same report they need the option to look at this report with letter,

I have a large database with tool history.  I want to use that history
to generate work orders on a scheduled time interval lets say once ever
week / month ect.
This is a little beyond the scope of anything that I have done in

I am attempting to link forms to one another in Access.  Using one button, I
want a subsequent form to open based on ID number, and the previous form to
close.  RIght now all I can do is open it up non-specifically.  Can someone
help?  I'm attempting to write the code but I don't ...

I to duplicate a record (everything but the key field).  If I use the
following code for my button in the form that I am duplicating, then it works:
   If Me.NewRecord Then
       MsgBox "You are on a new record." & _

im getting a runtime error of 3061 to few perameters. Any ideas that
would help my situation?
Set extract = CurrentDb.OpenRecordset("SELECT * FROM
qryZerosAndBlanksVoids WHERE [Invoice_Week] >= '611' AND [UPCCase] IN

Good Day,
I presently have a set of code where if the conditions are not met as
specified a text box pops up informing the user of this error. I would like
the text box (  txtDeed    )  to reset once they click the ok of the msg box..

Does anyone know of a way (perhaps even a third-party utility) that would
compare the contents of two tables and identify any records whose data has
changed?
I'm not talking about using an unmatched records query.