Originally Posted by
shylock
Micron:
Here is the "New" SQL:
SqlQry = "INSERT INTO DowntimeEventNew " _
& "([Begin Date], [Begin Time], [End Date], [End Time], [Description], Planned, ReportedBy, EnteredBy, ServerName, UsePhysicalServer, Services)" _
& " VALUES (#" & CDate([txtBeginDate]) & "#, #" & CDate([txtBeginTime]) & "#, #" & CDate([txtEndDate]) & "#, #" & CDate([txtEndTime]) & "#, " & [txtDescription] & ", " & [cboPlanned] & ", " & [txtReportedBy] & ", " & [txtEnteredBy] & ", " & [cboServerNm] & ", " & [cboUsePhysicalServer] & ", " & [txtServices] & ");"
CurrentDb.Execute SqlQry, dbFailOnError
As you can see there are, in fact 11 fields, not 5.
When I run the query and look at the contents of SqlQry in the immediate window this is what I see:
INSERT INTO DowntimeEventNew ([Begin Date], [Begin Time], [End Date], [End Time], [Description], Planned, ReportedBy, EnteredBy, ServerName, UsePhysicalServer, Services) VALUES (#11/28/2018#, #12:00:00 PM#, #11/28/2018#, #12:30:00 PM#, test, True, JRW, Jack, Angular, False, AngularJS);
I'm not understanding what you men by "your text values need to be delimited as are your dates: 'test', True, 'JRW', 'Jack', 'Angular', False, 'AngularJS'"