Glad you got it solved... Next time though to keep your thread from being moved you should specify which version of .net you are using in your question...like
Dim MyString As String, MyStringArray() as String, ForLoopCounter As Integer
'...open rs etc..
Do While Not Rs.EOF
MyString = MyString & ","
Rs.MoveNext
Loop
MyStringArray = Split(MyString, ",")
For ForLoopCounter = 0 To UBound(MyStringArray)
'....
Okay, a business lawyer is what you will need... 1st, you will need to discuss with the lawyer what kind of business license you want. LLC, corp, etc...
As for protecting your code and talking to programmers, I doubt you would talk to other programmers. You would however talk to hospital administration staff as they are the ones who do the buying...
Now, from the sounds of it, because of your expectations in having to talk to programmers, it seems that your program is meant to intergrate/access the customers accounting/patient records system. If so, then you may not need to actually talk with the programmers yourself. Well, that is if you hire and train a programmer on your system.
Then comes the best way to protect your code. Don't let outside personnel see it. Once you or your programmer has all the information needed to integrate the system into the customers system, you compile it and make an installable so all they need to do is install your program.
First, increase the page file size and second, never use a varient array...
In vb's help type, on index tab, type in "data types" and hit enter. When the dialog comes up, scroll down to Data Types Keyword Summary Visual Basic Reference>Display. Click on Boolean (2nd line first word). Click on See Also>Select Data Type Summary Visual Basic Reference. Now, on that page scroll down to where it shows the overhead for varients...16 bytes for each element in the array that is a number and 22 bytes for each element that is considered a string by the unknown (runtimes) mysterious forces behind vb6.
My Goodness my good man/woman do you realize just how much memory you are eating up by using a varient??? Use a string if you must, or a long... BUT NEVER USE A VARIANT!!!!
For a start see... http://www.shrinkwrapvb.com/ and then use your friends (yahoo, google, ask, answers, bing) to search for vb6 mp3 extract as I know there is some code out there already (Remember, if you have thought of it, more than likely so has someone else...).
Okay, there is more than one way in which to use excel with visual basic 6.0. Now, you said as a database so you will need to use your friends (yahoo, google, ask, answers, bing) and search for vb6 ado tutorial. Then see http://www.connectionstrings.com for a DNS LESS connection string that you will need for your ADO connection.
Also, you could use your friends to search for vb6 automating excel tutorial...
Well that depends upon what you want to do... and how the application works...
Okay, lets see if I can simplify my thoughts....
Biggest initial payday for you is to sell them the code base and wash your hands of it an any further development for X number of years. This is a one shot deal/payday. Also, find a lawer that will do this as a flat rate or percentage of sale price (do not find an ambulance chaser as they will be looking for too high of a percentage...Look for business lawer and I would also suggest that you interview him/her/them as if you were hiring an employee. An employee that will look out for your best interests. Also, you don't have to like this employee but you do have to trust them).
From there, you have several different options and hybrids of these options but as you are a doctor, I'm guessing you really don't want to change professions, but with that said, you don't have to change professions if you want to be a small business owner. So before I go into all these other possibilities, what are you wanting to do...???
If the Make Project.exe is greyed out, then that means you must be using the Control Creation Edition of Visual Basic 6.0 and you will need to go over to either nextag.com or ebay to purchase a legal copy. I would suggest that you purchase Visual Studio 6.0 Enterprise edition...
Package and deployment wizard should be a menu item under Microsoft Visual Studio Tools sub directory...
A select case statement might help or you could use and if elseif structure...
Select Case Combo1.Text
Case "Orange"
'formorange.show
Case "Apple"
'formapple.show
Case "Grape"
'formgrape.show
Case Else
'sometimes the combo box may not have text in it...
End Select
3) learn API SendMessage with WM_SETTEXT Const (you may or may not need some combination of the following... FindWindow, EnumWindows, EnumChildWindows, PostMessage)
I'm thinking you might be in the wrong forum... because if you are wanting to do this from your site, i.e. clicking a button/link in IE that is from your site and logging into yahoo, then you need a forum for web sites. PHP, ASP.NET or classic asp.... whatever you have done your site with....
ranjani, welcome to the site... It is not nice to highjack someone elses thread as you have done and frowned upon by many a site. So please, for future reference, if you need to reference someone elses thread or an older thread as this one is getting to be, copy the url into your own thread posting along with your question.
As for your question, if your going .NET... you might as well go all the way with .NET and learn as much as you can. However, if you are wanting to be webdesigner then I would suggest that you learn ASP.NET classic ASP and PHP as I see a lot of requests for those skill sets...
Okay, it is time to use your friends (yahoo, google, ask, answers, bing) but, you will need to do multiple searches as I don't think there is a complete solution for what you are looking for out there...
sidnei, good post but if you reread jemz post you will see that they are entering H-1010 for the primary key, meaning that the primary key is a text field. So jemz I would suggest that you use sidnei's 1st suggestion...
strSQL = "SELECT COUNT(fieldname) AS THECOUNT FROM tablename WHERE fieldname = 'H-1010'" 'or conversly you could do...
'strSQL = SELECT * FROM tablename WHERE fieldname = 'H-1010'"
'set Rs = ...
If Rs.Fields("THECOUNT") = 0 Then
strSQL = "INSERT INTO tablename(fieldname1, fieldname2, fieldname3) VALUES('H-1010', someothernumericvalue, 'someothertextvalue')"
Cn.Execute strSQL
Else
MsgBox "Key Exists! Please enter another primary key", vbOkayOnly, "Primary Key Exists!"
End If
How do you want to access the *.mdb from VB6.0? RDO, ADO, DAO, Data1, ADODC1? What code have you tried? Any errors? What Line?
We need a bit more information to be able to help you but if you are wanting to use ADO see both the data form wizard (under add-ins>add-in manager) and http://www.connectionstrings.com...
The PDW is a bit outdated, but with that said, if you run it as admin and still recieve this error message, it should be no problem. However, if you do have problems with your program you might want to download Windows Installer 1.1 or inno. Windows Installer is the upgrade for the PDW (kind of it is actually the replacement for it).
Well what do you know!!!! Another nonexistant code snipped!!!! And low and behold, it is another question!!!!
Well now, lets see where the OP's code could have gone wrong.... Well what do you know!!! No code to examine!!! So I wonder how we are going to help the OP if we don't know what code they are using???
Hmmm... Three child forms... Well, you are either going to need to capture a screenshot of each and assemble a bitmap from them and then print that out, or use a report of some kind. Either a data report or crystal reports should do the trick for you if you go that route. Now, if you have VB6.0 pro or enterprise, you should find a directory called crystal on your install disks. This is crystal reports 4.5 or 4.6. and is fairly easy to use...
I suggest that you do what jireh suggest but before you do, set the style of the combo box to 1 - simple combo. Then resized it's height to see if that is what you are looking for...
It should be installed on the users computer when you/they install your program... Oh, no!!! Don't tell me you thought you could get away with just giving them the exe!!!! No, you have to at least use the PDW (Package and Deployment Wizard), or better yet, you could use Windows Installer 1.1 or Inno to do your setup package for you so that they get all the dependency files you need...
Okay, you want to upgrade a program and you know how to do it from a dos batch file but you don't want to use the dos batch file because it can only do so much... So then create an upgrade program that can do what you want with those excel workbooks/sheets. Now, however you do it, strait program, new install, dos batch + program... your goal is to update a bunch of files on the end users computer and you want to do it as painlessly as possible for them right? So, a dos batch file can do some of the work for you, i.e. replacing those files that it can, and it can launch(shell, spawn, shellexecute...) your upgrade program that can manipulate those excel files for you. Furthermore, the dos batch file can also do your cleanup for you if you need it to...
Glad you were able to solve it yourself, but why did you not post your solution so others could learn from it or why have you not marked your thread as solved?
Were missing something here, like what is graphics original format? Why cannot you use paint to do a save as? Is the file not supported by VB? Why cannot you use the Picture property of the form in the design environment to load the graphic? Don't know about the LoadPicture Function?
A whole lot of information is missing here don't you think?
Use the datediff function and if you do not have any processing going on at the button click event, use a timer set to 60000 and see if Now() or Time is greater or equal to the value from the datediff function...
Do you know how to use ADO? Search with your friends (yahoo, google, ask, answers, bing) for vb6 ado tutorial. See http://www.connectionstrings.com. Use the Data Form Wizard under Add-Ins>Add-In Manager.
