Using Access 2003 Whats the easiest way to save a record after edit and
after insert behind a save commnad button. For example query1.posts ect
ect. Below is what the command button generates
but must be a cleaner way?

I hope you can help me here, I'm a little confuzzled.
All my forms are based on data sheets.
I have a main form (workstations) with a sub-form (workstation assets).
I have a button on the main form which loads another form with a view of all the workstation assets (everything in the ...

Good Day,
I would like to synchronize two database; one is Access 97 the other Access
2003, Would anyone know how best to accomplish this, if possible?  If
synchronization is not possible, would it be possible to replicate the Access

I have a a form that contains 2 text boxes that are not used every time the
form is used.  However, if the first box is used the second must be used.  So
do I create a MsgBox to pop up based on an if then equation(?)?
The end result would be that when the user exits the second ...

I have an continious form. There are two combo boxes. ComboBox1 is the
criteria for ComboBox2. Combo2 has 2 columns. First column ID(number)is
bound, but second column NAME (text)is displayed. Works fine when I enter
records. But after I close and reopen the form, nothing is ...

To archive information, I am trying to export the table to an Archive
database. the code i am using  - DoCmd.TransferDatabase acExport, "Microsoft
Access", "\\...\Databases\Compensation\Compensation Archive.mdb", acTable,
"tblCompensation'& Format([Start], "yyyy mm-dd")& " To " & ...

How can I set a field value when a user opens form?
I want to set ShpQteType = "Pullbox" when a user opens form SHPQTE PB
Form uses a Query (ShpQte Query) to enter new data
I tried to do this using the Expression builder  =[SHPQTE]![ShipQteType] =

I'm having trouble with Access corruption during forms design when I want to
attach or detach a label for a textbox.  Does this sound familiar to anyone?

I am trying to find out how to increase my form cells from 50 characters to
200 plus. I want to be able in input data into the form, but I am limited to.
I am using Access 2003.

I have used scroll bars in text boxes with no problems.  However, that has
now changed.  I have a bound text box, one line of text in height, in which
the text usually fits on a single line, but every now and then it goes a bit
longer.  I thought a scroll bar would allow for the ...

What I thought was simple is starting to give me a headache.
Working with a form, I have a label assigned to a text box.  The text box
source is a field (field: ApprovalDate) that I'm using only the month
(DatePart function and formatted mmmm) to give me an anniversary date of the ...

OK, here goes....
I have a Purchase Order (PO) Generator that has one (1) Main form and
25 Sub forms. The Main form allows for entries of PO number, Document
Heading, Vendor, Shipping Dates, etc. The Sub forms are used to enter

I have created an input form that allows me to add new employee profile data
into a table.  I would also like the ability to attach the excel request
template that is submitted to me to this form.  That way I have the
supporting document when I go back and view the form at a ...

I have a report with 3 fields.
fldPriority, fldContractName, fldAmt (control source priority,
ContractName and Amount respectivly)
I applied conditional formatting to all three: [Priority] <= 5. All is

I woulid like to enhance my form by changing the backgroud color of my
text box when the firstname change.
I would like to have something like that:
Name : MARTIN