1,130 Posted Topics
 | Good info Andre but the OP is asking about ODBC DSN's, and I agree with you, using ADO's DSN Less connection strings would be the best bet in a situation like this but what you did not tell the OP about is exactly what they would have to do to …  |
 | Looks like you have it... Only need to add single ticks around strings and since both of your fields are numeric, I think you have it... Good Luck |
| | This question has been asked before in many a forum and if you use your friends (yahoo, google, ask, answers, bing) to search for vb6 ideas, or vb6 project ideas, you should find a few results with lots of answers. In fact, if you search this forum you will see/find … |
 | Okay WaltP. The reason you are not retrieving any possible error that has been raised is because of your code and error handling. Please see comments I made to your code below... [code] 'good, a well defined error handler label definition On Error GoTo mkError 'side note: any text box … |
| | Start a new project or open an old one. Open the API viewer. Select an api you want to find out about. Switch back to VB. Press F1. On index tab of the MSDN help file, type in the API name. Read all about it... |
| | How can we help you if you don't show us the code that is giving you a problem? |
| | Most "OnLine" systems usually invlove asp, php, and so on... However, there are systems that do involve fat clients and over the internet communications. Examples are, chat, voice chat, video chat, games, and various database applications. So the question is, where do you want to go and what do you … |
| | In VB6.0 we would use something like screen.width and screen.height, but for VBS? Don't rightly know off hand... Good Luck |
 | There are many things that could be done better or added but where it really starts from is the beginning. #1 The surprise rollout of a buggy new system is as unprofessional as one can get. #2 You want use to reiterate what we have already written within this forum …  |
| | Friends time (yahoo, google, ask, answers, bing) vb6 ado tutorial... Good Luck |
| | Okay, I think you should look at your click event of that button before you go adding if text2.text<>"" and text3.text<>"" then leave text4 alone because it sounds like your problem is in there... Good Luck |
| | Re: Help in access There are controls and other things that you can buy, but most of them are meant for actual programming languages... Have a search with your friends (yahoo, google, ask, answers, bing)... Good Luck  |
| | Time to use your new best friends... and I'm talking about yahoo, google, ask, answers, and bing. These various search engines can find you so much example code, you could not shake a stick at it even if you did have all day. So what you need to search for … |
| | What you are talking about is the creation and use of [B]class modules[/B] or better yet, "Objects"... ie OOD... and while you could do these things with this design methodology, it is a bit of overkill... but with that said, I would also think that to learn this programming methodology, … |
| | Oh something like... [code] strSQL = "SELECT SUM(numericfieldname) FROM tablename WHERE datefieldname >= #" & "01/01/2010" & "# AND datefieldname <= #" & "01/30/2010" & "#" [/code] Now, the above is for access only as SQL server will give you an error if you try an execute the above query. … |
| | I believe it is because you are missing some parameters in your open statement... the next one after your string should be your connection object followed by cursor type and lock type... Good Luck |
| | Using your friends (yahoo, google, ask, answers, bing) you would have found that this problem has been encountered before and there are several solutions out there that all pretty much begin with right clicking on the vb6 setup.exe and selecting run as admin... Good Luck |
| | What you are trying to do via VB can be done by the net admin with a few mouse clicks... Then there is the potential that this could be so misused... |
| | Okay, it sounds like you have designed a DR on one machine (Computer1) and now are trying to use it from a second machine (Computer2). Which means, it could be as simple as accidently hard coding the path to the database and since you are on another computer, that path … |
| | It doesn't, unless you tell it! Meaning, create a public sub/function/routine that accepts what you want to pass as a parameter. As for reusing a form... [code] Dim F As Form1 Set F = New Form1 Load F F.MyPublicSub "MyStringToPass" F.Show [/code] Good Luck |
| | Specify the path in code and not properties at design time. In code, use M$ rules for newer OS's when installing program and running program on other computers. See [url]http://www.vbforums.com/showthread.php?t=456795[/url] Good Luck |
| | The conjecture of why M$ droppped VB6.0 and their soon to be released but never was VB7.0 in favor of the new .NET technologies that has been resisted every step of the way by some and embraced by others... |
| | Re: RDO, SQL and ADO Time to use your friends (yahoo, google, ask, answers, bing) and search for vb6 "data access method" tutorial (vb6 ado tutorial, vb6 rdo tutorial, vb6 dao tutorial) Good Luck |
| | Friends time (yahoo, google, ask, answers, bing) vb6 file properties and with this search you should also run across dsofile.exe of which you can ignore because that is for office documents. But in the end, you will find that there are several ways in which to do this, including... [url]http://www.vbforums.com/showthread.php?t=557389&highlight=properties[/url] … |
 | Check out the DateDiff function for testing the date. Use an Update Statement to increase the value by one or to set the field to the correct value. Flash is not VB so I couldn't tell you. Hopefully someone can come along and give you an answer... Good Luck |
| | Thesis... Hardware versus software and the inability of hardware speed to keep up with the complexity of higher level languages in the attempt to package multi use objects for the layman to drag and drop these objects to create a process or a workflow system. Specifically I am talking about … |
| | Re: Ask Value Type Okay, so you have posted an API. The SendMessage API, which is one of the most widely used and versitile API's but I don't see where bolding or something in bold is demarked. So, what is your question? |
| | Kingwang, sarama... DO YOU REALIZE THAT THIS THREAD IS 4 YEARS OLD!!!!  |
| | Hardcoding all those paths is really not the best thing to do because if you have to make some change to where the file is or its name, you will have to send an updated exe out and then may need to have the end user uninstall and reinstall your … |
| | Andre... [code] Name OldFile As NewFile [/code] Den... The syntax you are using.... [code] Dim FILE_NAME As String = "C:\test.txt" [/code] Will throw an error in VB6.0. It actually looks like you are using vb.NET and as such you are in the wrong forum. So, if this is so, that … |
 | ak, do you realize that this thread is almost a year old??? |
| | Friends time (yahoo, google, ask, answers, bing) vb6 parallel port code and you should find things like [url]http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=1246&lngWId=10[/url] Good Luck |
| | Check with seagate or sap who now owns cr as I hear it being told and see if they have version 11 available for download... It should come with all the information you need to use it with both vb6 and other programming languages... Good Luck |
| | Dim Rs As ADODB.Recordset Set Rs = New AdoDb.Recordset Rs.Open..., conn, ... You have the conn right (set = new), but missed the rs... Good Luck |
| | Use the FlexGrid control instead if you are wanting to go unbound... Good Luck |
| | Re: proposal Best advice I can offer you is to search with your new best friends (yahoo, google, ask, answers, bing) as this has been covered before in many a forum. In fact, searching yahoo with vb6 thesis ideas returned 19400 hits... Good Luck |
| | Yes we may be able to help you but without knowing what the code is, the err.number and err.description,... well presently we are clueless as how to help you.... Good Luck  |
| | Yes there is but it really depends upon your code and controls and right off, no it does not make sense without knowing what exactly is going on. However, with that said, if you are using a timer you could do something like this... [code] Private Sub Timer1_Timer() Timer1.Enabled = … |
| | How??? One step at a time! First off, are you wanting to do something like the red box, block buster, or netflix? Second off,... this will more than likely involve a database so I suggest you start there. Meaning, get the old Mark I recording device out (pencil and paper) … |
| | Re: Record sound You should read the description of the code and the code itself to find out if it does what you want... Good Luck |
| | Re: New Project Trends?... That depends upon the area of business you are wanting to to get involved in. Games Connect 4 Frogger Chess Checkers Blackjack tic-tac-toe holdem (as in texas) ohmaha tetris clone of any popular game out there... accounting... human resources... document discovery... shipping... acquisitions... materials management... robotics... project management... AI... … |
| | Re: Crystal Report Crystal Reports (CR) has a set of instructions in the help files for nearly every programming language it is compatible with and for each type of database it is compatible with. You might also want to use your friends (yahoo, google, ask, answers, bing) to search for vb6 ado tutorial. … |
| | Okay, to start any project is to sit down in a quite room with the old mark I recording device (pencil and paper) and write down your requirements. Now, since you know this project will involve a a database, I suggest you start there. Write down what information you will … |
| | Well now that this thread is in the right forum I will advise the OP to search for vb6 startup folder with their friends (yahoo, google, ask, answers, bing) and to see the FileCopy Function in help... Good Luck  |
| | To be more precise, you have Visual Basic for Applications, VBA for short and more than likely it is version 6.5. As for helping you further, what code have you written so far? Good Luck |
| | You might want to try an asp forum... |
| | This might help... [url]http://www.vbforums.com/showthread.php?p=2807202#post2807202[/url] Good Luck |
| | Start VB's help and on the index tab type in navigate. Select the second one down and that is the help file for the information you seek. As for what exactly is contained within, I couln't even guess as I normally use other methods to fill in forms and click … |
| | Re: teste When you get to the screen in the PDW where it shows where the files are going to be installed, this is where you would add your report files. Also, the PDW should include any and all dependincies... Good Luck |
| | Use the query design tool in M$ Access to design this query. Then, once you have it returning the information you want, goto sql view and copy it from there to paste into your vb6 program, and from what I can tell, you are almost there but I do have … |
The End.