appending tables with a form

[macri]

Hello and good morning/afternoon!

I am currently in the process of redoing a production database that was originally setup in excel workbooks. What I'm currently developing is a form that interacts with my append query to add new entries which would be added to the current or "master" table for production records. However when i go to select a control source i can't seem to select my append query which i've neatly named "update". as of right now i have a handful of unbound text boxes on my form for input and a single "update" button which would trigger an onclick to add the input from each text box into the specified field. This may have been covered in another thread and for that I am sorry I did try searching with no avail.

thanks so much for you time

 

[spikepl]

You may try using a less "neat" name than Update for your query: http://allenbrowne.com/AppIssueBadWord.html

Further, a control's Control source cannot be set to any query. A SELECT query can be used as Record source, but not an Update/Append query.

 

[macri]

Thanks for the tip, fairly new to access if you can't already tell. How exactly would you go about setting this up to add data? If it were up to me I'd set it up in MySql and just code an html form to update data unfortunately they like microsoft here. basically all they're doing is adding specs like total lbs produced product code what resin they were running just basic values nothing too fancy i can do the arguments and i have no problems with reports i just find the data entry aspect of ms access a bit confusing.

 

[spikepl]

Why not grab some small working db and see how it ticks? Free templates here:
http://office.microsoft.com/en-us/templates/CT010152732.aspx?av=ZAC

and here a bit (or byte?) of training here http://office.microsoft.com/en-us/training/CR010158283.aspx

 

[spikepl]

Also , using an an unbound form and then appending contents of controls using a query is a very roundabout way to something which can be accomplished by doing nothing: simply binding the form to a record source (table or query), so any changes/additions in the form propagate directly to the underlying table(s).

 

[macri]

Ok i didn't realize that you could append a table when text boxes were bound to a field i thought this was only useful for searching/sorting data. when i originally learned access in 2000 i remember their being a cycle option of sorts so that when you tab out of your last input box it would refresh the form to a blank page for the next entry (i believe it also added the data to the table all in one go) is this now being controlled with the "on exit" event?

 

[spikepl]

Play with one of the templates. And forget the HTML-thinking, where you at each roundtrip reestablish the web page, and shove any changes into a db on submit- all this is unnecessary when running an app like access.

 

[macri]

wow you weren't joking at all lol i literally did nothing but drag and dropped the fields from add existing fields. i may have just been over thinking this entire operation lol. sorry for the noobness lol i'll try and be less of a html guy from now on hahaha and here i thought web dev experience would come in handy on this contract lel thanks again