Lawrence Mrazek
lmrazek at lcm-res.com
Thu Nov 17 16:01:08 CST 2005
Hi Jim:
I'll need to populate it by groups ... Each group will have 12 rows and the
same number of columns. So I'm thinking that I'll have start at a set
position for each sheet, and then populate down from there, skipping a
couple of rows after each grouping level. Basically, I'll need the company
total to be at the top, followed by all of the subsets of the data grouped
by category.
Data will look something like this (will probably have about 9 columns
total):
Heading: Total Data By Company
Month: PriorYrSales CurrYrSales %Increase (calculated)
Jan 10 10 0%
Feb 33 66 100%
Mar 111 111 0%
Apr 112 112 0%
May 111 111 0%
Jun 444 444 0%
Total --- ---
Heading: Total Data By Category 1
Month: PriorYrSales CurrYrSales %Increase (calculated)
Jan 10 10 0%
Feb 33 66 100%
Mar 111 111 0%
Apr 112 112 0%
May 111 111 0%
Jun 444 444 0%
Total --- ---
I'm thinking of looping through recordsets to get the separate data by
category.
Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Thursday, November 17, 2005 2:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Export To Excel - Formulas Possible?
The basic way to plug a formula into a spreadsheet is along the lines of
appExcel.range("f63:j63").Formula = "=k63"
Access won't "remember" but there are various ways you can figure it out.
How are you populating your spreadsheet? cell by cell? one big copyrecset?
Tell me a bit more and I may be able to tell you the best way to set your
totals.
Jim Hale
-----Original Message-----
From: Lawrence Mrazek [mailto:lmrazek at lcm-res.com]
Sent: Thursday, November 17, 2005 10:23 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Export To Excel - Formulas Possible?
Thanks Jim (and Paul):
I've run through a couple of samples and have successfully exported a
recordset, created a new sheet, and it looks like I should be able to do
this ... My main concern is the embedding of the formulas in the rows ... Is
it possible as I export the recordset to create a calculated column ...
EX: Column1 Column2 Column3 (calculated Column1 + Column2)
Oct 2 5 7
Nov 4 8 12
Total 6 13 19
Basically, can the Access application "remember" which cells it wrote to, so
I can create out a totals row? Just trying to figure this out before
committing to the project.
Thanks!
Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Wednesday, November 16, 2005 4:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Export To Excel - Formulas Possible?
Yes, you can dynamically add formulas to spreadsheets you create through
Access. You can also add worksheets as required.
Jim Hale
-----Original Message-----
From: Lawrence Mrazek [mailto:lmrazek at lcm-res.com]
Sent: Wednesday, November 16, 2005 9:29 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Export To Excel - Formulas Possible?
Hi:
I'm developing specifications for a reporting app that pulls information
from a corporate database. While the print reports won't be a problem, the
client also requires an export to excel with the following functionality.
1. Single Worksheet with multiple tabs
2. Application calculates totals in Excel. (that is, if they make a change
in the data in Excel, it is reflected in the totals).
Question. Can I automate the creation of the spreadsheet if I have to embed
formulas to calculate totals, percentages, etc.? Or do I need to first
create a template in Excel? I'd like to be able to do this from Access,
since they'll be adding group categories to the list and I don't want to
have to continually revise the excel file.
Thanks.
Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304
***********************************************************************
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email, you are
responsible for screening its contents and the contents of any attachments
for the presence of viruses. No liability is accepted for any damages caused
by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
***********************************************************************
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email, you are
responsible for screening its contents and the contents of any attachments
for the presence of viruses. No liability is accepted for any damages caused
by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com