INSERT table issue

  • Thread starter edisonl via AccessMonster.com
  • Start date
E

edisonl via AccessMonster.com

Hi,

I have a Generic form that consist pending costs awaiting for superior
approval.
___________________________________________________________________
Private sub ApprovalButton_On_Click

if MyForm.SubFormName.CostingType = "MachineCosts" then
'Execute SQL INSERT Statement to MachineCosts_Table

elseif MyForm.SubFormName.CostingType = "MaterialCosts" then
'Execute SQL INSERT Statement to MaterialCosts_Table

elseif MyForm.SubFormName.CostingType = "OfficeSupplyCosts" then
'Execute SQL INSERT Statement to OfficeSupplyCosts_Table
End if

End Sub
___________________________________________________________________

Problem : Machine Costs are able to execute SQL but MaterialCosts aint able
to.
Tried: Copies all field in SubformName exactly into all table respectively
(Material, Machine, Office Supply)
Results: OK for Machine, Failed for Material & OfficeSupply

Can anyone provide some guide ? Thanks..

Edison
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a crosstab to temp table 0
export excel data to access table using ADO 0
INSERT INTO Not working correctly 1
run SQL statement issue 2
Insert into table not working 4
Insert statement does not work suddenly ! 5
Multi-Selection Code review 2
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0

Top