Initial data is entered in a Shipments form, reality here is that any given
po number can ship in multiple contianers. So far so good.
Now as these various containers are sailing towards the USA which are
critical to the business and need to be tracked by logisitics (and here is

1. I have parent form showing one record at a time, and a detail subform in
datasheet view.   The two forms are linked by ContactID.
2. If  I move to subform before saving changes made in parent form, the
parent form apparently requeries and goes back o the first alphabetical Last

I'm developing a database application running on a Microsoft SQL Server 2000 with Microsoft Access 2000 as front-end.
In one of my forms I use a ListBox showing files on a IIS-filestore linked to the records in the form recordsource. The user can right-click on any record in the ...

I have a transferspreadsheet cmd that imports a table from excel named
TblTempCap that has a DATE field.  This table is imported into
TblCAPAllAccounts that has a corresponding Date Rpt'd field through a RunSQL
command. The TblTemp table could have 200 records but will all have ...

I still could not do it:
How do I add another recipient to this function, separated by what?
Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

I have some code that is based on the user's choice from a combo box field
('sexcode'), whose values are derived from a Value List
("f";"female";"m";"male").  I have code to gray out the next control
('Frame9surg_sterl') if the user chooses "male", but to keep it Enabled if

I would like to lock the open record if the status is true (yes/no checkbox).  At the minute I manage to do it by disabling and locking all the fields, but this causes the fields in other records to be locked as well.  Is there a way to do it so it only locks the records with ...

Maby this should be a simple Q for me and yes I can always put in a masgbox
to see when an event in a form accures but I just can?t get this to work.
What I?m trying to do is to redesign a bound form when the form opens
depending on if a field in the underlying record have a value ...

I have found information on Word Automation to be very sparce indeed on the
web. Can someone point me to a good forum or website or book that covers this
subject in GREAT detail.
For instance the following code statement takes between 10 and 15 seconds to

Thanks for taking the time to read my question.
I have combo boxes that if the value selected is the same as another combo
box, displays a message saying so, and SHOULD undo the change and make the
user select another value.

I am trying to set up an Access 2002 front end to connect to a SQL Server
backend database.  I am successfully able to link a table mannually using
"File==>Get External Data==>Link Tables".  I am trying to use the following
code to refresh the links via code.  When I do, I get a ...

Ok I know everyone is going to say you should not store calculations, but I
have no choice!!!!!!!!!!  I have the form ORDERFORM (recordsource ORDERS
table) with a subform ORDERFORMsubPROD (recordsource ORDERSPROD table).  
Essently theses 2 forms togather allow me to place an ...

I have a form that I have created that the data source is
a query from the master table.  I want to add a button on
the form that opens the form in edit mode and running the
query.  Can someone help me write the OnClick

Ok I know everyone is going to say you should not store calculations, but I
have no choice!!!!!!!!!! I have the form ORDERFORM (recordsource ORDERS
table) with a subform ORDERFORMsubPROD (recordsource ORDERSPROD table).
Essently theses 2 forms togather allow me to place an order ...

I have seen numerous Access applications where a form asks for certain
personal information, let's say LastName. Entry of this last name triggers a
subform display of all those in a database with that last name. I believe
this subform displays in datasheet format. The subform ...