I have 3 tables one has cutomer info. the other has the related orders for
that customer and the 3rd is old customer/order info.  
What I need to do is move the data from the order table to the old
customer/order info table when I remove a customer from the customer table if

How can I get and set a custom document property of my Database thru code in
Access VBA? And which References must be used to get it running?
Thanks for help.

I would like to program my OnNotList property to prompt users to add a new
name to the Employees table (the source table for my Project Manager combo
box) if it is not on the list.  Is there a library of VBA code somewhere that
I could cut and paste from?

I have a module that adds records to a table, and then must use the new
records for a continuous form.  If I open the form immediately from the
program, there are no records.  If I close the form the module is launched
from, then open the form manually, the records are there.  ...

How can I use code in the After_Update event of a control on a parent form to
send the child form to a new record?

I have a dialog form that allows the user to select the report they wish,
along with the criteria for the report, then they select a button to save it
as an .snp file.  My questions is, how do I get that criteria passed to the
report before saving it as an .snp file?

Hello Access junkies :)
I wanted to know if there is a way on how to set the RibbonName
Programmatically??
any kind of help or pointers will be helpful,

I've programmed code for a form at home under Access 2003 involving a list
box control.
When we try to run the form at the office (under Access 2000), the code
stops at this line:

I am stumped and I need some HELP,  PLEASE.
I have a form(InvoiceAdjustments) which is created from a
table(Adjustments)and a second table(Invoice).  I want  the user to be able
to search on the table(Invoice) for a pre-esxisting invoice and if found

Is possible with adox or other vb driver to change the width of fileds in
gried view of access table?

I developed a serial COM application it runs under access 2000, 2002, 2003
but not under access runtime version 10 (Access Runtime version 2002).
The application is compiled to an MDE file.
What shall I do to solv the problem?

I am trying to programatically replace ":" with "." for all records in all
fields in a table.  Everyone mentions the replace funtion but this is not
available in Access '97.
Can anyone suggest another way to solve this problem?

What is the VBA code needed to change startup options for a specified user?
I have a database where all the startup options are disabled for all users
except the administrator (CR).
I want to turn these on if the administrator is logged on.

I'm try to update some VBA code to optimize the update of records in a table.
This is being done from within Excel (VBA) to an Access database.  
Originally the updates were being done using ADO and SQL statementsby using a
delete and an insert.  For example.

I have a table that keeps on inserting record at backend.  I would like to
print out a report automatically (without pressing any button) whenever there
is  a record with the field value "PRINT".  
Table A