Hi all,
I am just on my laptop. No SQL Server, No network, the only
data base
I access is ACCESS.I am using ADODC and a SQL in the
RecordSource
property,DataGrid to display the results. Life is good,
however.......
This is some stuff from the NorthWind data base that I have
been
messing around with and it works just fine to change data in
the
DataGrid durring run time.
Private Sub cmdCommand1_Click()
Dim strQuery As String
strQuery = "Select CategoryID From Products"
Adodc1.RecordSource = strQuery
Adodc1.Refresh
End Sub
I know this code(listed below) won't work, but you will see
what I
am after....
I think.
Private Sub cmdCommand1_Click()
Dim strX As String
Dim strQuery As String
strQuery = "Select strX From Products"
Adodc1.RecordSource = strQuery
Adodc1.Refresh
End Sub
Is it possiable to pass to strX CategoryID or
strX="Category" when
a given object is fired (perhaps on a different form) and
kind
of "custom build" the SQL depending upon which
other objects are
fired, prior to executing the Refresh. strX would have to be
global
or modual if it is even possiable.
Thank You, MIKE
'// =======================================================
Rules : http://Reli
ableAnswers.com/List/Rules.asp
Home : http://groups.y
ahoo.com/group/vbHelp/
=======================================================
Post : vbHelp@yahoogroups.com
Join : vbHelp-subscribe@yahoogroups.com
Leave : vbHelp-unsubscribe@yahoogroups.com
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.y
ahoo.com/group/vbhelp/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://grou
ps.yahoo.com/group/vbhelp/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:vbhelp-digest@yahoogroups.com
mailto:vbhelp-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
vbhelp-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.c
om/info/terms/
|