I'm trying to update a table based on a query string, but I'm not using the
recordset properly I think:
Public Sub UpdSomeEmployeeRelatedID(aLkupField As String, _
                           aRelatedID As Variant, anEmpIDCollection As

I have created an Access database. I have created an Workgroup file,
and made respective groups and users. But all the users have the
runtime version of MS Access. They can open the database and view
records from the frontend. And if they want to do any updations they

Is there a way to open a form from another form and goto a specific record
before the form is displayed. At the moment my form opens and record 1 is
briefly displayed before going to the record I want. My records contain
images so it looks like the image is flashing up on record ...

I have a table where some data about cars is stored, amongst them MOT
now I would like to find out which cars require new MOT the following month
calculated from today's date (month)
It's set as criteria in the MOT field in a query and should come up with

I have read many of the posts here and I can't find one that helps with what
we are trying to do....
We have a order entry form for a manufacturer.  When we get reorders, we
want to duplicate certain fields from an old record to a new record.  For

Hello.  I'm creating a bid database for a company to track their sales
efforts.  What I'm trying to do is automatically generate a proposal number
based on the region selected from a list box in a form.  So the list box has
the options North, South, East, and West.  The following ...

I were wondering if I can download a newer hlp file for Access somewhere.
Because I'm using Access 97 and in that help file is for example the method
Saveastext not documented.
Thank's

I have an event in a form which processes several functions in a module and
it could take up to 1-2 seconds to complete. Once it is completed, a message
will pop up to notify the user and the user click "ok" on the message and
the entire process is completed. The problem is user ...

How come I get the message "There wasn't enough memory to perform this
operation" when I click on the Find/Replace and get to a certain record in a
form in Access?  How can I fix this problem?

I'd like to be able to type in customized pages for my 7-ring planner
(important contacts, etc) -- then  print out on the 5 x 8 pages that fit in
my planner (maybe there are 8 X 11 perforated sheets like this?) Thank you.

When I display a table within a subform, the background
colour (ie where no records are displayed but within the
confines of the sub forms boundary) is always dark grey,
how do i change this color pelase

I need to have a "flag" set up to open a form if contracts are up for
renewal.  I have written a query that works fine (compares current date to
contract end date), but I'm having trouble figuring out how to get a form to
open or not, depending on the results of the query.

iF A datasheet is displayed within a subform, hw can i
stop people adjust any of the formatting parameters
around the sub datasheet, ie grid lines , fonts, etc
pat

Hello, I have a table call 'Allrecords' and it has a field called ContactID
set to autonumber. I have a form called 'Alphabetical View of Contacts'. I
have another form called 'Customer Details'. I want to double click on the
name field in the first form (Alphabeticall ... ) and ...

I have a form that runs my reports.  I can check a number of different check
boxes that allow me to select my criteria for the report I want.  One day I
was clicking around and clicked on the Filter By Form button.  My whole form
changed and now when I go to this form, nothing ...