docmd.RunSQL String Concatenation 
Author Message
 docmd.RunSQL String Concatenation

Hi,

I am trying to automate an update query where it gets
input from a form and does the update based on the
criteria specified.

I cannot concatenate strings or use variables in the sql
statement with the docmd.Runsql command.

Any suggestions as to how I can acvhieve this?

Thank you.

Olgun



Sun, 28 Aug 2005 22:29:01 GMT  
 docmd.RunSQL String Concatenation
I was able to get this to work.

Thanks.

Quote:
>-----Original Message-----
>Hi,

>I am trying to automate an update query where it gets
>input from a form and does the update based on the
>criteria specified.

>I cannot concatenate strings or use variables in the sql
>statement with the docmd.Runsql command.

>Any suggestions as to how I can acvhieve this?

>Thank you.

>Olgun
>.



Sun, 28 Aug 2005 23:02:27 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. DoCmd.RunSQL

2. DoCmd.RunSQL Error

3. DoCmd.RunSQL error 2

4. docmd.RunSql problem

5. DoCmd.RunSQL too long record

6. DoCmd.RunSQL

7. suppress warnings on DoCmd.RunSQL ?

8. docmd.runsql repeat problem

9. docmd.runsql help required

10. DoCmd.RunSQL vs. Recordsets

11. docmd.runSQL fails on Windows 2000

12. Quick syntax question on - DoCmd.RunSQL

 

 
Powered by phpBB® Forum Software