Search results for query: *

I'm in VB6. I guess I am not at your level because I'm not sure what late binding is. I did copy the code from somewhere. But I still get no intellisense with MyFile with your code.

Simple question. With the following code, what do I have to dim MyFile as to get my IntelliSense to work. Do I dim it as an Object? Dim fso, MyFile Set fso = CreateObject("Scripting.FileSystemObject") Set MyFile = fso.CreateTextFile("c:\testfile.txt", True)...

I really did understand that but what can I save to the file? Can I save the whole form itself ( I am guessing no) and how do I actually save. If I have numerous text boxes on the form, how do I save the contents to a file?

Thanks for the tip but you're going to have to bear with me. I understand most of it but what exactly is strThisFile? Does this contain the info I want to save? Do have to put the info into a variable first? I am guessing that I cannot save the whole form itself but only certain contents of...

Can anyone help me with the ShowSave method of the CommonDialog box. It's the first time I am using this control. When I open a particular form, I would like to save the form to my hard disk. I assume I can do this with ShowSave. First of all, am I right and secondly what code to I need...

gotcha Thx

With the following sql, I am trying to return data based on 2 criteria, argDirectParent and argSpouseParent. But it is not working. It brings back faulty data based on only one of the criteria. I figured the "And" would do it. Select * From tblPersons Where Mother = " &...

Thanks tbuch It worked under the Form_Activate procedure. Why wouldn't it work under Form_load?

I am trying to use information from one form on another form. Using the following code, the information actually appears in the text box on the second form but when I try to display the contents in a message box, it shows as empty. Any ideas? FIRST FORM Private Sub cmdSiblings_Click()...

I am getting this error after I have packaged and deployed my application. What is funny is that it runs fine within VB and as an executable but after I package and deploy it, I get this error when I try to view another form. When the program opens, I click a button: Private Sub...

Hi again Got it to work with the following: mobjPerson.GetPersonProfile (mlngPersonID) txtFather.Text = mobjPerson.Father txtMother.Text = mobjPerson.Mother strFamilyNumber = mobjPerson.FamilyNumber Thanks for the help.

Hello CajunCenturion I fully understand everything you said. The object mobjPerson has been created, set on FormLoad and set to nothing on FormUnload. I have a class CPerson which has a method called GetPersonProfile and a class CPersonDB with a method GetPersonProfileDB as shown below...

Thanks for the tip, but still the same error.

Can anyone tell me why the following code returns the following error: "Compile error: Expected function or variable". It hangs on GetPersonProfile. The object mobjPerson has been created and set on Form Load. Private Sub DisplayFamily() Dim arrPersons As Variant arrPersons =...

This works: txtMGFather.Text = arrSpouseParents(0, 0) & "" Thanks a million.

It hangs on: txtMGFather.Text = arrSpouseParents(0, 0) run-time error '94' Invalid use of Null

Sorry you guys who offered help on getting "invalid use of Null" message. Still having trouble. Here is the code. In the DB, "AllowZeroLength = YES". As I mentioned, works fine when there is data in the fields. arrSpouseParents =...

I am trying to retrieve two fields from a DB based on a person's ID and I have created an array to hold the data. I have provided error handling in case the array is empty and it works OK when there is data in the fields. However, when the fields are empty, I get an error message on the...