Dear Sir or Madam,

How come when I am viewing a report I can use the File,Save And Export, 
to 'Excel Spreadsheet'; but if I place a Command Button which creates a 
Command Tool box, I can not read the output. Both have been directed to a 
specific file on my Network Drive.

Please help

> Dear Sir or Madam,

> How come when I am viewing a report I can use the File,Save And Export, 
t> o 'Excel Spreadsheet'; but if I place a Command Button which creates a 
C> ommand Tool box, I can not read the output. Both have been directed to 
a 
s> pecific file on my Network Drive.

> Please help

Command Tool Box = Common Dialog Box

Kenneth,

If you used the wizard to create the button - a common practice - the 
button
will be created based upon certain assumptions which may not be exactly 
what
you want.  You may need to manually edit the code - particularly the 
options
- to get the behavior you desire.

I do it all the time - I use the wizard to create a button and then I
manually edit the code to tweak the behavior.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: KennethMungwira [mailto:KennethMungwira@Y...]
Sent: Thursday, March 28, 2002 9:13 AM
To: Access
Subject: [access] HOW COME? ' Transfer Report'

Dear Sir or Madam,

How come when I am viewing a report I can use the File,Save And Export,
to 'Excel Spreadsheet'; but if I place a Command Button which creates a
Command Tool box, I can not read the output. Both have been directed to 
a
specific file on my Network Drive.

Please help