Access Save button

  • Thread starter Thread starter t
  • Start date Start date
T

t

Hello, I am losing my mind and need help. I am a beginner.
I have an access table and a form where I can pull the data to show on the
form.
I have two combo boxes and many text boxes and you can use either combo
boxes to pull up the date. I don't have all of the data for the txt boxes and
want to add the missing stuff by clicking on the save button that is on the
form. I have tried everything I can think of and what I found online to
update the data and it is just not working. What I want to do is add new data
to the txt boxes (for existing record) by first pulling up the data in either
combo boxes(which is working ) and by popluating the txt box (NOT working).
I hope that is clear.
 
I am sorry but I can not figure out how docmd.OutputTo will help me save new
data that i have acquired for the fields. in other works , I have 10 fields
and I have data for 6 already. I recently received new data and want to add
it to the table via the form. I have no problems pulling up the data via the
form and typing it on the txt boxes on the form but when I try to save it
using I keep running into problems. I was hoping there would be an easy way
to "update" the records with the new fields. I am not sure how
docmd.OutputTo will help. it looks like it is used for exporting the data
while I am just trying to save it to the table. I hope that clears up what I
am asking for.
 
what is not clear to me is that there is no "save" in a database...

the form is displaying the table...and any entry/change in the form is thus
in the table itself too....

I don't understand what trouble you experience in adding/saving data....
 
t said:
I have an access table and a form where I can pull the data to show on the
form.
OK.

I have two combo boxes and many text boxes and you can use either combo
boxes to pull up the date.
OK.

I don't have all of the data for the txt boxes and
want to add the missing stuff by clicking on the save button that is on
the
form.
Click to expand...

Where exactly do you expect this data to come from?
I have tried everything I can think of and what I found online to
update the data and it is just not working. What I want to do is add new
data
to the txt boxes (for existing record) by first pulling up the data in
either
combo boxes(which is working ) and by popluating the txt box (NOT
working).
I hope that is clear.
Click to expand...

Not really. Are you saying that you want to choose data in a combo box and
for that choice to appear in a text box? You *can* do that, but why bother
when the combo box itself can display the data?

Keith.
www.keithwilby.co.uk
 
My Apologies. I was not very clear. I have a table and a form in my
WeatherStation MDB. The table has 10 fields. In most cases, I was only
able to find partial info for each record so not all fields have data.
I have a form with 2 combo boxes and 8 txt boxes.
This is what I want to be able to do:
1. Pull up each record via the two combo boxes (field 1 and field 2 which
are completely populated for 800 records). This is working for me.
2. Display each field in the 8 txt boxes (which is working).
3. For the records with missing data, I want to pull up the records using
the combo boxes and add the new data in the textboxes and save it. I
created a save button using the wizard and that just will not save the new
data to the table. Now I have goggled and tried many different ways to save
the new data – using the save button that many talented people have posted in
various websites and for some reason I am not successful. Now I realize that
you will have difficulty telling me how I should do this without seeing code
that I am using. My question is this; In general, what is the simplest way
to save (using a button on the form) data to the table (for existing records)
using the text boxes in the form.

I hope this is clear.
 
"what is the simplest way to save (using a button on the form) data to the
table (for existing records) using the text boxes in the form. "

bind the text boxes to your field.
 
Back
Top