rcsmith0712
Last Activity: Jun 14 '21, 06:14 PM
Joined: Jun 8 '20
Location:
-
MS Access to SQL server connection string
Hi Folks. I have an access application that is using SQL server 2019 for the backend. All of my "queries" work but when the Update and insert statements execute Access will display the append or Update warning but nothing is actually being written or changed in the SQL tables. I believe I need to establish a SQLOLEDB connection string in my access project but I am having trouble. I get a message the states "Object Required"....Last edited by NeoPa; Jun 14 '21, 07:40 PM. -
Thanks ADezii. That worked! Though I'm not sure why the brackets are needed in this case. Can you help me understand why? -
Syntax error on insert statement
Hi Folks. I have a simple insert statement only four fields. The last field "Table" is the problem child. IF I take it out and the associated value "Me.txtTemp Tab" the insert statement works. Image of code also attached. Any assistance would be greatly appreciated. Thank you in advance...
...Code:DoCmd.RunSQL "INSERT INTO tblScrBldSched " & _ "( OrderNo, Tech, SchedDate, Table )" & _
-
Twinnyfo, Thank you so much. Your suggestion was spot on.Leave a comment:
-
Dcount statement returns Type Mismatch error
no matter what syntax I try I continue to get a Type Mismatch error on my Dcount statement. can anyone please help? Here is my statement:
...Code:Me.txtBHA = _ DCount("[BHud]", _ "Consumers", _ "[CallDate] Between #" & _ Me.txtStartDate & _ "# And #" & Me.txtEndDate & _
No activity results to display
Leave a comment: