I am using Access 2002.
I was having some issues with using the SetValue on subforms and learned
here that I need to identify the subform and subform control to get the
Setvalue macro to work. Now that I put about ten subforms on a Tab Controll

If the field type is number is there a way to limit the size of the field?  I
need to create a flat file (ascii) from an access query but the field sizes
must be exact.  Does anyone know how to create a flat file (ascii) from a
query?  I have only been able to use a macro to ...

Hey everyone.
I've recently set up a SendObj macro to e-mail personal reports to
management members in one fell swoop.  The macro consists of about 25 SendObj
calls, each sending a different report to a different e-mail.  My problem is

I have a macro that outputs the results of a query to Excel, however if the
file already exists it prompts to overwrite it - Can I get around this?
I assumed that if I called the Macro from the Main Switchboard form which is
auto opened when entering the db I would'nt have this ...

I am attempting to get Access to behave in a way that is similar to Excel in
some respects...  Currently, payroll is using excel to post weekly employee
hours.  The current list of employees is posted with the hours they worked
for each day during the week on one worksheet, the ...

I am trying to run a Master Macro that will run (4) child <output to> macros,
where each child has a start time and end time criteria for the queries.  
Sounds easy, however I am wanting enter the start time and end time only once
for all (4) queries and have Access populate the ...

My database does sometimes create tables (purposely) while running, which
should be deleted at quitting. The names of those tables are known. If I
delete those tables while they are not present the macro gives an error
message. What condition should be created in the macro so ...

i'd like to write a macro to delete all excel files from my desktop.  i've
tried using the record macro option but can't even get it to delete one file.
i was hoping for some kind of wildcard code like statement*.xls.  can anyone
help

Hello - I have created a simple contact list (300 entries) and everything is
running fine EXCEPT when I want to send an email to the person in my address
book I can only seem to get Outlook Express to open - not actually open an
email message with the subjects address in the 'To' ...

How do I set a textbox in form to show:-
- blank if the contain is zero
- 7.25 if the contain is 7.25
- 7 if the contain is 7

How can I create a macro that will change a field, within a table, format
from text to currency?  The field is created by a query expression that
defaults to text.

Oi!
Excuse me for mine insist:
Can I to activate a macro to run automatically in one date previously chosen?
Thanks in advance.

I have a combo box that is looking up values in an inventory table.  I want
to set up the limit to list property and the on not il list event to display
a custom dialog box, whick happens however the stock limit to list message
also appears.  I need to disable the standard error ...

Is it possible to schedule a macro to automatically run each month without
even opening the database?

I am trying set up data validation routines.
This specfic one involves deposits and amounts if there is ck number then i
want to enforce entering an amount. The macro for this is:
'------------------------------------------------------------