Re: Sql code in access form in adp

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Probably missing blank spaces.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Roger" <Roger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C14FC0C-A863-4F2C-A275-8B1AB3A7FA4F@xxxxxxxxxxxxxxxx
Whats wrong with this Private Sub Save_Record_Click()
Dim SQL As String

SQL = "INSERT INTO log ([Admin],[Issue])" _
& "select [adm_name],[Problem]" _
& "from forms!frm_tick_entry"

DoCmd.RunSQL SQL
End Sub

Access2003 - sql200 back end

I am trying to create a code which will copy information from a form to a
table.
table = log
Form = frm_tick_entry
I keep getting invalid syntax near !.

Help!!!!!!!
--
Learning is Never ending. So is certification.


.

Relevant Pages

  • Re: Import Access records to excel (parameter is a called funct)
    ... It querys alright but does not roll back ... > Dim SQL As String ...
    (microsoft.public.excel.programming)
  • Re: Form/Subform
    ... Private Sub Fullname_NotInList(NewData As String, ... Dim sql As String ... Dim strNames() As String ... DoCmd.RunSQL sql, False ...
    (comp.databases.ms-access)
  • Re: MD5 Hash with single quote = grief in dao.findfirst
    ... I tried using an ADO recordset to do the check the Hash. ... Function H70CheckADO(strHash As String) As Long ... 'return the IDHashProspSched if the strHash is found in ... Dim sql As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: "Expected: =" error
    ... <MS ACCESS MVP> ... My VBA knowledge is quite limited ... Function Update2ndYrDate(txtcustid As String, dteDue As Date) ... Dim SQL As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: An MD5 Hash with a single quote = grief in SQL query
    ... I tried using an ADO recordset to do the check the Hash. ... Function H70CheckADO(strHash As String) As Long ... 'return the IDHashProspSched if the strHash is found in ... Dim sql As String ...
    (microsoft.public.excel.programming)