Search results

I keep getting a Syntax error on this code and I have looked at it till my eyes wore out! Can anyone help?? Code: Private Sub Transfer_WN_Books_Click() Dim strSQL As String strSQL = "" strSQL = strSQL & " INSERT INTO Books" strSQL = strSQL & " ( Title, Author, field222, field2, Notes, Amazon...

It works!!!! Thank you soooo much. I only do this for myself and obviously I'm not very good. I just started on Access 2010 from 2000. Not even sure what your last message means but now I do. Thanks again.

Try Again.

Ok. I think I uploaded it.

I didn't understand how to do it. Anyway, I got it to go through whit this code; DoCmd.RunSQL "UPDATE WhatsNext " & _ "SET WhatsNext.Mydate = Mydate " & _ "WHERE WhatsNext.AuthorID = AuthorId" BUT the message says "You are about to update 88 rows". Why it says it will update 88...

Oh, I also tried "SET WhatsNext.Mydate =" & " #" & Me.Mydate & "# " & _ and also "SET WhatsNext.Mydate =" " & " #" & Me.Mydate & "# " & _ both produced syntax errors.

That code produces this error: Syntax error in date in query expression '#'. By the way thanks for your help on this. I'm really stuck.

MyDate is a Date field. They all are ReadDate Etc. Maybe different formats.

Hi, Hope someone can help me. I am trying to update a 2nd table 'WhatsNext" after entering a date in a field "ReadDate" (mmm-yy format), in table "Books". There is a slight variation as I must reformat the date for another filed on the form "MyDate". I can see the date go into in "MyDate" upon...

Hi, I'm a disabled old fart who just upgraded to access 2010 from 2000. I am self taught (what little I know!) I am looking forward to getting involved in this forum and I am sure i will need many answers. Thanks in advance!