Want different Excel spreadsheet data on each Record in Access.

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

Guest

I want to have a small spreadsheet that I can enter budget information for
each Record on my Form, but it won't let me enter different information for
each Record. The same information is carried over to the next record.
 
You're losing me here. A spreadsheet that feed the data? How do you get
the data from Excel into Access?
 
I want to enter the budget information for each of my projects separately on
each record. To make it look nice and add all the numbers automatically, I
want to put it on an excel sheet, but that is where I have a problem. I used
the toolbox to put an excel sheet on the design view, but on the form view
the same numbers I enter on the first record carry over to every record. How
do I make it so the budget information I enter on one record doesn't carry
over to all the other records?
 
Hmmm. I'm not sure how to do that. Perhaps I am using an older version of
Access. I don't see a way to create a spreadsheet in a form that can be
used to fee the table.

Have you tried simply using a continuous form (datasheet view)? This will
look very much like an Excel sheet, but will be better suited for feeding
the data into the table. (If that is what you have done, post back and we
can take a closer look at your table structure.)

Maybe someone else will read your post and jump in with some advise.
 
Can you tell me how to set up a continuous form? That sounds like it should
work for what I want to do.
 
The following will create a form that has a "continuous" sub form.

1) Create an unbound form, make it the size you want with titles and/or
hints on it that you want.
2) Create a query that will access the information that you want
loaded/updated via this form setup.
3) On the first form place a subform and have it bound to the query
created in 2
4) in this subform in the Properties - Format - Default View select
"datasheet" view
5) In your description above you mentioned calculations - to get them
onto this form you will need to add logic for each field related in a
single calculation add the calculations to compute the resulting field.
(ie if there is a quantity and an unit price to result in line total
then in the after update for both quantity and unit price you will need
to have it do the multiplication. You will probably want to make the
result field in all cases 'locked'. This stops the user from updating
them but still allows you to compute it from within.
6) If there is related key information that must be entered, then be
sure to update these fields in the before insert event.

Hope this helps
 
Back
Top