On Thu, 26 May 2005 13:28:47 -0400, A strange species called "Douglas
J Steele" wrote:

It sounds to me more like you need an Access database than an Excel
spreadsheet. In my opinion, Excel is far better for analysing data, rather
than working with the data one row at a time. Recognize, though, that you
can't just take a spreadsheet and implement it in Access. To be effective,
an Access application should have a properly normalized database.

I'd be very surprised if you could create a form in Excel that couldn't be
reproduced in Access.

I don't see anything in your writeup that suggests that you're actually
going to be mailing the reports, so I'm not sure how mail & merge fits into
the equation.

Thanks for the reply. I have gone the Access route and have made some
great progress so far.

I imported the spreadsheet data from Excel to Access.

I went through the wizard to create a form.

I then created another form in design view and copied the original
form/layout design from Excel to Access. I then copied the fields
from the first form the wizard made into the right sections of the
design.

I am just a little stuck now though.

The form that the wizard made is okay in Form View and displays all
the data from the table, but the form I made and copied the fields to
has strange words in all the fields and isn't getting the data from
the table.

It is displaying #Name? in all the fields. And there are no records to
move to the next one etc in Form View as with the form the wizard
created.

Do you know how I can fix this so it relates to the right fields from
the table?

I am guessing I need to click on each field and then go to properties
and there must be something in there I need to do to get it to relate
to the table data?

Thanks very much for any help

John

"John" wrote in message
...
The form that the wizard made is okay in Form View and displays all
the data from the table, but the form I made and copied the fields to
has strange words in all the fields and isn't getting the data from
the table.

It is displaying #Name? in all the fields. And there are no records to
move to the next one etc in Form View as with the form the wizard
created.

Do you know how I can fix this so it relates to the right fields from
the table?

I am guessing I need to click on each field and then go to properties
and there must be something in there I need to do to get it to relate
to the table data?

Have you got the correct record source for the form? If so, then yes, you'll
probably have to go into the properties for each control and change the
control source property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Doug,
If I could slip this note in here...
A few days ago (in an old post) we discussed using the "filter" for a
form as the filter for a report...
Dirk Goldgar, you, and I, thought it would fly...
Well, it does... and it really works great!

In the past I've done all sorts of convoluted parameter queries, or built
complicated criteria forms, or used complicated multiple "argument" strings
in the OpenReport function... all trying to obtain report "flexibility".
What a pain!

Here's the code I use... couldn't be simpler...

Private Sub Report_Open(Cancel As Integer)
If Forms!frmCustomers.FilterOn = False Then
Me.Filter = "CustID = Forms!frmCustomers!CustID"
Me.FilterOn = True
Else
Me.Filter = Forms!frmCustomers.Filter
Me.FilterOn = True
End If
End Sub

When the user is looking at all the records, the report only prints the
one record being displayed.
If the user filters the form recordset (ex. by City returning 100
records), the report prints those in a "batch"

Thanks for the help,
Al Camp

"Douglas J. Steele" wrote in message
...
"John" wrote in message
...
The form that the wizard made is okay in Form View and displays all
the data from the table, but the form I made and copied the fields to
has strange words in all the fields and isn't getting the data from
the table.

It is displaying #Name? in all the fields. And there are no records to
move to the next one etc in Form View as with the form the wizard
created.

Do you know how I can fix this so it relates to the right fields from
the table?

I am guessing I need to click on each field and then go to properties
and there must be something in there I need to do to get it to relate
to the table data?

Have you got the correct record source for the form? If so, then yes,
you'll probably have to go into the properties for each control and change
the control source property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

dont get discouraged; keep up the good work!!

excel is a disease--- i am glad that you're going in the right
direction.

still dont know what you mean by
In my opinion, Excel is far better for analysing data, rather
than working with the data one row at a time.

what do you mean analyzing data?

i mean seriously here-- i just dont believe that you should be allowed
to say those types of things.. if ANYTHING is strong at analyzing data
(looking at it across multiple levels and or hierarchies) then i say
Access is MUCH better than Excel for 'analyzing data'.

i think that excel is crap; and 50 of corporate america-- is making the
wrong decision by letting these idiots use Excel.

train them on Access or Crystal Reports-- I'm just burnt out on
recreating the same XLS week in and week out

-aaron

wrote...
....
excel is a disease--- i am glad that you're going in the right
direction.
....

Nice Troll!

Didn't take long for this to become an 'advocacy' thread.