vb5prgrmr

Time to use your friends (yahoo, google, ask, answers, bing) and search for vb ado turorial. Once you have that under your belt, then go over to [url]http://www.connectionstrings.com[/url] to look up the DNS Less connection string format you will need to use to connect to Oracle 9i... Good Luck

Adodc1.RecordSource = "select * from marks where roll = " & troll.text 'will work now.... Also, in the future, do not necropost or highjack a thread as you have done both here. Instead, if you need to, copy the older threads url into your brand spanking new thread as a …

Actually, any intrinsic function to VB will require the runtime, however, the use of the API will not as I presently understand it. But your problems can be solved by simply using the PDW or some other installer... Good Luck

If right clicking on setup.exe and do a runas admin does not work, then your best bet is to upgrade your installer to windows installer 1.1, see the pinned link of snippets at the top of this forum for where to download, or you can use inno. Good Luck

I know the effect you are looking for, and I know how to accomplish part of what you want if I interpret "over" correctly. Meaning, you don't want to draw to the form that is displayed, instead, you want to use transparency on another form and have the text hover …

Think arrays, and think a single control for each letter... Then use your friends (yahoo, google, ask, answers, bing) and search for vb6 hangman to find some actual example programs... Good Luck

Use the common dialog control... (Friends time (yahoo, google, ask, answers, bing) vb6 common dialog tutorial) Good Luck

Switch over to ado or save the 2k2 database in a previous format 2k or 97... Good Luck

Your going to go D'oh here in a moment :) ... An autonumber is a number and not text so when quering against a number you do not wrap it with single ticks (')... Good Luck

Without seeing your code, it is hard to imagine what you are talking about... and perhaps a better explanation of what you are trying to accomplish might be in order... Good Luck

Not quite sure what you are trying to say but I think you want to keep the state of something between instances of your program running and if so then you should check out getsetting and savesetting... Good Luck

Close, very close, but add a boolean variable... (Also, since you are not returning anything from this procedure, it can be a sub instead of a function...) [code] Public Sub readExtFile1(filename As String) Dim TimeToWrite As Boolean [/code] Then, there are a couple of mistakes in your code we need …

manual, time to use your friends (yahoo, google, ask, answers, bing) and search for vb6 volume control, which should bring you this thread example... [url]http://www.thescarms.com/vbasic/volumecd.aspx[/url] Good Luck

Abul, that code does not require a reference...

Walt, no need to understand the header and all, as this can be done with automation... lamakan, all you need to do is to add a reference to word (project>references) and copy the code you referenced. However, you will need to add a few more variables so that you can …

Use the common dialog control... use your friends (yahoo, google, ask, answers, bing) and search for vb6 common dialog control tutorial... Good Luck

Sounds like you are describing a one to many relationship... [U]tblMake[/U] iMakeID vMake 'chevy, ford... [U]tblModel[/U] iModelID iMakeID 'foreign key vModel 'F150, F250, ... So when user selects make, you would then execute... [code] strSQL = "SELECT iMakeID FROM tblMake WHERE vMake = '" & variableholdingthetextoftheselectediteminlist & "'" Set Rs …

Well considering that you are using a binary file to store data in you might need to open the file as binary. Then read the file or part of the file in that you need and then strconv it from vbfromunicode, but it is hard to tell without seeing your …

You want code? GoTo odesk.com or rentacoder.com and put your project up for bid. Don't want to pay? Use your friends who miss you so much! (yahoo, google, ask, answers, bing) Search the world wide web as your answers are out there... The only problem is, is that you have …

What is the error? (err.number and err.description please) Variable not defined??? mypath is not declared as a string as far as we can see so add Dim MyPath As String. Same goes for MyName... Good Luck

Your friends have the answer... (yahoo, google, ask, answer, bing) vb6 ado tutorial... Good Luck

See [url]http://www.connectionstrings.com[/url] Good Luck

In design view, double click on the toolbar so it will open up to its default event in the code window... From there you use the arguements passed to this event to determine which button was clicked... Good Luck

Set autoredraw = true for the pic box. Use the Join function for the output, and change your comments on the split line where you split on the dash as your comment say to split on a space... Good Luck

You/They could use ShellExecute API to launch the default webbrowser or you/they could include the webbrowser control... Good Luck

Access *.mdb? Try compact/repair on exit... Good Luck

Well without seeing the insert into query or the structure of your tables it is kind of hard to tell and we would only be taking shots in the dark... So now, what you are saying is that you know for sure that there are 19 rows not getting inserted... …

You've asked a question that covers a broad area and without further clarification, we would only be taking shots in the dark. So please, describe your system in more detail as in is it a client server database program or is it a client server chat program ... etc... Good …

Time to use your friends (yahoo, google, ask, answers, bing) and search for vb6 ReadProcessMemory or you could use the task manager to see how much your program takes up in memory... Good Luck

Okay, it is helpful if you also include the description of the error that you recieve as most of us do not remember the number but the statement... In this case it is Object variable or with block variable not set... Which means, you have an undeclared variable somewhere or …

Just so you know there is a calendar control in VB already but that did not stop me either... Now, as it seems you are just learning, the question comes on how much you do actually know? Do you know how to create controls at runtime by either loading controls …

gem, you can find all that information with your friends (yahoo, google, ask, answers, bing)... alls you need to do is a little research and read your text book on how to do it.... Good Luck

Code in Form1...(Add Command Button (Command1)) [code] Option Explicit Public MyPublicInteger As Integer Private Sub Form_Load() Load Form2 Form2.Left = Me.Left + Me.Width Form2.Top = Me.Top Form2.Show End Sub Private Sub Command1_Click() MyPublicInteger = 4 End Sub [/code] Code in Form2...(Add Command Button (Command1)) [code] Option Explicit Private Sub Command1_Click() …

Hey Walt, bd asked how not can I... :) bd, see the ado tutorial or use your friends (yahoo, google, ask, answers, bing) to search for vb6 ado tutorial and once you have that under your belt, search for vb6 ado grid... Good Luck

You want hardcore, these guys have hardcore... [url]http://www.thescarms.com/VBasic/timer.aspx[/url] Good Luck

Well what I get out of the OP's gobble de gook is something about bubble sorting arrays in ascending order and having to repeatedly go to the bathroom...

As BrianWren is trying to point out, each file in vb6 has header information that is not displayed and it is this information that vb6 decodes to determine the actual type of file it is. VB6 does not just rely upon the file extension alone, it uses these headers, especailly …

I may not be understanding something here but once you have that point, that center point that is fifty meters away calculated, then do you not need to draw your circle from there? As most circle drawing methods that I know of use the center point to "center" where the …

kinwang2009, it is you that is mistaken as neosonic stated in post #1... >I want to save the whole picture into a bmp file (including the multiline textbox). (I think you are confusing the print screen function, which takes a picture of the desktop or a particular window and allows …

The simplest way is to run a service on the computer with the webcam, i.e. a webserver, expose the camera through it and then connect to it via the ip address or you could use your friends (yahoo, google, ask, answers, bing) and search for vb6 connect webcam, of which …

Actually, reading a file opened for input and using the input function with either LOF or FileLen could raise this error. Instead of opening for input you would want to open as binary. As an example... (adjust if you installed vb somewhere else... [code] Dim FName As String, FNumb As …

Show us what you have as there are so many different ways in which to do this, we would not want to lead you down a different road unless we had to... Good Luck

q2, requests like this can get you banned from almost every forum site I know of as your request is illiciting illegal behavior. Meaning that it is still illegal to download "free" copies of VB6. Now I know as the rest of us do that you don't want to do …

use the DateDiff function (see help for how to use) and test DTP.Value versus Date... Good Luck

To begin with, you cannot format an autonumber within the field itself, which does not mean you cannot format it for display, but it does mean you will need another field to store this formatted number and it will need to be a text field. It also means that you …

This subject has been covered many times over the years and as such, as search with your friends (yahoo, google, ask, answers, bing) should provide you with some results... Now, as for requesting a registration key upon installation you have many different choices on how to do this. There is …

Well, I can give you a hint on task 2... Elect a team lead/integrator. The best programmer between you or the one who says/volunteers that they can integrate each of your codes into one program. From there, each of you treat your part of the program as a whole complete …

Well if you are using a dynamic array, you can always check the UBound for looping and then use redim preserve for reallocating/redimensioning your array to hold more information... Good Luck

It is so easy to create one yourself with a form, why are you looking for someone's elses code? Good Luck

See this faq for more information... [url]http://www.vbforums.com/showthread.php?t=555378[/url] Good Luck