how to show text

[PROXI]

I am VERY new to sqls and I need to make some text appear in my string, and I don't know how to do it. This is what I have right now.

DoCmd.RunSQL "INSERT into History (user, login, Action) VALUES ('" & Access.CurrentUser & "', #" & Now() & "#, " &[bold] "Deleted Record #" & Me.borrower[/b] ') "

I want the bold statement to appear in the Action column of a table that I have, but it just doesn't want to work.

And also, Is there a way that I can make this statement work in a macro. It errors at the " #" & Now() & "#, " Part.

Thanks in advance

PROXI

Thanks,

Shadd Parker

 

[hindsjl]

Shadd -

If I understand your problem correctly -- that you want an Access macro to insert a row into a SS table -- then your solution is entirely an Access one, requiring Access operators, formulas, syntax, etc.

From Access menus, use File, Get External Data, Link Tables, and establish a "link" to the SS table. It will then be available in your Access database pretty much like any native Access table, and you can run your Insert statement there. For more help constructing your Access query, try forum 23951.

John

 

[hindsjl]

Whoops.

No, 23951 is how many members they have. It's forum 701.

John

 

[SQLBill]

If you are using Access, you should be posting in an Access related forum like John suggested. This forum is NOT for SQL, it's for Microsoft SQL Server.

-SQLBill

 

[PROXI]

my apologies. Read the forum title wrong

Thanks,

Shadd Parker