I am working on a form that has a list box control of items, the
functionality that I need to add is that when the user double cliks on one
item of the list box the other controls that I have on my form should
autopopulate.

Hi, everyone!
I have a subform that I use to demonstrate how a picture will appear as a
form background (centered, tiled, etc.)  On the main form, I have controls
that allow the user to browse & select a new picture, set the starting

How can I clear a combo box. ie., I want to reload the combo. Like in VB
comboName.Clear is there but in MS Access how to clear the values and Reload
the value. Actually I lad the combo like this ...
rec.open "SELECT EMP_ID from EMP_mast  ", adoopenforwardonly,adlockreadonly

I need to replace the event procedure of control in runtime and send byref
currentForm
I tried to make something like this:
ctl.AfterUpdate = "=myFunction([Me])

I am trying to convert a query to a CSV file with my command button.
As of right now, when the command button is click, the open file
dialog box opens and wait for a user to select a CSV file to import to
a temp. table. Once the data is imported it automatically filters the

I have a form that contains twenty controls for # of hours, Sum of hours, and
hours_label.  (example:  A1_Hours, A2_Hours....,A20_Hours  and   A1_HoursSum,
A2_HoursSum....,A20HoursSum and
A1_Hours_Label,A2_Hours_Label....A20_Hours_Label )

Would anyone give me some guide line how to change the default font used in
Form and Report in MSAccess 2003. I went thought the tabs in Tools -->
Options but none seem to work.
I don't like the default font used at present which is MS Sans Serif size 8.

Can I do multiple selection from a list. What I want to achieve is this, I
have a list of items which users would select. I would have either check box
or radio buttom beside each items so that user would just check the items
they want and this will be printed out on a report and ...

I have a table where one column stores email addresses, i want to create a
form where by i can select these email addresses i want to send to, put a
message in a text box, have my email address as the sender, and then be able
to complete this with a button. My assumpition is that ...

I have a function which acts almost the same function as loan function.
Does anyone know to make it autosend an email when the expire due date still
left 1 day?

I have been struggling with this for a while now and hope that someone might
have a idea of how to do this, I have set up a form which allows users to
attach external files and pull the email address from a table.
However I also have a reports table in my database that stores ...

I have a database with a many-to-many relationship and would like to
construct data entry forms that would step through these M:M tables.  The
tables are:  tbl_Projects, lk_Join and tbl_Investigator.  My theory is to
start with a form for the project, create a button that would ...

I have a word document that a team will use to enter data into, and I need
the data to be imported into my database.
However, different sections of the document need to be inputted into
different tables.

I created a vendor combo box on my form. When I open the form, there is no
data in the vendor name field (all other fields are populated i.e. address,
city) until I chose a vendor from the drop down list. How do I get this data
into this field before a selection is made?

I want to add a message box that will list the item that is not the same...
Below is part of the code my code :-
Do Until myrecset1.EOF
               'if part numbers of the two jobs are the same, perform the