How can have the Command buttons change effects on mouse move. I can get them
to be flat and on mouse move become "Raised" format but then dont return to
flat after mouse leave button?

I have two form's I'm trying to sync.  One datasheet and one single.
Private Sub Form_Current()
[Forms]![frmLookup]![frmOrderStatusDatesSF].Requery
[Forms]![frmLookup]![frmOrderStatusDatesSF].Form.Repaint

I have a query that is as follows:
exec usp_setlinenumber
the query properties are as follows:
ODBC;DRIVER={SQL

I have been working on this code for a few days with a lot of help from here
and have now hit a brick wall, and cannot see where else to go
Again I apologise for it being a long post to give you all the info you will
need.

i have a couple of tables with a "one-to-many" relationship.
i want enable my users to essentially "duplicate" the data from a parent
record into a new record, but also duplicate "child" records associated with
that parent, linking the duplicated child records to the newly ...

thanks in advance for any help that I will recieve, I am using sendobject to
send an email , but I would like to have more that one email address taken
from the query how would I concatenate the records together, the query that I
would get the email address from is called ...

I create a new form instance using
Set frm = New Form_formname
When 'formname' opens I want to know who opened it so that I can make
certain controls visible.

hi gurus
I have two unbound comboboxes with fixed lists that I use to create matching
entries in a table when I click on an 'Add New' button.  I'm new at this
access game, so I suspect my code for the 'Add New' button is not well

I am exporting an excel file created in Access to the A-drive. What I would
like to have Access do is check the A-drive first before commiting the
following line of code:
FileCopy cstrTemplate, cstrFileDest   'Copy the excel Template file

I have a combo box that does a search by the last 8 of a VIN from an
automobile. Sometimes we will transport an automobile 2 or 3 times. When you
put the last 8 in the combo box it shows that there is a second record in the
list, but if you try to select that second record, the ...

how to set a bound (to my data enty table) text box default value to a value
from a query

With the code below I'm trying to make pages on a tab control visible or not
based on the type of visit. I'ts in the lstVisit_GotFocus event. I don't get
any error messages but it doesn't do anything either. All tabs are visible.
Any help would be greatly appreciated. Thanks, Rob

Using VBA, I would like to return in a variable the current sum of a column
in a subform (i.e. not record count, but sum).
Could someone please post generic example VBA code to do this?
Thanks much in advance.

hi, everyone,
I do have a question. I hope anyone you can
help me. I have a formula in vb that call a shell application. In
fact

I can created a date time when the file is created.  But when a user opens
the form again the date time does not change.  I have used the following code
in the events  before, dirty and afterudpate but no joy..
me[Date_TimeModifeed]  = Now()