I'm a pretty seasoned Access developer and have a problem now. I need to
reprint a certain report multiple times from code, each time for a diferent
customer, meaning the report changes for each printout.
These reports need to be printed to a file, not a printer. Each "printout"

I have a report that includes a sub report. The sub report calculates totals
based upon the record displayed in the form. I have code that executes and
calculates these and stores the values in a table. The sub report looks at
this table for the data. If I run the code so that ...

Please help
I have a form "Select a name" where i want to be able to double click the
name(one name on a continuous form field is called "new name") and have it
then update a completely different table("All Names") and a field called "new

I create my own tables, form, reports and macros to manege my problem. how i
create a executable program.

is there a way to create a macro or a toolbar with buttons when pressed they
insert specific lines in the code?
This will save me  alot of time and error in typing or copying/pasting the
error handlers in different subs

I need to be able to round values to this specification using vba in Access2003
£0.005 or less is disregarded, we only look at the third decimal place.
If it is 5 or less round down.
If it is 6 or more round up.

I'm using a form within my access to send mail through the default
account/profile.
Although I was able to change the settings for the read receipt and delivery
receipt I do not succeed to change the reply-address (have replies send to

I have all my  customers details in Access 2003.
All the appointments with them, I copy from my  handwritten diary (I only
make appointments through phone calls)
I would like to have an interface to my Access program,  like Outlook's

I'm building an XML file by looping through records in a table. Some records
may have a bad CustomerID that I've flagged earlier by appending a 1 to the
record.
I'd like the Loop to skip to the next record if it sees a bad ID flag. How

I am trying to put the maximum number on the Y Axis automatically instead of
entering the maximum number.  My numbers will change over time as more data
is added.  I noticed the following code to add from another question from
someone.

I know that by using the RunCode action of a macro you can call a Function,
but is there any way to call a Sub directly?
If I understand correctly, the main difference between subs and functions is
that a function is used to return a value whereas a sub cannot.  

I receive an error when opening my startup form.
Couldn't use"; file already in use
This code connects to a front end Access database, that is linked to a back
end.

I recently discovered that access user based security does not have logOff
capabilities. The only way to log someone off is by quiting the application.
Personally, I feel this is a huge error on MS's part for not including.
Now on to my problem. I need to have a user timed out of ...

I want to design an algorythm that will test proper nesting of open and
closing chars such as brackets and parens, and then get the appropriate
position of the closeing char.  For instance:
In these expamples I want to know which paren closes the first paren

As part of a function I use, a few excel files are opened. The problem is
that Excel becomes the active window and the user is not seeing a
prompt/message box in Access that is used to complete the function. They only
see the prompt when they return to Access. Is there a way to ...