I see the example to read all data in the list box using VarItem as
Varian.
I use watch to check the value which is a kind of integer to present
index of the list box.

I have issues with running queries an exisiting databse in access 2003. I
have a combo box whose source is a simple query and up to recently worked
perfectly fine. Now when opening a form with the combo box the combo box is
empty. If I create a new combo box in a blank form with ...

In A2K.   On a form, the user enters contact data for people registering to
attend an event.  On the form is a combo box (#2) that lists the events to be
chosen from - this combo box has an event already listed based upon a master
list of registerees and is pulled from a combo ...

I am trying to code in the deletion or removal of a link to XLS
spreadsheet.
I have tried Docmd.SelectObject, but it doesn't recognise the object
when I then try to code in the delete stage.

I'm running an Access 2000 database...soon to be Access 2007.  I'm running
code to look on our server to see if a file exists. If it doesn't it creates
the file. It works ok but for some reason at the end it opens up a dialog
box and tells me "Unable to open [filename]. The ...

I have a form that is created by a table, I then have a subform that is
created by another table.  Which has a relationship directly with one field
(IDNumber).  But I do not want to use this field as the lookup, I want to use
another field called (Owner) <-- which is a lookup ...

I have the page format set to margins 10 (top/bottom/left/right) in
landscape mode. However every other time I try to preview report it
resets to default value and also portrait mode. Can anyone help
please.

Hello, I am new to this forum and would be very appreciative if someone could
assist me with this problem.  I found a code on the net that works with text
for the filter process, however I am working with integer.  I am not sure
how/where to change the code to reflect integer ...

I am trying to generate a report based on the following query: qryTestReports
The SQL for this query is:
SELECT tblRequest.REQUEST_NO, tblRequest.TITLE, tblRequest.NOTES,
tblQueue.Q_INC, tblQueue.QID, tblQueue.Q_YEAR, tblTest.TEST_TYPE,

I have a form (frmActMapUpt) that allows the users to update sorting and
grouping coding in a table.  If they update anything, I have to run a few
"house-keeping" queries, if they just look at the data in the table and don't
change anything, I would like to skip the house-keeping ...

I have a very long INSERT INTO line that works, but i can't get 1 field
inserted that is on a subform.
I have 10 fields on the main form that will insert into another table just
like I need.  The subform called "Location1" has a field called Directory.

I have two combo boxes on a form.  They are both based on the same table.
In certain instances, if certain choices are made on the first combo box,
I'd like to automatically update the second combo box.  I don't mean I want
to change the drop-down options of the second box, I just ...

Hi - I have a form that runs in the background and a field is updated when a
button is clicked on another form.  This code works fine in A2003 and does
nothing in A2007 - no error message, just doesn't save the data - can anyone
explain, please?

I use this code in the click event of a cmd button and the append query runs
but appends no records.
Private Sub cmdTrackComplete_Click()
   DoCmd.RunMacro "MCR-TrackComplete"

I have a columnar form that basically displays a record from a table.  There
is a date field in each record.  I want to add a textbox or label that shows
a cummulative sum of a number field, for the month, of the month that is
displayed in the current record.  For example, a ...