?
Solved

How do I pass a Value from a form txtBox to a SQL ADODC RecordSource statement on the same form.

Posted on 2003-10-24
10
Medium Priority
?
197 Views
Last Modified: 2010-05-03
I am somewhat new to VB6.  Here is my quandary.  I have a form with a DataGrid on it, I have a field with a PASSED value from another form, that is PASSED on form load.

I need to have the SQL statement in the ADODC, RecordSource select the record from the database based on the value from the form field (that was passed).

select Est_No,Est_Notes,Est_Opening_Date,Est_Opening_Location,Est_Opening_Time,Est_Value from tblEstInfo Where Est_No = [this is where I need it to select the record based on the PASSED value in the txtEstNo text box]

Any help would be greatly appreciated????

Thanks in ADVANCE

Charlie
0
Comment
Question by:CMHamrick
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 28

Accepted Solution

by:
vinnyd79 earned 2000 total points
ID: 9617227
select Est_No,Est_Notes,Est_Opening_Date,Est_Opening_Location,Est_Opening_Time,Est_Value from tblEstInfo Where Est_No ='" & txtEstNo.Text & "'"
0
 

Author Comment

by:CMHamrick
ID: 9617268
Syntax error on above???
0
 
LVL 28

Expert Comment

by:vinnyd79
ID: 9617332
How about:

...... Where Est_No =" & Chr$(34) & txtEstNo.Text & Chr$(34)
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:CMHamrick
ID: 9617394
Does not work :(

The SQL statement goes in the DataGrid/ADODC/RecordSource/CommandText box...
0
 
LVL 28

Expert Comment

by:vinnyd79
ID: 9617434
Whats the value in the txtEstNo Textbox?
0
 

Author Comment

by:CMHamrick
ID: 9617437
03-01  or 03-02  or 03-03, etc.
0
 

Author Comment

by:CMHamrick
ID: 9617444
Try my AIM for instant response....   cmhamrick
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 9617636
did you fully qualify text box name?
I mean frmWhatEver.txtEstNo.text

or are you trying to put that sentence in the property of datagrid?
If last one, you cannot do it that way, at least not at design-time but at run-time
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9617760
>>Syntax error on above???
Does not work :(<<
Does not help anyone identify the problem.  In the first case, what was the error, in the second case was there 1. An error occured, if so which?
2. Not the right results.
3. Smoke coming out of the monitor

>>Try my AIM for instant response....   cmhamrick <<
This is not encouraged here at EE.  We are all here to share ideas.

Having said that, can you post you existing code and what you are trying to achieve.

Anthony
0
 
LVL 1

Expert Comment

by:MN_Dave
ID: 9618250
When I have a problem like this I will put the sql statement into a string variable so that I can see that is looks the way I think it will...

Dim sqlStr as string

sqlstr = "select Est_No,Est_Notes,Est_Opening_Date,Est_Opening_Location,Est_Opening_Time,Est_Value from tblEstInfo Where Est_No ='" & txtEstNo.Text & "'"

After this statement I will look at the value of sqlstr, which should be something like:
select Est_No,Est_Notes,Est_Opening_Date,Est_Opening_Location,Est_Opening_Time,Est_Value from tblEstInfo Where Est_No ='03-01'

I have found this to be helpful in identifying minor syntax errors.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month13 days, 7 hours left to enroll

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question