Form Design Question

[Guest]

I have a client that wants their data entry form to have the look and feel of
Excel. The basic format they want is below.

Units Dollars
Project ID Rate Jan Feb Mar Jan Feb Mar
56 10 5 7 15 50 70
150

The units are actually stored in the table by week ending date vs. month.
After the monthly units are entered by a user, they would be converted to
weekly units and then saved to the database. As a result, in order to get
the monthly view, a crosstab query must be used. The dollars are calculated
by multiplying the units by the rate. My initial response was this cannot be
done. I know Access has a data grid control in the toolbox, however, I have
been unable to locate any good documentation on this control. Can this
design be accomplished using Access? Thanks for your help.

Weste

 

[Jeff Boyce]

If the client wants Excel, why not give them Excel?

You could still link to the Excel data from within Access, for whatever you
expect Access to be able to do...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Peter Hibbs]

Weste

A Flex Grid control may do what you want (if you are prepared to write
a bit of VBA code). Have a look at my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples.

Peter Hibbs.

 

[Guest]

Peter,

Thank you very much. That is exactly what I am looking for.

Weste