Anyone know how to disable the Windows screensaver while Access is running
an intensive process?  
Memory is low on my machine, and when Windows goes to screensaver mode, it
messes with my Access stuff. Oh, and I don't have admin access to my

Hopefully this one isn't to simplistic for you all...  After 3 days of
working with Access for the first time I can't answer this one on my own...
I have a combobox that filters a subform based on a Product ID...  I.e. I
use a Products Combobox to see product names and link to the ...

Is it possible to add (via vba) values to multiple columns in a listbox? I
have the box type set as "Value list." Can anyone offer me some sample code?
Evan M
evan AT radiologyonesource DOT com

Is there anyway in which comma can be prevented from being used as a delimiter in a listbox?
Thank You,
Sid.

I have the strangest thing happening on a Command Button on a Form to open a
new Record.  Here's the code:
Private Sub CommandOpenNewRecord_Click()
DoCmd.OpenForm "FCycChemistry", acNormal

When on a form named frm_MyForm I can include the statement
    Debug.Print "Form = " & Me.name
and I will get the result of
    Form = frm_MyForm

i've looked (thus far) in vain for a meaningful explanation of what is behind
this -and- what to do about it.
any experienced hands out there?

Good day - I am trying to ocreate a maintanence history table in Access and
am lost on the process.  What I want to do is log every change on every day
for every field.  My maint. Hist. table consist of the following fields;
1. Loan Number ???

Alright seriously at this moment in time i want to throw a brick threw mr
gates face.  For some reason my SQL works perfectly to extract, make the
newtable output it to an excel file and delete the table made for the
inventory information.  But when the second SQl is run for tooling ...

Im trying to set up a combo which is limited by a category selected in
another combo.  Haven't had great success.  Both combo's are in the DETAIL
section of a continuous form.  REQUERY affects the content of the resultant
combo box... therein lies the problem.  Can this be done ...

MS Access 2K, Windows XP
====================
Hello,
I have a form with a "Submit" button, that performs the following actions:

I have a form that is intended to allow users to find specific records. On it
are multiple combo boxes to allow them to search via different means -
Employee, Team Lead, Case Number, Date Case Opened, etc. The form has a
subform, which displays the relevant fields of the relevant ...

I am opening a ADO recordset based on a SQL statement.  I have no problems
until I add one particular field.  The field is a text field, based on a
table in the existing query.  It is "tblAccounts.Section".  I dont belive
there are limitations in terms of number of fields in an ...

I need to change the path of an hyperlinf field that opens a PDF File.
I need to change the path os it and send it to look on the CDROM Drive, but
I dont?t want to have to type everything again.
Is tehe a way to perform this?

I have a "form" with a command button that deletes a table and relinks that
table from SQL.(Done to change from one table to a different table but has
the same format, just a different set of records) Reads as follows
Private Sub cmdAttachTable_Click()