show Access data in Excel sheet using form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there;

I am working on an Access database that was created using Access 2000, but
now I'm on 2003. My question is this: I have a report that needs to be
imported into an excel spreadsheet from an access database. On the front end,
there is a button that gathers the information from the queries, and then its
suppossed to compile the information and send to an excel spreadsheet which
is then emailed out to a management group. The problem I am having is that
when I select the Excel option on the report form, the heading options are
not showing on the excel spreadsheet, nor all the information showign as it
should. Is there something simple that I am missing? is there a particular
way that I should be setting up the Report Form that would make this easier
and complete?
 
dakoris73 said:
Hello there;

I am working on an Access database that was created using Access 2000, but
now I'm on 2003. My question is this: I have a report that needs to be
imported into an excel spreadsheet from an access database. On the front end,
there is a button that gathers the information from the queries, and then its
suppossed to compile the information and send to an excel spreadsheet which
is then emailed out to a management group. The problem I am having is that
when I select the Excel option on the report form, the heading options are
not showing on the excel spreadsheet, nor all the information showign as it
should. Is there something simple that I am missing? is there a particular
way that I should be setting up the Report Form that would make this easier
and complete?
Click to expand...

Just thought that I would add this extra piece of info that might help make
this easier:

I am using a report form that uses a Macro to collect the data from the
individual fields within the database. When the report is generated, the
Excel sheet is showing headings such as "Text1", "Text31", "Text39", ect.....
and also the other headings are showing as the function names such as
"CallsAns", "NotReady", ect.
I have the fields on the Report Form listed in the Detail section underneath
the Header information, and nothing in the footer at all. Within the Header
section is another header labeled "AgnetID Header". What can you suggest
that would allow all these fields to be displayed correctly within the Excel
sheet, cause it all displays as it should in RTF or HTML formats, but the
information needs to be in Excel. These are formulated and sent to Excel by a
Macro button that compiles and emails this excel sheet out. I hope that
explains enough to help you see where my problem might be.
 
Hello Arvin;

I'm sorry, but I'm not sure what that means. I noticed that the Text fields
in the REPORT form that I created are being transfered to Excel. However, I
am still at a loss as to how to create labels or headers that differentiate
each column for more readability. Again, I am using a Macro to gather the
information into a new report that is exported out to Excel, and this is
generated weekly with a command button. Is there an Easy way using the REPORT
form to get all the necessary fields labeled correctly, and also get the
information sorted correctly and functions working or am I going to learn how
to use VB to send the information over?????
 
I'll try and explain it so it makes a bit more sense.

A form or report has controls, textboxes, comboboxes, subforms, listboxes,
command buttons, etc. Some of them are bound to a field in the underlying
table or query. (But they don't have to be, they can be coded and unbound).

These controls have names, which may be the same as the field (if created
with a Microsoft wizard) or different if you create the form or report by
manually adding these controls into the design view. When it's done
manually, you get names like: Text1, Text2, etc. If you click on the control
to select it in design view, you can change the name on the Other tab of the
property sheet. You can change the label caption of a single form view label
on the Format tab of the property sheet.

To change column heads in a query, set the caption property of each field in
the underlying table, or use an alias column in the query, like:

MyLabel: [My Field Name]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Hello Arvin;

Thank you for that clarification on this. I will look more into this, and
see if I can do something with these text fields.

dakoris73

Arvin Meyer said:
I'll try and explain it so it makes a bit more sense.

A form or report has controls, textboxes, comboboxes, subforms, listboxes,
command buttons, etc. Some of them are bound to a field in the underlying
table or query. (But they don't have to be, they can be coded and unbound).

These controls have names, which may be the same as the field (if created
with a Microsoft wizard) or different if you create the form or report by
manually adding these controls into the design view. When it's done
manually, you get names like: Text1, Text2, etc. If you click on the control
to select it in design view, you can change the name on the Other tab of the
property sheet. You can change the label caption of a single form view label
on the Format tab of the property sheet.

To change column heads in a query, set the caption property of each field in
the underlying table, or use an alias column in the query, like:

MyLabel: [My Field Name]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

dakoris73 said:
Hello Arvin;

I'm sorry, but I'm not sure what that means. I noticed that the Text fields
in the REPORT form that I created are being transfered to Excel. However, I
am still at a loss as to how to create labels or headers that differentiate
each column for more readability. Again, I am using a Macro to gather the
information into a new report that is exported out to Excel, and this is
generated weekly with a command button. Is there an Easy way using the REPORT
form to get all the necessary fields labeled correctly, and also get the
information sorted correctly and functions working or am I going to learn how
to use VB to send the information over?????
Click to expand...
Click to expand...
 
Back
Top