Posts by vb5prgrmr

Connections are expensive, meaning in time and resources. Depending upon the system you are creating and the database you are using you may want to open the connection when the program starts and close the connection when the program ends, which is the easiest way in which to do things. Then when it comes to recordsets, you only keep them open for as long as you need them as they are expensive in their own right and can be even more expensive than a connection object...

Also, you use the pretty much the same syntax in closing a connection as you do with a recordset...

adoRs00.Close
Set adoRs00 = Nothing
adoCn00.Close
Set adoCn00 = Nothing

Good Luck

Andre...

Name OldFile As NewFile

Den...
The syntax you are using....

Dim FILE_NAME As String = "C:\test.txt"

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 you are using .net, then please PM a mod, or use the report this post button under your name to have a mod move this into the VB.NET forum...

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 a couple of threads where this question has been ask and answered before...

Good Luck

See this thread http://www.vbforums.com/showthread.php?t=346752

Good Luck

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 program. Best bet for something like this is to use or put the file to be opened in the INI file, so if changes are made, you just need to send out a new INI file or the instructions to update it.

Now, if this is a true INI file, you will want to delve into the API... WritePrivateProfileString and GetPrivateProfileString...

If it is just a text file with an INI extension, then you will want to look at...

FreeFile Function
Open Statement
Line Input Function
Input Function
Close Statement

Good Luck

Friends time (yahoo, google, ask, answers, bing) vb6 parallel port code and you should find things like http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=1246&lngWId=10

Good Luck

Kingwang, sarama... DO YOU REALIZE THAT THIS THREAD IS 4 YEARS OLD!!!!

SQL (Structured Query Language) consists of using select statements, insert statements, update statements, and a bunch of other statements to create or alter the database structure in it self. Use your friends like I said and you will find some of these statements and or search for sql tutorial...

Good Luck

Have a look at the Hex Function... and BTW 10 = A, B = 11...

Good Luck

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 want to do?

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

See http://www.connectionstrings.com just in case...

and I see that you are using ???? Data Source as in an ODBC DSN? Did you create the ODBC DSN on the other computer?

Good Luck

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

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 is incorrect. Make sure you are specifying the correct path...

Good Luck

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 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...

Private Sub Timer1_Timer()
Timer1.Enabled = False
'your code goes here
Timer1.Enabled = True
End Sub

Good Luck

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) and design your database. Now, with a netflix or a block buster type of system you will need name, address, and for security, a credit card number, which can be fictitious for testing purpose but you can find credit card number validation algorithms on the web with a search with your friends (yahoo, google, ask, answers, bing). Then you will need to also design an inventory management system.

Once you have gathered all of the data requirements and put them down on paper, you will need to normalize your database. Once that is done, then you need to start thinking about your interface.

If you are doing a block buster type of application then you will also need to think about security as a clerk should not be able to do the same thing as a shift manager or manager, and a shift manager should not be able to do the things a manager can. So this means back to the database design...

Now, if you are doing a netflix type of thing, then you would need to goto an asp forum...

And finally, if you are doing a redbox type of thing, you will …

You should read the description of the code and the code itself to find out if it does what you want...

Good Luck

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 need to capture, retrieve, and manipulate(calculate). These would include, but not limited to, name, address, tax information plus other with holding, salary or hourly, rate, and so on.

Now, once you have all the information you want to capture and have normalizied your database design, then it is time to start thinking about how you want the user to interact with each of these sections. This of course should lead you into program design and program flow, or in other words, how the user access each of these sections and how they are connected together. Once you have that planed out, then it is time to turn the computer on and start programming and once you have any problems, come back here with the problem piece of code and we will be willing to help you as best as we can.

Also, you can probably solve a lot of your questions by yourself when you use your new best friends (yahoo, google, ask, answers, bing) to search for things like vb6 ado tutorial.

Then of course, there is http://www.connectionstrings.com for DNS Less connections strings...

Good Luck

Well, what the error is telling you is that the connection object (DB) is not connected to the database, which could mean that the sub connectDB has not been called, and I can see where you have commented it out...

Step through your code to make sure you have opened it, and have not accidently close it...

Good Luck

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. Then once you have that down, you could goto a DSN Less connection string, see http://www.connectionstrings.com

Good Luck

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

You have declard your variable as integer, which max amount it holds is 32767. Try as Long or as Double. See help on variables for more information...

Good Luck

You might want to try an asp forum...

This might help... http://www.vbforums.com/showthread.php?p=2807202#post2807202

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 buttons to submit data...

Good Luck

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

No I don't think that is your problem. Have another question. So then swpType is a number? Oh yeah, one more. Did you create the query in the M$ Access Query Designer?

Good Luck

Welcome to the Visual Basic 6.0 Forum. Since you are asking about Visual Fox Pro in a VB forum I can only suggest that you use your new best friends (yahoo, google, ask, answers, bing) and search for vfp code or vfp tutorials...

Good Luck

>Nothing was a surprise about it. It was mentioned for 6+ months to come on a fairly regular basis including screenshots of early mockups along the way.

And how was this information dispersed? Spam-mail? Community forums? Most people I'm willing to bet don't even bother with the community forums or the emails. I know I don't bother with the emails and did not bother with the community forums until this appalling new layout had assulted my eyes for three or four days. Then when I came down here I read the threads so as not to duplicate anyone elses efforts, well all of them except that long one but I did read some of that one also. So then I posted and I tried to show a sense of humor about things (remember oompa loompa's) but now you want use to cover the same ground? Well that just irked more than one nerve as you can tell because I know you have asked for examples before and I gave them and if I remember correctly, other people did also.

See that list of forums I mentioned above for examples on the following

Syntax and text highlighting (Colors!)
Layout options
Skins (only a couple) + http://www.classicbattletech.com/forums
Closing old threads after a period of time (http://www.tek-tips.com)

and so much more...

and be a professional and do the research yourself as we have already done it for you once!

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 a question... Why are you selecting paynum and swpnum if you are using these to join on? I ask because the way you have your field selection set up, you will have two columns that equal each other. Don't you need only one?

Okay, I have more questions. If swpNum is a number, then why are you enclosing it in single ticks (') to denote that it is a string?

Good Luck

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...

inventory management...

and I know that if you search with your friends (yahoo, google, ask, answers, bing) for vb6 project ideas, you should run across other forums with similar questions...

Good Luck

Okay, lets start with your code...

#1 Why decleare a new form login from within the login form (Dim Login_Tab...). It is unneeded..
#2 You declare usertxt as variant but do not use it
#3 Next line commented out
#4 Where is username1 declared? I thought from within access if the control did not have the focus you had to use txtuser.value and not txtuser.txt
#5 see #4
$6 Okay, where is username declared? Where is pswd declared? Why are you trying to evaluate these variables to constants?

Perhaps a quick search with your friends (yahoo, google, ask, answers, bing) for vb6 ado tutorial will help you alot. Look for the vb6.us or whatever it is as they have lots of tutorials that will not only help you with connecting to your database, but with your code structure and logic. You may also want to search for vba forums or access forums while your at it as I know sites like tek-tips have both...

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 since the rollout of this new design! Why cannot you reread all those posts and make the list yourself as you should have done from the beginning? Just more evidence of the lack of professionalism!
3# You want a list of other forums? See the pinned post in the Visual Basic 4/5/6 forum, VB6 Stuff, Tutorials, Source Code, Tips and Tricks http://www.daniweb.com/forums/thread214396.html post #2 at the bottom...

I'll stop there before my blood boils over as I rethink these things but I am surprised that more people have not gone over to http://www.programmingforums.org/ where they have the same design as this place used to have...

Oh yeah, as for the speed increase we are supposed to be seeing!!! Not on this end! In fact, this is one of the slowest and unresponsive sites in that list that I mention above as I visit each of them daily if not twice daily!!!

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

I know that some others have done various things like creating a webserver with vb6.0 so you might want to use your friends (yahoo, google, ask, answers, bing) and search for vb6 create firewall but I doubt you will find much as you would have to insert yourself between the application and the pipe and vb is really an application layer tool and not a system level or kernel level tool...

Good Luck

If you are using the webbrowser contol you have several choices in how to accomplish what you want, but since we do not know what you are using and the code you are using to attempt what you want, we are left in the dark...

Good Luck

so then adding...

SELECT q1.pal, q1.boxes, q1.qta, q1.minofdata, c.nome, tc.prezUnit ...

does not work? Because yeah, this is a complex query...

You might want to search for SQL forums or access sql forums like the ones over at tek-tips and other places if no one else pipes up...

Good Luck

Use M$ Access's query design tools to create your query. Once you have it showing the information that you want, then goto sql view and copy it from there into your vb6 application. It really is one of the best tools out there for creating the more complex queries...

Good Luck

Yes, that is one way and perhaps the easiest way...

Good Luck

What do you have so far in... Code? Requirements? Plans? Looks? Operations? Is it to include JIT?

Good Luck

Did you create an install package? You must install the program onto the new machine! You cannot just copy the exe over and hope it works... Use the PDW or its replacement, visual studio installer, which can be found in the pinned thread of this forum about tips, tricks, and code.

Good Luck

See http://www.shrinkwrapvb.com/

Good Luck

You need to add a reference to the Microsoft Scripting Runtime...

Good Luck

Why yes we can. We can send you right over to ebay, nextag.com or sap/seagate/crystal.com where you can buy a legal copy of the software... Don't forget you will need the developers license...

Good Luck

First lets start with help file/search term subjects...

For Text Files
FreeFile Function
Open Statement
Line Input Function
Input Function
Print Statement
Close Statement

Search terms for you friends (yahoo, google, ask, answers, bing)

vb6 Run at startup
vb6 shellnotifyicon

Good Luck

Not that I know of right off the top of my head, but I believe rational rose used to be able to generate a flow chart of a project. Not that, that helps...

Well, just so you know, the VB6.0 project files are almost all ascii so as long as you know how to open a file, read it in, parse it, close it, and have a good understanding of what keywords you need to find, you should be well on your way...

Good Luck

Lets see what you have tried... and if you have no idea, I'll give you a hint

Select Case Curr

Good Luck