Is there a way to set a variable within the macro that the macro can use for
different steps??  Specifically, I want to be able to pass a value to a VBA
function.  Also, is there a way to take the "output to" command's file
name/path setting and put so type of variable in it to ...

Is there a way to convert a mdb file into an exe file. Or if that can't be
done converting a mbd file to visual basic so an exe can then be made?

Is there any way to remotely close all instances of a single database
currently open on multiple computers.

I just went to print out some of my code.  And...found out that I couldn't.
(Unless the solution is still hiding from me.)  Am I correct in assuming that
Access (2k) has no "built-in" provision for printing code?
Has anyone found any product to do this that they like?  To stay away ...

I've never coded VB in my LIFE here =) Good times. I found this code which I
believe was posted by Allen Browne - thanks Allen.
Anywho, I have 3 subforms. I want to create a duplicate invoice with
duplicate records. The only things that get changed are the Invoice ID and

I have a table (download of data so have no control over structure) that
looks like this:
ProductName Comp1    Comp1Qty    Comp2    Comp2Qty ..... Comp32
ABC                 XYZ            2                VWY        5

I have a report that has 6 sortable fields.  The users wants a form with the
same six fields on it so he can select the data that he wants to print out on
the report.  I can make my report recordsource equal to the fields on the
form, but what if he doesn't make a selection from ...

I am using Access 2002.  I'm working on a database for inventory.  There will
be 4 different databases that periodically will be combined.  I need an
inventory number to be automatically generated.  I was going to assign a
range of numbers for each location, so there would be ...

I have to strip all HTML tags from a line of text including the < >. All
tags are of a variable lenght(ie.<Bold>).
  Thanks you very much for your help,
 Tom

All,
 I have to strip away all HTML tags that will appear embedded in each
record.
Basically, I have to write something that would delete anything between <

Could anyone help me with some code to send email by GroupWise?
(I can already do it via Outlook)
Thanks,
Wesley

I would like the user of my application to be able to call a windows dialog
box and select from from dfferent back end databases that may stored in
different places on the network. The access app would then relink the tables
to this new BE location.

I have For on vb.
When i want to leave it before i'm using Exit for
Now i have nasted loops:
For i = 1 to 10

If I have an old Access 97 database, how can I tell if the form controls are
bound early or dispid?

I need to copy existing own menus in Access 2003. Can you advice a way to do
this?
Thank you.
Flemming Ast