Search results for query: *

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

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

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 = " &...

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

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

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