Variables in queries

  • Thread starter Thread starter angelina
  • Start date Start date
A

angelina

Hi,

I wanted to know what symbol i use i my vb.net interface
to show access that my query uses variables. i.e i need
to input two dates that are obtained form my interface
from a dtpicker control. TRhese values need to be used in
my query. How do i do this?

many thx
 
Queries use parameters, but I do not know if they are exposed to .NET or can
be used there. I think the answer is no, but have no proof to back it up
right now.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
If you use a query, you prefix the parameters with @.
Say you use a dataadapter (ada) it looks like this:
ada.SelectCommand.Parameters.Add("@MyParameter",...
 
Back
Top