I have created a macro which uses several queries to open and append twelve
tables to one table.  I typically come up with an error that says "type
conversion failure" even though the column headings are the same and the
data types are the same.  Your help would be greatly ...

is there a way to cause a macro to pause in MS Access while a form is
displayed to make corrections to some data.  Then when you close form the
macro will continue on.  Thanks

I have created a number of VBA functions in an Access database and am trying
to use them in a macro. I have tried RunCode, OpenStoredProcedure, among
others, but Access can't seem to find any of my functions. I have them placed
in a module and a static class module but none are ...

Greetings!  Have a UDF that is used in an append query, and it chokes on a
particular source data combination.  Is there a simple and direct method to
determine the record number in the source table when this happens?
Thanks,

Total newbie, easy question, but I can't find the answer.  I have 3 columns:  
Old DocID, Effective Date, and Procedure. I want to append the text strings
from the other columns to create a new Doc ID column.  So:
DocID(77343)_11-08-2000_High-Dose

I would like to run a macro that runs a query then takes the results and sows
them to me in a form.  How can I set this up?
Thanks for the help.

Access 2003:  One of the steps in my macro opens a form.  How do I pause
execution of the subsequent steps until the user closes the form?  I've seen
the responses that reference a "timer", but that isn't applicable in this
case.  I've also tried making the form "modal", but that ...

In Access 2000, I have two fields in a database that I want to populate with
year-dependent values.
The first field is the last two digits of the year in which the record was
added, saved as text format. I used Expression Builder to automatically

I have set up a simple macro that distributes the results of a few queries
to named recipients.
I have set up a SendObject Macro, it has a sendObject action for each
location query. There are approx 70 locations. I have added the

I have an access DB and i need to convert my FirstName and LastName fields  
to proper case.  I have absolutly no idea how this is done.  i have read some
of the other threads and it appears i need to use the following string:
=StrConv([FirstName],3)

I have a form with about 20 fields and this form is bind to a table
where when I click submit, the data from the from will be saved to the
table that it binded to. Now there are certain fields that I do not
want to refresh when I hit submit. Is there a way to preserve the value

I have created a macro which seems to be working, but there are a few
problems.  I want the macro to check if certain conditions exist and if they
exist , then I want a dialog box to pop up.  The user has the option of
entering information into this dialog box.  Upon closing the ...

I have two forms. The first has four fields:
Name
Current work status (are they working for the company)
Status (temporary or permanent staff)

I have two reports that I want to print from a command button.  I want the
user to supply a date as a parameter one time and have the macro print two
Thank You letters, one for New Members and one for Renewals.
As it stands now, both reports use a single query that prompts for a ...

I have a form that uses a combo box to look up Parts. The user enters the
quantity of the part to order and the OnHand number shows up. Now, what I
need to do is add a button to "Update Inventory" that will commit the
Quantity, go back out to the Parts file, and subtract the Part ...