Referencing a view for Recordsource

  • Thread starter Thread starter el zorro
  • Start date Start date
E

el zorro

I have an adp/SQL setup. I have a List Box on a Form. When I type a name in a
Text Box (Text4) , I click a control button that sets the List Box record
source to a modified version of a view (ListView) that joins two tables. It's
modified because I only want it to show records that match text in the Text4.

THe only way I have been able to get this to work is to write out the SQL
statement for ListView in the VB code for the control button click event
(then add a reference to Text4). Like, "SELECT These Fields from This table
LEFT OUTER JOIN That table etc...." Isnt there just a way to say "SELECT
These Fields from ListVIew... " ?

I couldn't get that to work.
 
If you're asking if you can use parameters with a view, the answer is no.
Parameters can only be used with stored procedure. If this is not what
you're asking, then I'm sorry but I don't really understand your question.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Can anyone help me? I got a windows-vista w/ my laptop. tbut home system is
outlook express! called At &T they gave me a server that is not at all
compatable1 Therefore I have yet to get an e-mal, and there are a bunch of
web-sites that ask for that. needs to be a connecting program anyone have
one????
Now roblem #2!!!! the next field that comes up is "username",, and
"PASSWORD". these 2 never get trough the field to my e-mail.
Can you all help me pls???? going out of my mind, and Acer does it's best
to run you in circles!!!!
Marti
 
Maybe I should learn more about the difference between a stored procedure and
a view. I've been doing most of my work using views because I came into this
via MS Access, and views seemed to be the closest thing to the queries I had
been working with. Stored procedures and views *appear* to do about the same
thing, but maybe stored procedures allow more flexibility with parameters.
Maybe they are my answer here. Can you give me some insight on this, or
direct me to a good reference on the topic of SPs vs. Views?
 
Back
Top