Page Set Up and Export

L

LMB

Hi Guys,

Using Access and Excel 2000.

1) I have a crosstab query the we want to print weekly. I set it up to
print landscaped with .5 inch R and L margins I then saved it. Every time I
run the query, I have to re-set the page layout, it keeps defaulting to 1
inch margins and portrait . What can I do to keep the settings?

2) Is there a way to set up an excel sheet to pull the data from this query
so it's as up to date as the query?

Thanks,
Linda
 
M

MGFoster

LMB said:
Hi Guys,

Using Access and Excel 2000.

1) I have a crosstab query the we want to print weekly. I set it up to
print landscaped with .5 inch R and L margins I then saved it. Every time I
run the query, I have to re-set the page layout, it keeps defaulting to 1
inch margins and portrait . What can I do to keep the settings?

2) Is there a way to set up an excel sheet to pull the data from this query
so it's as up to date as the query?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

1) Your are describing a well-known bug in Access 2000 about printers.
The solution is to install the appropriate service pack for Access 2000
(see MS Knowledge Base site). Part of the solution is to turn off the
Name AutoCorrect option: Tools > Options > General tab > uncheck Track
name AutoCorrect Info.

2) Use the Excel "Data" menu item - get external data (near the bottom
of the menu). Follow the instructions on the dialog boxes to indicate
that you want to use an Access query. The query must not have any
function calls (user-defined functions, Access & VBA built-in functions)
in it 'cuz Excel won't be able to intrepret those calls.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQxS6ZYechKqOuFEgEQJHDACghwhDhClHAASMYBMxsjb2wCfnmZIAnAqH
kgpJejd1FBdVlsp54CxN3zxs
=sxxc
-----END PGP SIGNATURE-----
 
Top