Is there a reference on the web which would show me how to run sql
statements from within my vb module.  Or could someone show me how to get
started.  I want to use Dev Ashish's Send Email Outlook module but take the
attachment names from my data table and cannot get it to work.

Morning,
I am working on a project management database, and am having difficulties
designing a lookup and would appreciate your help.
The first field in the table (tbl_ProjectDetails) is the primary key (ID)

I have a rooutine that exports reports to Excel and them tidies them up (via
ActiveX). It works well until the line:
   .Selection.Delete Shift:=-4159     ':  -4159 = xlToLeft
when I get the error:

Below is a short VB function that will delete the query named "TEST 1" from
my database window and pop up a message box saying "Complete!" when done.  
I need a paramater VB function like this that can prompt me in a pop-up box
for the query name I wish to delete (in case I wish ...

Will the password protection on a form normally prevent reading the data on
the form? The password is just to modify it.

Hi all-- I need a way for users to import records into a database from a
series of Excel files that, more likely than not, won't have consistent file
names.  I've found VBA code that will allow the user to pick out a file
through a dialog box, but I can't figure out how to actually ...

I have quite a few excel workbooks that I am linking to in Access.  Every
month, the location of these workbooks (linking to individual worksheets as
well) is going to change.  How can I programmatically refresh these links so
I don't have to go in there one by one to refresh the ...

If I make a field in a table "State" how can I limit it to only state
abbreviations.  Is there a code for this rather than actually creating a
table and entering all the state abbreviations?

What can I do to turn off the wheel.

I have the following in a union query as one of the fields:
   Format(Year1Qrt1MU,"Percent") AS [Qtr 1 %]
How do I get it to return only one decimal instead of two, as seems to
be its want?

i need to disable the scroll wheel and the pageup and down botton

I want a make table query to execute when a user opens a certain form. I have
the following code in the Form_Open Event. (Notes: "TW" Tables in my DB are
those created by Make Table queries.
___________________________

You know how you can use the "Me" keyword to refer to the current form? Is
there a way to do the same thing with a button?
I have a bunch of buttons and I want to pass their names to a function when
they're pressed. I don't want to have to modify each of their on_click

I hope that someone can help me with the following.  I am trying to find out
what each of the acCmd constants are for.  The help file in Access seems to
only list the constants and their values not their purpose or function.
Does anyone know where I can get this information?

I have a friend who sent me her code to take a look at. I'm pretty new
to learning Access VBA and not quite sure where here problem lies other
than she needs to line up her If statements a little better.
The initial program uses a list box that has the following headings: