Re: using variables in an SQL query to an Access database

#1

This thread's been removed from my news server (Giganews) but I wonder
if it's exactly what I'm after.

I'm wanting to be able to build a SQL expression from variables
obtained from a dialog box using various controls (combo boxes, text
fields, etc) and then used in a DoCmd.RunSQL statement. I'm not a VB
expert by any stretch of the imagination so I need answers to be in
clear terms.

Thanks VERY much in advance!

#2

You need to do what==Append record, Update record, Delete Record??? Syntax
varies with each action.
"Rob G" <rob1grie (AT) yahoo (DOT) com> wrote

Quote:

This thread's been removed from my news server (Giganews) but I wonder
if it's exactly what I'm after.

I'm wanting to be able to build a SQL expression from variables
obtained from a dialog box using various controls (combo boxes, text
fields, etc) and then used in a DoCmd.RunSQL statement. I'm not a VB
expert by any stretch of the imagination so I need answers to be in
clear terms.

Thanks VERY much in advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: using variables in an SQL query to an Access database

comp.database.ms-access comp.database.ms-access

Re: using variables in an SQL query to an Access database - 08-07-2003 , 11:45 AM

Re: using variables in an SQL query to an Access database - 08-07-2003 , 05:34 PM