October 19th, 2009, 10:30 AM
|
|
Registered User
|
|
Join Date: Oct 2009
Posts: 2
Time spent in forums: 52 m 47 sec
Reputation Power: 0
|
|
|
HELP! i'm out of my depth... and sinking fast!
Hi All,
I recently decided to start playing with access, a friend at work was pretty good at programming so offered to help me out. unfortunatly before finishing my 1st (and foolishly quite large) project he decided to fly off to thailand with his girlfriend!
now my problem is i have built a tool for my work to track the current status of projects, i've got the form to pull the data from the database OnLoad, but when i click my update button i get a debug error.
(i hope i've use the right tags to wrap my code!)
Heres my Update command
Code:
UpdateProjectSQL = " UPDATE [projects] SET [UATID] = '" & uatproject & "', [PACode] = '" & PACode & "', [OnTrack] = '" & ontrack & "', [OneView] = '" & oneview & "', [Status] = '" & proj_status & _
"', [Rag] = '" & project_rag & "', [PM] = '" & projectmanger & "', [TPM] = '" & tech_proj_manager & "', [TM] = '" & test_mamanger & "', [UATTester] = '" & assign_res & "', [SuppRes] = '" & _
add_uat & "', [LaunchDate] = '" & launch & "', [ScriptTarget] = '" & script_date & "', [UATStart] = '" & uat_start & ", [UATDuration] = '" & uat_dur & _
"', [UATPercent] = '" & uat_complete & "', [PITStart] = '" & pit_start & "', [PITDuration] = '" & pit_dur & "', [PITPercent] = '" & pit_complete & "', [TestPlanApprove] = '" & _
tp_complete & "', [TestPlanApprove] = '" & test_plan_approve & "', [ScriptsComplete] = '" & scripts_complete & "', [ScriptsApprove] = '" & sign_off & "', [UATStartCh] = '" & uat_st_ch & _
"', [UATComplete] = '" & uat_complete_ch & "', [PITStartCh] = '" & pit_st_ch & "', [PITComplete] = '" & pit_comp_ch & "', [ExitReport] = '" & exit_report & "', [UATSignoff] = '" & _
uat_signoff & "', [TypeofTest] = '" & type_of_test & "', [AreaofBusiness] = '" & area_of_bus & "', [NewUpdate] = '" & new_update & "', [OldUpdate] = '" & prev_update & "'"
I've put a MsgBox after this SQL statement and from what i can see everything is being pickec up and a value is being pulled from every field in the query.
but i'm getting debug error
Code:
Run-Timer error'-2147217900 (80040e14)
Syntax error (missing operator) in query expression "is Null , [UATDuration]= 'is Null', [PITPercent]=' =100%',
[TestPlanComplete]= '= -1', [TestPlanApprove]= '= -1',
[ScriptsComplete]= 'isNull', [ScriptsApprove]',
Any advice or help would be much appriciated.
Thanks
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
