testtttttt

Here is one I have been banging my head against the wall to solve.
1 table, 1 form bound to that table, 5 fields.
Primary Key is "Production Number" which is a combo box on the form.
All oterh boxes are text boxes on the form.

i have a main form which looks at all my records. another seperate form, not
a subform, can create new records in my main data for the first form. the
problem is that the main form doesnt update with the new records unless i
requery it. when i do that the main form moves to the ...

I created 2 command buttons at the bottom of my forms view. One button is
called "Surgery" the other is "No Surgery". I want the doctors to click on
"No Surgery" and the word "No surgery" will be updated in the patient's
record in the tables. Can this be done?

I have a form with many fields.  Some of the fields are combo boxes
based on value lists where the value list could have up to 5 different
choices.
Field Example: Incision Dimension (Value List: 2.0, 2.5, 3, 3.5, 4)

I'm using Access 2007 and a couple of older but excellent books (Using
Access 2002 and Developer's Handbook 2002) with no success, so I come to the
experts.
I have 8 tables.  Two (Table A and Table B) are related in a many-to-many

The Access Pivot Table I want simply put is stores across the top, items down
the side and cost in the middle. All cost values are less than a dollar. The
Currency format showing 3 decimal places works fine in the table, other form
views and Excel data dump...just not in the ...

I am trying to automate a process within my database. The process being that
when a Super User rejects a transaction it will generate an email to the user
who last modified the record with details of why the transaction has been
rejected.

I would like to display a large number of values in a list box. To do this I
would need it to format the list so it displays more than one column.
Something like the List view in Windows Explorer.
The 'number of columns' control seems to only allow for more than one field

I have a list box and a command button and a text box on a form.  What
I would like to do is when selections are done from the list box, the
command button is used to update the selections into the text box.
Is this possible to do - Thank you for your assistance.

I tryed to look through several groups but haven't found a genius hint
yet. Hope you can help me.
I would like to create a MS-Access form that reads data from an online
system, showing the status of various machines (running, pausing,

I have a textbox where its doing % change from two other textboxes.  And
sometimes the other two other textboxes have 0 as values and it won't be able
to do the calculation.  I am getting two errors...#Error and #Num!.  How can
i fix that so it shows blank instead of the #Error ...

I can't figure out how to set the tab order for a form in Access 2007.  I
spent at least 20 minutes at the so-called online Access help and couldn't
find this.  It's easy to find for Access 2003, but not 2007. Indirectly
related to this, F1 doesn't bring up help.  Is there "help" ...

I have a form that I want to come up "blank" for data entry purposes.  
However, I would also like to be able to have the option of using a combo box
to look up a specific record and display it's particulars on the form.  So
far, if I set the form to "data entry" the combo box ...

I have created a form based on two separate tables.  One table holds names
the other table holds data.  I need multple to use the database and to have
the name selections save for each auditor separately.  Can anyone help?