Hi all, I'm by no means an expert in access but I'm trying to expand my knowledge by creating a call logging database. an exchange inbox is linked into the database. This will be where the support calls come from, i have setup a form with a button, the idea being to review the mails in the inbox and then to add them to a waiting list. I decided to it like this as sometimes there are unwanted mails in the inbox. So the idea being when you go through the most recent records you can click a button which will copy the record into another table which will open a "ticket".
Simple enough i know but stuck on the pull the record code for the button. I have tried an append query but to be honest, although i have used query builder in the past, it has only been for reporting so my funtion knowledge of querey append is not too bright so i decided to use code builder for the event and use an sql statement as follows:
unfortunatly im getting an error when running it: Run-time error '3075' Syntax error (missing operator) in query expression...
Could someone possibly shed some light on this? any help or pointers greatly appreciated
many thanks
luke
Simple enough i know but stuck on the pull the record code for the button. I have tried an append query but to be honest, although i have used query builder in the past, it has only been for reporting so my funtion knowledge of querey append is not too bright so i decided to use code builder for the event and use an sql statement as follows:
Code:
strSQL = "INSERT INTO Tickets " _
& "([Importance], [Priority], [Message Size], [Has Attachments], [Received], [To], [From], [Sender Name], [Subject], [body]) " _
& "VALUES ('" & Me.Importance & "'" _
& ", " & Me.Priority & "'" _
& ", " & Me.Message_Size & "'" _
& ", " & Me.Has_Attachments & "'" _
& ", " & Me.Received & "'" _
& ", " & Me.To & "'" _
& ", " & Me.From & "'" _
& ", " & Me.Sender_Name & "'" _
& ", " & Me.Subject & "'" _
& ", " & Me.Body & "'" _
& ")"
DoCmd.RunSQL strSQL
unfortunatly im getting an error when running it: Run-time error '3075' Syntax error (missing operator) in query expression...
Could someone possibly shed some light on this? any help or pointers greatly appreciated
many thanks
luke