Access 2002 VBA provides easy ways to delete, copy, and run an MS SQL Server
stored procedure, via DoCmd. However, I cannot find any way to CREATE an MS
SQL Server stored procedure from Access 2002. Here's what I'm trying now, but
it doesn't work:

Is there a way to have the labels in a MS access database switchboard
dynamically generated based on values in a table? I have a table of
items (let's call it table Main) , each of which is assigned to a
category. The list of categories is stored in a separate linked table

I have an app which I originally developed using macros, not VBA.  As a
result of literally everyone telling me that I need to convert it to VBA I am
doing that one module at a time using the built-in macro converter and then
going through the code to optimize it.  In the process ...

I have a tekstfiled where the path to a image are in
the i have a picture in my form
now i want to do it so the path to the picture are the same as in the
textfield

How can I know the row and col of a MSFlexGrid when I click a cell?
Someone ca help me?
Regards, Lina

I've read the discussions and tried different things until my head is
spinning, but it's still not working.
The list for my combo box is hard-coded into the RowSource property as a
value list,  but I'd like my combo box to be able to store any new entered

Where do I get information on how to use the datagrid control?

I have a report and I need to display totals in the report footer.  I
have been using sub reports for the values I need but it asks me for
the master number about 10 times when I only want it to ask for it
once.  I was wondering if there was a way to use VBA to get the totals

I am a novice programmer who is in the real estate business. I use Microsoft
Access 2000 to maintain my business information and use some code to ease my
labors.
A database I have with some code has worked fine in the past. Out of the

I am building a database and I have a rather large "Select Case" statement.
I have teachers enter a course their students have completed, the function
looks up the correct control and then places the information in that control.
Because the "Select Case" statement is so long, I ...

I need to create an export (text) file in which the "fields" are of a fixed
length and in some cases of a different length to those in the table/query.
For instance, on the example below, "txtacctnumb" need to be 20 characters in
length whereas in the table it is 10.

I can programatically create a new (copy) database using VBA but, I have one
library that exists in the current db that is not in the new db.
The library is "Microsoft DAO 3.51 Object Library"
1.  How can I append / select this library in the new database from the

Can anyone help me with the type mismatch in the following?  Everything is of
type text.  Thanks in advance.
If Not (IsNull(DLookup("txtName", "tblISS", "txtName = """ &
cboName.Column(0) & """" _

I have an application .mdb that has links to tables in another .mdb file.
When the tables .mdb is on a server and the appl is on a workstation in the
same network, I want to dynamically link the tables when the appl first
starts. But when I do this it takes a VERY long time for ...

I'm running some Make Table and Append Queries. Now I want to run all of
them in a row without pop-ups like: "You are about to paste..."
I should appriciate if you are able to provide me a completeed Sub because I
haven't so much experience of VBA programming.