Today I have a spreadsheet that contains 100 different sheets in it. In
my module I have to run a macro in each sheet in order to recieve the
final outcome.
Is there a way I could run one macro that will run on all the sheets at

When I display a message box, how do I set the Title Bar of the message box
to show the name of my application without explicitly specifying it?
The help says "If you omit title, the application name is placed in the
title bar.". But I've set every possible Title I can find:

If the text value of the node in a treeview control is known, how can the
index of that node be determined?
Any insite will be appreciate.
Mr B

I am working on a validation of a database and I need to check whether or not
a field contains positive integer numbers.
I have created a function called "is_pos_integer" which accepts a variant
parameter and returns a boolean result.

I would to find out how to do this under program control. This way, once the
location is determined, I can create commands that can use MSACCESS from the
command line. Any help of sample code would be appreciated.

This code is suppose to open a table containing about 30 table names.  It
should them look through the sql of each query in the db and see if the table
name is referenced.  If so, it sets an indicator to true and writes that
query name to a separate table.  It then searches for the ...

Hi, I want to link to the accounting package MYOB. Does anyone know the file
type and drivers that I use to achieve this?

Hi, I want to use vba to open another database. When I do, the autoexec in
the other database is triggered.
How can I open this other database without running the autoexec in the other
database?

I am drawing lines using the Me.Line method during the Print event on an
Access report.  (The lines adjust to the size or resizable controls.)
Any lines I draw appear behind the existing controls on the report.  I would
like the lines to draw on top of the controls.

I'm having a problem with the following function.  The data is written to a
temp table, formatted and then exported to Excel.  The function is supposed
to look for the temp table first and delete it if found.  Sometimes it does,
sometimes it doesn't.  Stepping through it, the IF ...

I have an app in which I am shelling out to FTP to download some files but
killing the FTP session if it times out or otherwise hangs. However, Windows
2000 uses kill, whereas Windows XP uses taskkill. How can I determine the OS
at runtime so that I do not have to manually change ...

I often need to work with double byte character fields (Japanese characters)
in my Access application. Now I have 2 questions.
1. How can I detect double byte character in a field ?
2. If possible, I want to convert double byte alphabet character to single

I want to create a button on the form so that when user click on it, it can
download the files from internet with default link. (eg.
http://www.abc.com/abc.jpg)
Any function I can use to handle it?

I am using Access 2000 I need to create an input mask for numbers like:
0123456789-12
10 numbers a dash and 2 numbers and the first digit to accept Zero's.
Could you help?

I need assistance with the following. I have five Fields and must Calculate
Storage Days.
Date Received   (Date/Time)
Date Stuffed      (Date/Time)