I have one form having one label and one command button...
On click event I am doing a process in a loop say about 50 times...
Sample code
for i = 1 to 50

Access 2003, WIn XP
Hi,
My code is below.  I needed to take a break from this to clear my head but I
am back.  I can view my report on screen and the report only has data based

I will really appreciate it if I can get help as soon as possible o
my problem. I am trying to create a database for a library as m
personal project. I have a return date field which has a date variable
The form is supposed to be open all the time. In my Vb coding I want th

I created a tblLog to tract the users which has "Username"(captured NetID)
and "Date"(=now).  
I created a frmSwitchboard bounds to tblLog and add the "txtUsername" and
"txtDate". I got an error using the codes below "Syntax error in INSERT INTO

I'm trying to use an InputBox function to find text in a
listbox and a form which are based on the same data
The code finds the string in the form but I can't figure
out how to have the listbox go the found text. For

At first I was using the FormType in a List.  I had it working correctly that
when I went into the tblReceipts and chose a ReportType (in the list) it
would automatically open that form so I could input the information into that
particular form.  For instance, if I chose "Expense ...

What is the best way to cancel an edit operation on data in a text box?
Manually, the user can hit the ESC key and the text box will resort back to
the data in it at the beginning of the edit.  However, on certain text boxes
I would like to add a commit confirmation (i.e. ...

1) I have a form with a textbox linked to a memo field, scroll vertical is
set on.
2) The form also has a tab control with several listboxes and text boxes.  
The problem is that the user wants to scroll down the textbox in # 1 and

Hi, there.  I am trying to combine a bit of code and it seems that it works
sometimes (it updates the table) and sometimes it doesn't.
With help from the group, I've created a form with a command button.  The
command button runs a report and updates the table, in theory.  I've ...

What event or other method do I use to capture the date clicked on the
calendar control by the user in Access 2000?

I have two cbo boxes -
both use querys as  record source
CBOone  selects stations 3 character string
and CBOtwo uses a query for rthe record source that has a parameter

When I run, or I should say, try to run, the following, I get a type mismatch
error on the line:
   Set rst = Me.RecordsetClone
This is very puzzling since it is copied almost verbatim from the help files,

From an inputbox the user can write a new price. The box has two buttons, Ok
and Cancel. But if he hits the Cancel nothing happens. The inputbox is still
there and the sub won't exit. My code is
GetPrice:

I have tried all ways of trying to requery and I always fail
I have a drop down list in My "Order Form" - if entering a name that does
not exist then the "Not on List" event loads a PopUP form and I enter the new
Name and Address and other information - After update the PopupForm ...

In a VBA module in Access97 I want to call a shelled application.
shell(app.path & "\myapp.exe")
I can't seem to figure out which reference I will use to provide the
app.path function to me. I get a library or function not found.