This is the below I am trying to get selected item to be shown in the
textbox. Works fine in VB6.0.. But not in MS-Access 2002.
Private Sub Command42_Click()
Text1.Text = List1.list(List1.ListIndex)

I have an unbound control in the head of a form to select an item. I put a
code on the AfterUpdate property to pass the focus to a control in the body
of the form:
Me.DeliveryDate.Setfocus

So far, I did not  need to use the References collection. Having read the
help file I run into the <References.AddFromFile(strFileName)> function
which links the application to another library (I think another .mde file
would suit here as a library to link to). So I moved all the ...

I have a subform "SuppTxnsSUB" based on the tblSuppTxns, and a particular
supplier's transactions are selected vis a plain combo box (no wizard) by
having the combo as the Master to the "SuppTxnsSUB"'s Child.
This works well.

I need to create excel workbooks for each RespId in table tblResp.  Within
this workbook, sheets must be created for each account record in tblGLData
that has a link to tblResp. On these sheets, account and account balance data
would be inserted into each sheet.

I have a sub-routine that fills in a combobox:
Sub Box(FN, ComboBox, Waarde)
   With ComboBox
       Do While Not EOF(FN)

I have a Word Document that is linked to an Excel file.  When I run this
document on it's own, I get the prompt box informing me that "Opening this
document will run the following SQL command....", which it should.
I am trying to open this same document from Access.  I am using a ...

I might be doing this wrong
I am trying to set a textbox to a serial date using
Me.setserial = DateSerial(Me.Combo4, Me.month, 1)
Me.Combo4 is the year(has the years 1970-2050 for a row source)

I import some records into a temporary table "Temp_Products".
During subsequent processing, I do the following:
   Set myTable = DB.OpenRecordset("Temp_Products")
   ---Do some processing---

Newbie to Access. Hope someone can assist. I have a table with the following
fields:
Site    Text
PartDescription    Text

I have a form which is used for import and export functions.  As part of
this process, I want to check if a table already exists in the database, so
I can create the table or clear the table rows before my import.  I need a
method of detecting the presence of a table before an ...

I would like to disable scrolling through records with
the mouse wheel.
TIA,
TimJ

I want to use a form to update a table. Basically, I want the form to act
like a data-entry dialog box. I would enter the data into the form, and
update the table when I click on a command button.
I saw some suggestions on here about using temporary tables. I am very new

I'm experiencing 10-second latency when selecting records from a dropdown on
a combo box.  The Row/Source type is a local table that has numerous indexed
fields.  This latency ONLY occurs during hte first selection after I open the
form.  Subsequent selections process quickly ...

Is there a way to control screen resolution in a frontend?