1,130 Posted Topics
 | Re: Can't Edit table Yes, that is one of the things implemented with ADO and the ADODC. You do not need to call the edit method like you need to with DAO or the DATA control as it does not exist. Just remove it, the edit line that causes the error, and everything should …  |
| | You will need to know ADO. Do you know ADO? If not, use your friends (yahoo, google, ask, answers, bing) and search for vb6 ado tutorial. Once you have digested that, see [url]http://www.connectionstrings.com[/url] for the ADO DNS Less connection string you will need to connect to your version of SQL … |
| | By using the first of my friends (yahoo, google, ask, answers, bing) with a search of "vb6 rotate image" I found 2 decent links and one great link over to vbaccelerator... Which by the way uses GDI+ and a search of "vb6 GDI+" will result in a whole lot of … |
| | See the Dir Function in the help files to check for the existence of a file... [code] If Dir(FilePathName) <> "" Then 'file found End If [/code] Good Luck |
 | >I notice on thing that bad: I CANT SLIP TO THE END OF A THREAD IF ITS MORE THAN 1 PAGE LONG!! (I have to click on the thread then click LAST (I could go directly to the end on the older design)) The big button left of the title …  |
| | You should actully convert your help file over to the new HTML file format and that way you will not need to distribute or shell out the package for the old format... Good Luck |
| | Here are some suggestions... :) 'especially these top two [url]http://www.rentacoder.com[/url] [url]http://www.odesk.com[/url] [url]http://www.guru.com/pro/index.aspx[/url] [url]https://www.getafreelancer.com/[/url] [url]http://www.getacoder.com/[/url] [url]http://www.easypocketmoney.com/[/url] [url]http://www.elance.com/[/url] [url]http://www.limeexchange.com/[/url] [url]http://www.scriptlance.com/[/url] How is that for a few thoughts??? |
| | Okay, where does your code startup? Sub Main? Form1? Well wherever it does, you can clean your form load up to something as simple as... [code] Option Explicit Public Sub Form_Load() On Error GoTo Form_LoadError Dim SplashSetting As String SplashSetting = GetSetting("ProjectName", "Startup", "ShowSplash", "T") 'T/F If SplashSetting = "T" … |
| | Ah yes... One of the funny (or not so) undocumented things about VB... Your call to the procedure with the parens wrapped around the variable forces the value to be passed byvalue instead of byref... [code] Convert_NumAbbreviations_to_Numbers (Amount) 'forced byval Convert_NumAbbreviations_to_Numbers Amount 'normal byref [/code] Good Luck |
 | Maybe as a sub forum of Java... |
| | Yes, by issuing the correct commands... Good Luck |
| | IDE = Integrated Design Environment Yes you do know about the recordcount as I showed you this before... debasisdas, presently jemz does not need to loop through the recordset looking for a match as the username/password are provided as part of the query in the where clause... jemz, the pessimistic … |
| | There are several different ways in which to do this... [url]http://lmgtfy.com/?q=vb6+test+internet+connection[/url] Good Luck |
| | First, you should never use End to end your program. You should use unload me... Second, for readability you should use the built in constants (vbKeyUp, vbKeyLeft, vbKeyRight, vbKeyDown)... Third, does your code work as it is??? Use the forms [b]KeyDown event in conjunction with setting the forms keypreview property … |
 | frozie, frozie, frozie.... I know you only have four posts, but if you have been reading these forums, I'm sure by now, you know not to necropost like this!!! Shame, shame, shame on you... Now, there are a couple of ways you can do this under one button... [code] If … |
| | Re: VB 6 and excel There are a few ways in which to do this. You can "automate excel" (hint: keywords for your search with your friends (yahoo, google, ask, answers, bing)), you can use "excel as a database" (also see "vb6 ado tutorial" and [url]http://www.connectionstrings.com[/url] ), or you can use standard CSV files. Good … |
| | Re: copy files Do you need to [b]move[/b] the files, or [b]copy[/b] the files? If you need to [B]move[/B] them and you were to use purplegerbil's code two posts above use the Name Statement... Name OldFileName As NewFileName If you need to [B]copy[/B] them, use the FileCopy Statement FileCopy Source, Destination Good Luck |
| | ...take me to the newest replies since I last visited this thread gone, where oh where can it be... * Prapble, really prapble (purple), oh well, I guess she thinks "it's pretty, all nice and shiney and new..." (ref kayle firefly) BTW: Mr. Wonka called and he wants his umpa … |
| | [yoda voice]over complicate things, you do[/yoda voice] Okay, well maybe not, but using the move method to navigate is your problem...(1+1=2 so move 2 will skip a record...) You should use the movefirst, moveprevious, movenext, and movelast properties and things will be a lot easier for you (but keep the … |
| | Re: HELP with login On which line? ... Run, hit debug, line should be highlighted. Also, include description of error as the error number 3011 is pretty much useless to people unless they know how to look up the error... BTW: For those wanting to know how to look up an error, use the … |
| | Register the dll under the admin account and then right click>properties and give users of the system the rights needed and I think your problems will go away... Good Luck |
| | You might be able to use the "display" property??? "Format" Property??? of the field in question (i.e. table design view or the property of the textbox itself...). Can't quite remember as I don't normally work in VBA... Good Luck |
| | I don't think you can connect 10 to VB6.0. I think it is .NET only... or was that CR11??? Best bet is to check the documentation as examples and instruction should be included in the help files for CR... Good Luck |
| | Yes, both versions contain those... Get the enterprise! |
 | Welcome ReefPicker, I must say well said in several areas but I also must say... AHHH!!! Necrophiliac! It raises the DEAAAAD! AHHHH!!! :) Meaning the thread is over a year old and some people will get the willys with you doing your thing with the dead... :) |
| | |
| | Why two select statements? Where is vbKeyDown? Then, when intellisence comes up for your vbKeyUp, why are you trying to set the left property and not the top property, which if you have read the intellisence is the next arguement... Good Luck |
| | You will need to delve deep into the API... Friends time! (Yahoo, google, ask, answers, ask, bing) vb6 OpenPrinter... Also see your help files for the OpenPrinter API and all of its friends (Printing and Print Spooler Functions) so you can look them up on the web... Good Luck |
| | dajaci, juniorj has the faster and prefered way in which to pull the singular last record from the database as it only requires the program, the network (if on a network), the database, the hard drive(s), to be called only once while your code calls all the above twice and … |
| | Well if you are actually using M$'$ SQL Server of any version since 6.5, you will need to rollback your database and rebuild it from the log table up until the point of where that first record is entered. On how to do this exactly? Look in the help files … |
| | Andre, the line that generates the error is in the form unload event (w.quit)... Okay neosonic, lets take this one at a time... >First, if the user still open the word document (opened by the program), the user is forced to close it when the form unloaded. How can I … |
| | check out the ZOrder Property or you could play around with the Visible Property... Good Luck |
| | Don't save data with file if such an option exists (used to). To make your project load faster, close all the code windows before you exit and when asked, if asked, yes, save the project. Create another program to remove all the temp files if you need to... Good Luck |
| | Have no idea why without seeing code but I can help you out in how to figure it out for yourself. First, make sure Option Explicit is at the top of each code window. 2nd, place proper error handling in each and every sub, which means getting rid of any … |
| | Okay, in your sub Average_Click(), you declare the variables, then set the variables equal to that of a text box but then the sub ends and those variables go out of scope, which means they cannot be used any place else. Also, in the future, when assigning variables that are … |
| | Well you message box says only to input alpha or numeric (0-9, a-z, A-Z) and you are allowing a whole lot more characters than that in your code. And while I don't normally post in threads that I think have the proper answer and should soon be marked as solved … |
| | Did you look at [url]http://www.connectionstrings.com[/url] ? Good Luck  |
| | Shame to have to use a loop because... [code] Private Function IsPalindrome(TheWord As String) As Boolean If TheWord = strRev(TheWord) Then IsPalindrome = True End Function [/code] Good Luck |
| | What you are talking about there Al, may I call you Al, is decompiling a program. Now, if you use your friends (yahoo, google, ask, answers, bing) and search for decompile vb6 programs, you will find a bunch of various programs out there from free to commercial grade that will … |
 | Welcome to the forum Steve... Did you by chance notice the posting date of the OP's original post? 2k6 there Steve... Just a bit of necroposting there Steve...  |
| | As adatapost pointed out, you need to look up the following in help or online... FreeFile Function Open Statement Line Input Function Close Statement Then, use your friends (yahoo, google, ask, answers, bing) and search for vb6 excel tutorial or vb6 automating excel... Edit: Also while searching, vb6 common dialog … |
| | Bob, welcome to the forum and as you seem to be new to forums let me pass along a bit of advice. If you need to reference an older post like this, please don't highjack it or necropost in it as you have. Instead, please create your own thread and … |
 | You are probably just missing the keyword you need to search for leviathan... DateAdd is the keyword you are looking for... Good Luck |
| | Try the record macro feature... Good Luck |
| | Not that this is going to help much but have you checked over at seagate? And, I'm not sure, but I believe clients would now have to have the viewer, and you would have to automate that instead of the old OCX control, but to be sure, you might want … |
| | >My name is Karla, I'm seeking help for my friend who is a programmer. He created a Mp3 player, but he can't get it to browse files and directories in the same browsing window. Okay, Karla, from what I can see from your screenshots, the dialog displayed is called "the … |
| | And while you are sitting down with your fellow classmates, don't forget to bring along the ole Mark I recording device, a pencil and paper so you can document your database design and program flow... Good Luck  |
| | As it is an interview question, one that I have read before in another forum, I wonder if it was the OP that posted it in the other forum because the answers there were pretty good... |
| | You need to create an install package and install the program to your computer... Good Luck  |
| | Okay, you use the word "add" but actually the word would be "subtract" from what you are telling us... Now, please consider this fictitious table... [U]tblInventory[/U] iInvID vInvName vInvDesc iQty and lets say it contains your H1010 in the vInvName field with a description of A Blue Widget, and a … |
The End.