I need to send an auto e-mail from an action on an access form ie choosing a
name on a drop down list

Using code, how can I stop the prompts when trying to run a make-table
query?
TIA,
Pete

I have a form with several controls in which I would like to force the user
to have to select a value from a list box if a certain checkbox is checked.  
For example lets say we have:
Checkbox1

How do I refer to the current page of a mult-page form?
The following does not work:
if me.page = 1 then...

I have created a database for an Art Gallery.They sell Artworks by
consignment, when an Atworks is sold the Artist recieves payment minus
commission. A customer may purchase a piece of artwork outright or put it
on layby. I have an Invoice form which has an artwork subform which ...

I have a textbox on the main form (txbStatmentBalence) that calculates 4
fields from 3 sub forms (two of which are also sum fields that add all
totals if a different check box is checked in the subforms footer).
What I want to do is after I check a check box I look to the

I have a form that has the following fields of interrest: "Model_Year",
"Tonnage" and "Rate".
Model_Year is a number based off a previous form field entry frm_Quote_Info
i.e. "2005", Tonnage is entered on the current form frm_Cost_Sheet and I want

Hi. This is an odd one but perhaps theres a very easy solution.
I have a report with a subreport. I want to be able to have a line appearing
between the subreport records but not at the top of the first one and not at
the bottom of the last one. Nor do I want a line appearing if ...

I have a order form with a tick box which when clicked on runs a series of
checks to check certain options against the order.
The system should work as follows..
When Order_Entry_Complete is clicked,

I need help with a form in Access 2000. My (bound) form has 12 text boxes for
Jan-Dec and a text box for the year total. These text boxes are bound to an
underlying query. I have placed an unbound text box on the form. In this text
box, I want the user to be able to enter an ...

I am having an issue where I have a main form page.  There is a record
number among other things.  As well as buttons to open 4 other forms.  When
you press the button, it opens desired form with the record that matches
the same record number you entered.  Now you have the option to ...

Hello,
I'm trying to test data that the user selected from a combo box that has
text.  For example,  if the selection has at the suffix "full" then I want
the text of the selection without the suffix "full".  Not all selections have

hello people
until this morning all my ADO connection worked, suddenly I am getting an
error while compiling my VS modules
the error applies to - CurrentProject.Connection

I am the beneficiary of some wonderful code for transferring an access
recordset to an excel workbook from the great Dev Ashish, but it is one
line short of perfection. Here's the code:
Dim objWkb As Workbook

I have a form with a hyperlink that opens another form to look in a
customer-table....
What I want is that the value of a textfield in the form called 'company'
is being used as the criteria for a query I run to show me companies the