|
While I realize that there is a SQL section, I thought I would try here first. I am looking for a snippet if possible that would show me how to do a query on an access database like such.
select track, oe
from database
where track=txttrack.text
I need the select to be tied to the text that a user enters, then show the OE. TIA
|
|
|
|
|
I think this is what you mean but maybe not and i haven't checked it.
Private Sub Text1_Change()
Dim oConn
Dim oRS
Set oConn = CreateObject("ADODB.Connection")
Set oRS = CreateObject("ADODB.Recordset")
oConn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Password=;Data Source=D:\MyDatabase.mdb;Persist Security Info=True")
Set oRS = oConn.Execute("select track, oe From Database Where track = '" & txttrack.Text & "'")
MsgBox oRS("track").Value
MsgBox oRS("oe").Value
oRS.Close
oConn.Close
Set oConn = nothing
Set oRS = nothing
End Sub
hope it helps
"If i was king cigarettes would be free."
|
|
|
|
|
at work, but will give it a try. Looks like it will work though. Thanks
|
|
|
|
|
too vague question...
please precise more
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
|
hi,
I have displayed some data in Data Grid control through my code. Now i want to clear all the data displayed in datagrid, by pressing a button.
How can i do this.
plz help.
EsHbAn BaHaDuR
|
|
|
|
|
|
Hi,
Actually i want to build a Gantt Chart Control in my web based application. kindly help me out from this.....
it will work like MS project Gantt Chart...that when the task is created....the gantt chart will be created simultaneoulsy.
i will be thankful to u
best regards
|
|
|
|
|
That is a lot of work and probably much more than can be answered in a forum response.
You have to work out what you require it to do, what functionality do you want it to have. Then you have to design it - break the problem down in to smaller and smaller steps. If you have a problem with one of the smaller steps then it is probably of a size where you can get a useful answer in a forum.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
is there any code of blocking usb port in vb6
|
|
|
|
|
Define "block"...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
yaar you always say only 1 thing.. there's a comlete method for it .. if u wanna help then give complete help.. or else back out from this
|
|
|
|
|
Well, considering I only wanted to know "1 thing", and everything about an answer depended on that "1 thing", I only said one thing. But, as for your implication that that's all I do, you haven't really been keeping track... And if you have, I'd like to know who my stalker is instead of hiding behind an "Anonymous" post!
Anonymous wrote:
there's a comlete method for it .. if u wanna help then give complete help.. or else back out from this
Back out from what? Funny, I don't see you posting anything constructive, or even inquisitive, about the OP's post. On the other hand, if you are the OP and don't like the simple question I asked, KMA and point your browser over to Google! I didn't ask anything unreasonable...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
CallByName function make my application to be rick,how i can anti this function.
Plase tell the way,thank you for your help.
|
|
|
|
|
You can use an obfuscator to scramble your code to make it more difficult to do this, but you can't prevent it from being used at all.
Why would you want to di this anyway?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi there,wonderful guys.
i think i have to commend everyone in this judicious group for doing a nice and pleasing job.
hello,is there any body in this group who could assist me to use c++ and vb in writing program on clock which will be functioning exactly the way clock work.
pls i need respond to this question on time for the completion of a project i have at hand now,
you can as well email me for my better understanding.
thanks.
|
|
|
|
|
How to implement the following function:
If click the close button of a window, there will be a messagebox with two selections "YES" and "NO". If "YES" is selected, the window is closed as usual. If "NO" is selected, the application will return to the preivous window.
Thanks.
|
|
|
|
|
find the forms OnClosing event, and show a message box from there, if they press yes, just continue and if they press No, you can set e.cancel = True which will stop the form closing.
hope this helps
- Andy
http://www.guardian.co.nr
|
|
|
|
|
Andy, I got it. Thank you so much!
|
|
|
|
|
Glad to be of help 
http://www.guardian.co.nr
|
|
|
|
|
Hello,
I just installed Microsoft .NET Framework SDK v1.1.
(http://www.microsoft.com/downloads/details.aspx?FamilyId=9B3A2CA6-3647-4070-9F41-A333C6B9181D&displaylang=en)
I need to compile to a DLL a VB file which has a class with some functions.
I know that if I have Visual Studio 2003 installed I would do:
vbc /t:library /out:myFile.dll myFile.vb
Is vbc in Frameword DSK? I can't find it.
Thanks,
Miguel
|
|
|
|
|
Hi guys. I am making a software which also contains a screenshot grabber. I want to draw rubber band selection area box for it. That means I have to draw on screen. I have been able to draw boxes on screen anywhere but they do not get cleaned up when the mouse moves and a new box has to be drawn for that new location. Could somebody please help me out in this. Please remember not for drawing on the form; For drawing on the screen anywhere.
|
|
|
|
|
This[^] article shows how to get the desktop window using interop functions. If you're able to use interop functions, you should be able to use GDI functions as well. In GDI, you can draw using SRCINVERT, which means that your rubber band is created by inverting pixels in the box. Thus, you can undo this operation by doing it again before you change your co-ordinates, and no data is lost. Or you can just call Invalidate() on the desktop window so it refreshes itself before you draw your rubber band ( this could cause flicker )
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanx Mr. Graus,
Thanks for the help but I'm sorry I didn't specify that I am working in Visual Basic 6. I know how to get the desktop window's DC and methods to draw on it but during dragging the desktop DC doesn't refresh and doesn't clear the box last drawn.
|
|
|
|
|
I don't get why people still use VB6.....
In that case, this[^] is an article on rubber banding in C++, using different ROP codes. Basically, you select a code that is not destructive, then you draw your rectangle, and you draw it again to restore the old values before drawing a new rectangle elsewhere.
Or you could do the other thing I suggested, which is to Invalidate the desktop window, and force it to redraw.
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
