Search results for query: *

StrongM, Someone on a newsgroup finally saw the real problem. I was not using the real name for frmA. Instead I was using an Object variable name. I then referred to the form by its real name rther than the object reference in frmB which created another frmA referenced by the correct name...

Yes, I noticed that. However, it is global to frmA and only while frmB is active. It is a very small class activated immediately before frm b is opened and destroyed when frmB closes so, at least, it is not global across the application. <sigh>. I've asked this question in a number of...

Bob, Thank you. It worked perfectly. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

Hello, I am using Visual Basic 6.0 SP6 with Windows XP SP2. I have two MDI child forms; call them frmA and frmB. FrmA calls frmB. On frmA is an an MSHflexgrid which has information needed on frmB. Of course, referencing information on frmA from frmB immediately creates a brand new frmA so...

Thank you both for the information. It is appreciated. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

Hello, I am a Visual Basic 6 Developer with a reasonable background in C. Unfortunately, it is not C++. And, after developing in VB 6 almost exclusively for the past ten years, I am reasonably certain my understanding of C is now more theoretical than pragmatic. But, what is very pragmatic is...

Hello, I am a Visual Basic 6 Developer with a reasonable background in C. Unfortunately, it is not C++. And, after developing in VB 6 almost exclusively for the past ten years, I am reasonably certain my understanding of C is now more theoretical than pragmatic. But, what is very pragmatic is...

Thank you very much. Worked very nicely. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

I have been asked to modify an Access 97 program. There is a background process which takes a number of *.dat files and updates a number of tables on the Access database. Supposedly, this process, called invctrl.exe is done in Visual Basic. I was provided a copy of the database, a copy of about...

CreateObject("Access.Application") is only supported when the retail version of Access is installed. When only the runtime Access is installed, you cannot use CreateObject (or New Access.Application) or Getobject to launch an instance of Access for automation. This behavior is by design and...

Michael, Do you mean UDT or UDF? If you mean function, please explan a tad further if possible. Thanks. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

I have a form used to accept search parameters for an automobile parts inventory program. The form has three combo boxes and one list box. One combo box list auto year from 1953 to the current year. The second combo is the automobile Make, i.e.,, Ford, Dodge, etc. This has 37 items. The third...

Thank you very much. Problem resolved. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

I have created a disconnected recordset as follows: 310 Set rsInventory = New ADODB.Recordset 320 With rsInventory 330 .Fields.Append "ProductID", adChar, 20 340 .Fields.Append "Descript", adChar, 80 350 .Fields.Append "Price", adChar, 10 360...

Thank you for the quick reply. What it is really telling me it is time to reinstall both XP Developer and Office 2002 because, under the “all programs/” category I have Microsoft Office 97 (which I still use for a number of clients), Microsoft Office XP Developer, and Microsoft Office Tools...

Good Afternoon, I need to distribute an application which includes the run time files for Access 2002. I do have the Office XP Developer CD’s. The application itself is written in VB 6 with an Access back-end. I have created a number of reports in Access and I am starting them from the Basic...

If I remember correctly you must use the standard American date mask of #mm/dd/yyyy##. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

Thanks to both ArtieChoke and LostInCode. Both methods work very nicely. My preference, simply because of the way I code, is to go with the ADOX methodology. Robert Berman Data Base consultant Vulcan Software Services thornmastr@earthlink.net

I am looking at a database with a large but unknown number of tables. I need to capture the names of all the tables on the database. Doing a search of google, the consensus of opinion is I cannot build such a list using any ADO constructs but DAO will work quite nicely and it does. Below is the...

The only variable that can hold a NULL value is a variant. Since a variant is 8 bytes, what you want to do is rather expensive. Perhaps if you could explain why you want to do this, someone could offer a better alternative solution. Robert Berman Data Base consultant Vulcan Software Services...