By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,534 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,534 IT Pros & Developers. It's quick & easy.

I need help in Calling specific cell in sql database

P: 11
Hi everyone im new at vb and i already need help.
Is it possible to get a specif cell in a column that i have created using sql database.
For example:
I made a table that have a 3 columns Quantity, Price and Amount
using detail and dragging it to the form so i have 3 textboxes showing them all
but i made another textbox and i want that textbox to show a specific cell in a column.
pls tell me the syntax for this ty
Jan 30 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 5K+
P: 8,434
Hi everyone im new at vb and i already need help.
Is it possible to get a specif cell in a column that i have created using sql database.
For example:
I made a table that have a 3 columns Quantity, Price and Amount
using detail and dragging it to the form so i have 3 textboxes showing them all
but i made another textbox and i want that textbox to show a specific cell in a column.
I'm finding the mixed references to tables, databases, columns and cells very confusing. Can you please clarify what kind of setup you're talking about? Is this a standalone VB program? If so, is it dealing with a database, a spreadsheet? Both?

Or is it written in VBA, inside Access, or Excel? Or what?
Jan 30 '07 #2

Dököll
Expert 100+
P: 2,364
If you running a query through VB to access any type of database, you will need to query using both the search textbox (example Text1.Text, provided user id information will be loaded here when returned) on your VB front-end and the specified field (example UserID), provided it is the field related to Text1.Text, in your database back-end being searched:

Text1.Text (VB) = UserID (Database)
Text2.Text (VB) = Fname (Database)

Just to give you an idea...

As mentioned here by Killer, you will need to tell us excatly the type of database being used as back-end, and post some of your code here, at least the query portion, to get an idea what you hope to achieve. Please write again, if you understand this and the previous reply.

In a bit!

Dököll
Feb 3 '07 #3

Post your reply

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