Using VB code to run append and update queries (Simple problem) (1 Viewer)

[PTRACER]

Yes please...This is my PartsTotalQuery, by the way:

 

[stopher]

Copy with NZ function attached.

Chris

 

[PTRACER]

Ok, that would work, however when I add the "PartsTotalQuery" to the "TotalJobCharge" query, the two of the repairs disappeared because neither of them had a "RepairID" in the "Parts" table that the query was based on...

If I go back to the "PartsTotalQuery", I find only 'RepairID' 2 and 4 in there, as 1 and 3 didn't consist of any parts. So when I add "PartsTotalQuery" to "TotalJobCharge", RepairIDs 1 and 3 disappear and I can't get any totals from them at all!

This is starting to get more complicated than it should be.

 

[ForexGuides]

I have an Access database that I will be posting to the internet. The
internet interface with the database will be with Data Access Pages. I
would like to run an Append Query named qryPayment2 when the Save button
is clicked on a data access page (I would also like the record to be
saved to it's appropriate table). Access has supplied the VB coding to
save the record when the Save button is clicked, so everything works
there. Could anybody help me with the VB code to run the Append Query
when the Save button is clicked? The string for the Save button is:

<TD class=MsoNavButton style="HEIGHT: 20px; WIDTH: 20px"><IMG
class=MsoNavSave height
id=qryOrderProcessNavSave
src="owc://GIF/#11214" tabIndex=4 width
></TD>