In Access 2003, I need to pass a parameter from a control in a report to a
query that is the record-source of a subreport.
From the manual I should set the InputParameters property of the subreport,
but I don't find it!!!

I hope someone might be able to help me with this, because having paid
for support from Microsoft I'm still getting nowhere.
I don't know if this is due to a file corruption or virus (I have no
viruses now), but I cannot get in to the VB Editor via any Office

I've got a simple DB (Office Win XP Professional).
Basically, it's like a check book register - deposit, deduction and running
sum.
I'd like to somehow link it to an Excel spreadsheet that will do the

Hi Gurus
What is the best way to write the following code:
   If REC = -1 Then
       For I = 0 To Ctl.ListCount - 1

I have an access query which retrieves some record. I can export the results
of it as an excel document, using the function TransferText. What I actually
need is to export the query as a db3 table. I've been suggested that once I
export it to an Excel file, the user has to open the ...

This is such a simple problem. I've asked for, and gotten, help with this in
the past, and I can't make this work. Once more, please -
I want to be able to put a member number (which is the primary key of a
table called tblMemberInfo) into a text box on an unbound form and get back,

I am making my first attempt at a project using VBA and have hit a problem. I
can find nothing to help in any book. My code is generating a message "Runtime
error 2001  You canceled the previous operation."
I created a relatively simple form, which allows the user to view and add

Students at the school where I work are getting the error
"Application-defined or object-defined error." when trying to document
their Access databases.  If you open the documenter window, select a
table and click OK, it works.  If you click options and then click OK

Wondering if someone here could help me out, I've tried a number of
ways to do this, and while I have managed to get it to work, Im SURE
im not doing the optimal way, and it seems to be causing problems with
my form which is throwing up '#Name? ' in some fields(at seemingly

I would expect the following code to delete all the records in a form's
underlying recordset, and delete the rows in the form.  But the form's rows
are still there, and when I scroll the form, the field's values display
'#Deleted'.  Thank you for the help.

Error: 80040108 after 380 CreateObject("MAPI.Session")
Function MAPI_Test2()
Dim i As Integer
Dim MySession As MAPI.Session

Hello friends,
I am very much new to MS Access and having bought a new PC with MS Access 2003
on it cannot wait to use it. I am looking for an add-on for Access that will
enable me to manage our small office sales. Till we get a client, process his

How can I calculate a three letter day of week (Mon, Tue, Wed etc.) from a
date?
Thanks
Regards

I plan to use access to manage a small tea house, but I was frustrated at
the first step.
The prolem is:
1. Within in the main form I would like to draw squares to symbolize 6

I have checked the "Alignment and Sizing" toolbar but when I want to
use in on aligning several form object the toolbar buttons stay grayed
out.  What am I missing.
Thanks!