Update Table

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

Guest

Hi
I am not sure how to put into words what I would like to do but here it goes.

I have a table which needs to be update from a form.
The form has 3 text boxes which I have no problem with.
I was considering using the subform to create like a spreadsheet / database
that contains 4 columns and about 100 rows.
The for columns will have specific headings and numbers will be entered
under the applicable heading.

Once the numbers have been entered then a button will be selected which will
update the table with the data and provide a total of how many rows were used.

The numbers are reciept numbers and we need to know for example how many of
each column was used.

I hope this makes sense and someone can help me.

All I need to know for now is how to create the columns & rows so whenever a
row is used between 1 to 4 columns that a new row is shown to be able to
enter more numbers.

Thanks
Noemi
 
Hi Noemi

It would not be a good idea to run the form from a table. Create a new
query based on the table and then create a new form based on the query (this
way you can add calculations to you query/form).

tblNoemi to qryNoemi to frmNoemi

You have 3 text boxes but you want 4 columns what will be in the 4th column?.

I think what you "may" be looking for a called a Datasheet form. This will
add a new reord (line) at the bottom of the form each time you add details
the last record. Each of the fields that you have in your query and that you
bring into the datasheet will be shown as a column unless you set the view as
"not visible" and each record will be shown as a row.

There are drawbacks to datasheets such as you can add buttons - although you
could always use continous forms if you really need these. Don'tforget that
if you "show record selectors" you can add functions to the selector and you
can still use the afterupdate, onclick, etc etc, etc to any section of the
form.

I hope this helps but if you need other answers or if I am going down the
wrong route let me know.
 
Sorry but didn't read your full question,

You can put your "count" in an unbound textboxs in the form footer if you
were to use a continous form. You can't use these in a datasheet.

=Count([FieldName])
 
Hi Wayne
I wont be bringing information in from anywhere, I wont to use this form to
add the details into the table.

I tried the datasheet but could not get additional rows so I am not sure
what I have missed.

Any other ideas would be great.

Thanks
Noemi
 
Sorry, my fault. When I say "bring in the information" I simply mean to
enable you to be able to add, delete, work with, etc.

Try this.
Close the table
Go to queries and select New
Open the new query in Design view
Single right click in the top section (the blank section above the grid)
Select Show table from the list and then select your table.
Click Add
Your table will appear in the section above the grid
Click the small * at the top of the table box to bring all the fields into
the query.
Save and close the new query.
Single click the new query (so you don't open it just select it) then click
New Object (it's at the top of the screen).
Select Form then form wizard.
Use the wizard to create you new form.
This should be default enable the facility to add new records (automatically)

You can use the wizard to create your datasheet or continuous form. Don't
forget that if you want to want to show a count below each column you'll need
to select Continuous form (even though it is there) you can't see the footer
on a datasheet.
 
Back
Top