473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Capturing Text in Textpad

Apologies for this query for i think it is pretty straightforward.

(VB 6.0)
Through a SQL query i have got a string which needs to be put in a textpad.(form code). Till now i am able to put data in dropdown(list down) boxes but not in textoad. The error its giving is invalid procedure call.

A few code snippets i shall give to make the picture clearer.

sQueryGetReviewer = "Select #### from #### where user_id = '" + UserName + "'" ' Get details

--after logging in the Database

rSetReviewer.Open sQueryGetReviewer, strCon, adOpenForwardOnly, adLockOptimistic

Text2.Text = rSetReviewer.GetString (Text2 is the name of the textfield)

I have also tried rSetReviewer.Fields(0) among others.

Also when i tried GetString/Getrows im getting this error..
Either BOF or EOF is true , or the current record has been deleted.Requested operation requires current record.




Also regarding the populating doprdown list. I am able to get all the values in the list. But is there a way to have a default value shown when the form appears. Right now the field is empy and only when its dropped down then i am able to see the values.
Again this is not high priority in comparison with my earlier query.

Thanks a lot!
Aug 6 '07 #1
4 1751
Killer42
8,435 Expert 8TB
The BOF/EOF thing sounds to me as though you just didn't find any records.
Aug 6 '07 #2
Well, executing the query gives me 1 record.
Im putting a messge box after the query -MsgBox (sQueryGetReviewer) and i get a valid record.

I think there is another way to populate the textfield.
Aug 6 '07 #3
Its done/
Expand|Select|Wrap|Line Numbers
  1. While Not rs####.EOF
  2.   Text2.Text = (rS####.Fields(0))
  3.   rS###.MoveNext
  4. Wend
Thanks.
Aug 6 '07 #4
Killer42
8,435 Expert 8TB
Glad to hear it worked out.

(I think you gave us a bum steer with that "MsgBox (sQueryGetReviewer)", since sQueryGetReviewer was just a string.)
Aug 6 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Will Pittenger | last post by:
If I were writing a C++ program, I would write a mouse hook. Does C# and ..NET 1.1 have anything equivalent. If not, I suppose I will need to use the Win32 API. ---------- Will Pittenger...
14
by: Brent Burkart | last post by:
I am trying to capture the Windows Authenticated username, but I want to be able to capture the login name that exists in IIS, not Windows. In order to enter my company's intranet through the...
4
by: Krishna Kumar | last post by:
Hai all, I am doing a project in .net and in that project I have a problem in capturing text from an image. i.e images like CAPTCHA images . which has inbuilt text with in the image.So,...
3
by: GreggTB | last post by:
I've looked online for a while but haven't found a whole lot of really good resources for this, so I'm hoping that maybe someone here can point me in the right direction. I'm working with a 3rd...
9
by: Dave White | last post by:
Hello everyone, I am considering changing text editors. Which open source text editor would you recommend for xhtml & css? Thanks in advance, Dave White
2
by: GS | last post by:
How can one avoid capturing leading empty or blank lines? the data I deal with look like this "will be paid on the dates you specified. xyz supplier amount: $100.52 when: September 07,...
4
hsriat
by: hsriat | last post by:
I had been using TextPad (http://www.textpad.com ) to edit HTML, PHP and JS files. Few days ago, it started giving some message while editing 'The file has been changed by some external editor, do...
7
by: tshad | last post by:
I have a program in 2005 that is reading a text file removing text and then writing it back out again. It removes lines that start with PRINT. This program has worked fine for months. Now all...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.