I am building a form for the user to create a new record.  Because the data
that is entered is for several different tables, none of the fields are
bound.  Some of the fields are loaded with default values when the form is
opened (e.g. the IDnumber field is loaded with the next ...

After realizing that Macro's were a bit limiting, I decided to begin coding
VB for my buttons.  So, to that end, I'm trying to get a button to open a
product release sheet for a specific date range (basically everything from
the last two months up through the next 3 months).  ...

I am currently running a macro to copy a string of text into memory.
I want to paste this text into a table in microsoft word.
However in a table vbTab just tabs inside the table and does not move onto
the next cell. The same happens for vbCrLf - it doesnt enter into the cell

I wish to create a macro that will open Tools/Office Links/Merge with Word
and open my main document and merge.
Is this possible?

I'm looking forward to learning as much as possible from these discussion
communities. I've already learned more from reading two posts than I have by
spending several hours reading the thick Access book.

I interfaced my MS Access 2003 DB to ASP. When the user clicks on SUBMIT and
a new record is added to the main table, I'd like to fire an email from MS
Access to inform me that a new record has been added and update the status of
that record from T=Transmitted to R=Received

I am having a problem with a macro.
I have a database for my artworks.  props were used in the creation of some
of these.
When I have the details of an artwork on screen (as a form), On that form I

It gets set up as an Excel spreadsheet...
And I have a To recipient but I get a pop-up with a blank recipient showing.
What's the catch?
I am using Outlook Express and have added the email addresses to the

I inherited a database that when opened it pops up a form the does a thirty
second countdown. If it times out a macro is called and the database starts
updating from linked tables, if cancelled the users are directed to a
switchboard and begin working. Windows scheduler opens ...

I have tables that are created when i import a file to my database.  the
tables are called sheet1$_errors
sheet1$_errors1
sheet1$_errors2

Hello.  I'm trying to summarize some numeric data based on its location
relative to a label field.  I have a set of surveys.  For each survey there
are three relevant columns of data (LABEL, DISTANCE, and DEPTH).  Not all the
values have labels, and each survey has a different ...

I am trying to write to an output file (C:\Arguments.txt) and am gettin
nothing in the file. The VBA subroutine work just fine, and it create
my file, but when I look at it through Notepad, I see nothing. I clos
the file, but when I minimize the Access application and try to delet

Steve Schapel gave the following response to a question on how to run muliple
reports:
"Doing this with a macro probably needs to involve:
 - make a continuous view form with your list of names

I have a macro that will allow users to print specific reports by clicking on
a button.  On one day of the week I need a somewhat different report to
print, but I don't want to add another button to the form.  I would like the
macro to print the correct report by determining the ...

I am trying to set my macros level in access 2002. When I go into Tools ->
macro, I have no security option. How do I change my level?