I have a popup form which opens in modal mode to give users the ability to
enter some data in a temporary table.  When the form opens it filters the
data for that users job.  Several users could be accessing the form at the
same time. If the first user opens it and leaves it open ...

Okay, Dan Artuso informed me that Dynaset is obsolete, so I've removed it
from my code. Also, an MS Web page tells me that the Table object is found in
the "ADO Ext. for DDL and Security" reference, so I've selected that. So my
errors on Dynaset and Table objects have gone away. ...

Thank you to Doug Steele for attempting to solve my problem posted on Feb 6.
I tried his procedures and read some other stuff on references on his and
other sites. My module still doesn't run without errors. Here are where
things stand: (I'm using Access 2003 under Win XP Pro on ...

Am I using these actions correctly. I am not achieving the correct results.
The main form is "frmEmployeeLabels" . On this form is a command add button
to add a new employee.  add button code:
Private Sub cmdAdd_Click()

I'm using the following code to transfer a spreadsheet into the database and
display the fields.
It generally works OK, but the problems I have are:
1. I can't edit the database after loading a spreadsheet as Access says that

I am looking for an example of how to pass a value from access to a web page
input box. I would like to use VBA rather than third party software if
possible.

When a subform being inserted in a form, a link between the two is
automaticly made.
My database has to many subforms to insert them all in one form.
Is it possible to create normal forms that reacts as a subform, so that i

I've attempted to do some research on this but land up in the sections of the
book(s) that deal with programming (which I am not yet there) so I look for
your help at MS Discussion.
There are two fields that I would like to include on this one specific

I have a multi-user Access 2000 database, used for reporting only. Tables are
linked to folders according to year, ie DATA2004 & DATA2005. Each user will
enter the year he requires.
I know how to refresh the links programmatically but how can I do this for

The default Undo button in Access 97 can be quite dangerous as on the third
click the action undo's the entire record.
i want to replace the button with my own which only allows the last action
to be undone , then disables the button until a further change is made.

I wrote following event
Private Sub Form_Load()
Dim MYCODE As String
MYCODE = InputBox("PLEASE ENTER CODE")

I am successful in the 1st Procedure-Level variable but then I try the next
procedure level after saving the 1st and also in another module, but am still
unsuccessful.
The Msg box just appears blank.

I want to test for the existance of an activity discription
within a college course for a gradebook program before adding a
new activity to that course.  This should prevent duplicate
activities in that course.  In other words, if the activity does

I have an Access application that runs a VB application called "SISComm.exe".
I want to prevent users from running the VB appliction if it is already
running.
I am using FindWindow  API from the Microsoft explanation in Knowledge Base.

I'm working in a library and we're creating a database of collection items,
but I can't seem to get Access to sort them by Library of Congress call
number correctly. Access sorts, for instance, S1.U556, S115.E32, S16.I6732 in
that order, rather than S1.U556, S16.I6732, S115.E32. ...