okay, i know this sounds a bit whacky, but i am working around someone else's
code, and have a very quick deadline.
what i need to know, is there a way to open a form and run the code that it
has behind a command button, from another form?

Okay,
Here is the setup of this monster database that we're using.  We have an
Access frontend with SQL server backend.  We have about 14 tables that all
link to one main table via main table's PK.  To present this data, we have

I have a main form (supermarket order) with three subforms (meat, groceries,
produce). Each subform multiplies [quanty] * [price] and sums it's catagory.
The main form totals the three subforms.  All is fine until the customer
doesn't order from all three catagories. I get #ERROR ...

I have a form with two unbound subforms.  The main form has a combobox
whose selection I use to filter *both* subforms.  Code called on after
update:
Private Sub cmbMyCombo_AfterUpdate()

To all:
I am developing a form for an office to fill out.  I wanted to put it
into an Access database so obviously I would created the form using
Access.  Once the person fills out the form and presses a submit

I have designed a form which successfully supresses the ability to create
new records by setting the AllowAdditions property to "No".
The problem is that when I open the form using the code below the form once
again allows additions and I can't figure out how to prevent this.

I am trying to set up a form that will calculate a percentage average based
on certain check-boxes. Each section in the form consists of a number of
check-boxes (Yes/No data types) which I want to assign default values to. I
have tried assigning the fields with a default value (i ...

So i have a form with a combo box listing all primary keys from a
table.
The combo box also has a select statement pulling all data into box to
fill other fields in the form.

Can someone please tell me the code to ensure a user enters only the
following combination of text and Numbers. (i.e. JT0982) I have a Access
front linked to an SQL back end.
I know there is a mask but this won't help me because of the back end being

Using A2003 I am creating a new contacts database for my employer. I have a
couple of "special" features I would like to incorporate onto the main
Contacts form.
a, I have set the Shipto text boxes to invisible on form current and if the

Our product is sold by modular components, so each time a quotation is
prepared, an itemized list of components needed to “build” the unit is input
by a user (there are thousands of possible combinations, not to mention color
and top material choices, plus possible add-on ...

Dear Friends,
I am the new in this group, I have a problem that how to intilize the auto
number fields, If I want to restart auto number from 1,  what i do ?
Please reply

How do you stop a user from double-clicking on .ACCDB file of 2007 and
being able to see the tables' and queries structure ?
If the solution is the database password, then database cannot open
from a shortcut as

I am trying to build a front-end for an existng Purchase Order (PO) SQL
database.  The problem i am having is the line-numbering for the items
purchased on the PO.  
Currently the database has 2 tables, [mmpohd] for the PO Header information

Is there any advantage for using "Microsoft Office 12.0 Access
Database Engine Object Library" instead of DAO360.DLL for Access 2007 ?