1.    How do I access the name of the user in Access 2000?  Is this the same
as the person who signed into the network on Win 98SE or Windows XP?
2.    Is this a read-only value that cannot be programmically as people
migrate temporarily from computer to computer?

I have access xp.  I want to obtain a value from a field of an open
query (let's say a query called  MyQuery)  using vba.  I tried using
docmd.gotorecord  which takes me to the record I want.  I would like to
obtain the value of a field (let's say a field called CID).

If there are several queries that are open, and code is running from a
clicking a command  button in a form, what code will make the
already-open query with the name "MyQuery" to be the activedatasheet as
in

I have a macro called test that simply runs a function called getdailyupdate()
If I run the macro manually, the function runs perfeclty.  If I schedule it
to run using windows scheduler with /x "test", Access starts up and the
database window shows the modules and that's it.  The ...

I put a breakpoint to debug a procedure and when i finished  i cleaned it up.
from Access form, when i enter the Sub (by clicking a button) instead of
getting the procedure to run the code, the VBA editor appears and stops in
the exact place where once was my breakpoint. I've ...

I have a switchboard form that when I press a button it starts a background
process that executes until a certain condition is true. In the meantime I
need the user to be able to perform other tasks, namely use other forms.
Is this easily doable?

I am fairly new to Access and accidentally used the word Date in
field.  I went back and changed the field to be SampleDate, but i
appears that the damage was already done.  I cannot get the Date(
function to work.  Is there anyway to go back and get rid of tha

Set rs = CurrentDb.OpenRecordset("Select * From [AgentData] where
[MiscText])" Is Not Null, dbOpenDynaset)
MiscText is a text filed
I'm  getting  a Type Mismatch error

My company is on Office 2000 (with no plan to upgrade to newer versions.)  
Does anyone have a process to calculate Percentiles in Access 2000?  The two
options we've thought of were 1) somehow linking to an Excel spreadsheet,
calculating there and returning values to Access and ...

I'm trying to write a VBA procedure to apply a filter to a form when it is
opened by a user. I only want to filter on one field. In this case, PROJ_ID =
6000. Sounds simple. The coding I tried to use, unsuccessfully, was:
Private Sub Form_Open(Cancel As Integer)

I have a subform on a main form that runs long, 100 or so records.
Users click records they want to show up in a report.
But after each click, I need to update the main form data, a response
to that click.

I can't seem to interrupt a report from running when there is no data.
The report has a image control that is set on the On Print property of
the section it is in:
   Photo.Picture = PhotoPathStyle

I'm trying to update a field of a specific record via a command button.  
However, I keep getting an error message stating "invalid operation".
Here is the code that I'm using with the command button.  
Private Sub btnApplyInterviewer_Click()

I'm having a problem with the TransferSpreadsheet method in VBA.  In my code,
I create a table at run-time, fill the table data, then export the table to
an Excel spreadsheet.  This all worked fine until about an hour ago, when I
changed the exported table from having 12 fields to ...

I have a report that contains 4 conditions and I need to structure a SELECT
CASE STATEMENT and I do not know how to start it or how to output the results
into a TextBox in my report.
The conditions I have are as follows: