Yeah still the same issue. Screw it. I'll take a 0 on this assignment. I don't care. Still going to get an A in the class.
On Sun, Jun 29, 2014 at 1:18 PM, Maureen <[email protected]> wrote: > > Would probably help if I had the syntax right: > > Dim SQL As String > > SQL = "INSERT INTO Borrowed (CustID, CDDVDID, DateOut, DueDate) > VALUES(" & Me.Combo0 & "," & Me.Combo2 & ", #" & Me.Text6 & "# ", #" & > Me.Text8 & "#);" > > DoCmd.RunSQL SQL > > On Sun, Jun 29, 2014 at 10:37 AM, Bruce Sorge <[email protected]> wrote: > > > > I'll give that a try Judith. > > > > Sent from my iPhone 5S > > > >> On Jun 28, 2014, at 10:42 PM, Maureen <[email protected]> wrote: > >> > >> > >> Try setting the SQL statement to a variable, then execute the > DoCmd.RunSQL. > >> > >> Dim SQL As String > >> > >> SQL = INSERT INTO Borrowed (CustID, CDDVDID, DateOut, DueDate) > >> VALUES(" & Me.Combo0 & "," & Me.Combo2 & ", #" & Me.Text6 & "# ", #" & > >> Me.Text8 & "#);" > >> > >> DoCmd.RunSQL SQL > >> > >> > >> > >> > >>> On Sat, Jun 28, 2014 at 2:26 PM, Bruce Sorge <[email protected]> wrote: > >>> > >>> Hey there community, > >>> I have a class project that is pissing me off. I have this bit of VBA > code: > >>> > >>> DoCmd.RunSQL "INSERT INTO Borrowed (CustID, CDDVDID, DateOut, DueDate) > >>> VALUES(" & Me.Combo0 & "," & Me.Combo2 & ", #" & Me.Text6 & "# ", #" & > >>> Me.Text8 & "#);" > >>> > >>> It does not work. I get a syntax error and the entire line is > highlighted > >>> in red. I am sure it has something to do with my date fields (combo0 > and > >>> combo2, and yes, I know that you should give meaningful names to your > >>> controls, but right now that's the least of my issues). > >>> > >>> Any VBA experts out there that can show my what will probably become a > >>> painfully obvious omission of some double quotes or something? > >>> > >>> Also, I'd like to point out that when I remove the pound signs, the > current > >>> time is entered and not the date. The control is MS Access's > datepicker. > >>> > >>> Bruce > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:371126 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
