export ACCESS form to excel with the exact appearance

[thread]

Hi all,
i need to export a form with almost the same appearance
when i'm exporting it for now,i'm getting straight line of data when
the labels are getting the name of the textboxs
is there a way to configurate the data and place exported from the
ACCESS to the excel?

 

[thread]

the question here is if its possible to orginize the fields and data
labels when exporting ACCESS form to excel file?

thread ëúá:

 

[John Vinson]

the question here is if its possible to orginize the fields and data
labels when exporting ACCESS form to excel file?

Access forms work in Access.... as far as I am aware, they do NOT work
in Excel. The structure and logic of an Access Form is different from
that of an Excel form.

John W. Vinson[MVP]

 

[thread]

yes but when you are exporting the data to excel it have some structure
when the header texts boxs appears first then detail and in the end the
footer text boxes
so you want to say that there isnt any way to handle the pointer
producing the coordinators to the excel files
sounds wired to me
John Vinson ëúá:

 

[John Vinson]

yes but when you are exporting the data to excel it have some structure
when the header texts boxs appears first then detail and in the end the
footer text boxes
so you want to say that there isnt any way to handle the pointer
producing the coordinators to the excel files
sounds wired to me

I'm sorry, I don't know what "pointer" or "coordinators" means in this
context. And you did NOT ask about exporting data to a spreadsheet;
you asked about exporting an Access Form to an Excel Form. Forms are
NOT data.


John W. Vinson[MVP]

 

[thread]

Hi John,

but when you are exporting a form you will get the data placed inside
as well so why there is any diffrence?

John Vinson ëúá:

 

[thread]

Hi John,

but when you are exporting a form you will get the data placed inside
as well so why there is any diffrence?

John Vinson ëúá:

 

[John Vinson]

Hi John,

but when you are exporting a form you will get the data placed inside
as well so why there is any diffrence?

A Form is a tool, a container, a programmatic object. It does not
contain data; it *DISPLAYS* data.

The form is *not* the data.

John W. Vinson[MVP]

 

[thread]

so how can i can control the data the is DISLAYED on the form to change
it as i choose on the excel spreadsheet

John Vinson ëúá:

 

[aaron.kempf]

don't export to excel.. give a simple office web components (insert,
activex control, pivotTable control) and then make it drag and drop
within Access.

when they want to export out to excel (which you don't want to allow
anyways) then they can hit the MS button that exports to Excel and it
will keep SOME formatting.

-Aaron

 

[John Vinson]

so how can i can control the data the is DISLAYED on the form to change
it as i choose on the excel spreadsheet

Base the Export on the same query as used on the Form - or, if you
just want to export the one record, create a new query referencing the
form control which uniquely identifies the record as a criterion:

=[Forms]![YourFormName]![SomeControlName]

on the criteria line.

John W. Vinson[MVP]

 

[thread]

Hi Aaron,
this is the main thing here,this is what needed,the option to export
what shown on the access application export it to an excel version for
calculation reasons
the issue is that the fields are not coming nicly on the excel,when
there is names of the components(instead of captions) and the totals
are been multiplyied
this is what i'm trying to control and change if possible

(e-mail address removed) ëúá:

 

[thread]

Hi Aaron,
this is the main thing here,this is what needed,the option to export
what shown on the access application export it to an excel version for
calculation reasons
the issue is that the fields are not coming nicly on the excel,when
there is names of the components(instead of captions) and the totals
are been multiplyied
this is what i'm trying to control and change if possible

(e-mail address removed) ëúá: