How do you read an index value of a control knowing the control's name?
Thanks
Pete

I set a default value for a combo box when a change is made to the combo
box.  The idea being that when the form is opened again, the combo box will
have the last value selected.
Problem is, it don't work!  It always "remembers" the first one I selected

I have in my system one form to verify who is logged in a specified
database. At same point, I have the option to send to a connected user a
message and for this I use the command Sheel as below:
Shell ("NET SEND """ & CompName & """ " & msg)

(originally posted in wrong forum)
I have a form with several tabs.  Three of those tabs (tab 1, 2, 3) are
subforms.  Each of those subforms has the same data source (a query), and
the same relationship to the main form's data source.  The query is an outer

In coding examples in a number of Access VBA books (especially those by
Helen Feddema, but I'm sure I've seen it elsewhere), the word 'Me' is used,
but not explained anywhere that I can see. As in:
       Me.Requery, or

Hello, I've created a clinical study database that is very similar to one
being used right now at my place of business. In making my DB, I copied a lot
of code from the similar one to mine. All of the functions, buttons, and
what-not work fine except for one. I get an error ...

I have an Access Project connected to an SQL Server database. I want to save
the values of the text boxes and combo boxes into a flat table. To do this, I
need to iterate through the controls collection. What is the syntax for doing
this just for these two types of control and ...

I am trying to change the location of a file. Exh time i do this I woul
like the script to create a new file with a new file name.
I have managed to move the file using the name method, but I would lik
the moved file to have a new name each time. (so the file does no

I am trying to do something which seems simple, but I'm stumped. I want to
update records in a table according to records in the table. I have a field
with numbers and rows with 0's below it (ie 1st row is 5 and the next five
records are 0's, then the next record is 6 followed by ...

I have tried so many different ways of coding this I can't even count them
anymore.  No matter what, there is always an instance of EXCEL.exe running in
my task manager processes.  This instance not closing makes the application
not able to run more than one time, unless EXCEL ...

I'm using Access 2000 and am using Outlook on a network.
The Application I created is going to be used by a number of folks.
In order to automate sending email with data from the application,
create an outlook application object.

I have form which searches for available days from db. Db contains tables for
6 month with fields named 1-31(or 30 depends on month). In the form I put
date1 (ex. 12/06/2005) and date2 (ex.14/06/2005). The code should find which
of those days are available (table contains ...

I am developing a search facility for my db of patients. I have a form with
an unbound txtbox and unbound listbox. You enter the PatientID you're looking
for in the txtbox and as you type, the listbox displays the PatientID numbers
in the db (using a query as the RowSource). You ...

Hi - is a tree view control the best to use as a browse box to select a path?
If so, I need to load it with the directories and network drives etc - so how
do I do that? Thanks - Jenny

I've come back to Access VBA after a long time and find myself confused.
I have a form with two combo boxes, each bound to a different table. The
user should choose a record from one or the other. I also have a text box
where I want to put the Description of the item chosen, from ...