D
DavidPuddyFan
Creating a database where I have two tables, a master table and a coun
table. Data Entry form based on master table. I have created an appen
and update query so after user puts in data for a part#, they clic
submit record...at this point the append query appends any records whe
cnt is greater then zero, then updates the master database back t
original state. If I run the queries manually, the process works great
but when I use the following, it doesn't work at all....
Private Sub Command19_Click()
On Error GoTo Err_Command19_Click
DoCmd.SetWarnings False
Dim stDocName As String
Dim stDocName1 As String
stDocName = "qAppendtoINVCNT"
stDocName1 = "updateMasterfile"
DoCmd.OpenQuery stDocName
DoCmd.OpenQuery stDocName1
Exit_Command19_Click:
Exit Sub
Err_Command19_Click:
MsgBox Err.Description
Resume Exit_Command19_Click
End Sub
Any Thoughts on how I can get this to work...what I am basically tryin
to accomplish is to only pull data from the master table that has bee
counted, then revert the master table back to original status...thank
in advance
table. Data Entry form based on master table. I have created an appen
and update query so after user puts in data for a part#, they clic
submit record...at this point the append query appends any records whe
cnt is greater then zero, then updates the master database back t
original state. If I run the queries manually, the process works great
but when I use the following, it doesn't work at all....
Private Sub Command19_Click()
On Error GoTo Err_Command19_Click
DoCmd.SetWarnings False
Dim stDocName As String
Dim stDocName1 As String
stDocName = "qAppendtoINVCNT"
stDocName1 = "updateMasterfile"
DoCmd.OpenQuery stDocName
DoCmd.OpenQuery stDocName1
Exit_Command19_Click:
Exit Sub
Err_Command19_Click:
MsgBox Err.Description
Resume Exit_Command19_Click
End Sub
Any Thoughts on how I can get this to work...what I am basically tryin
to accomplish is to only pull data from the master table that has bee
counted, then revert the master table back to original status...thank
in advance