Search results for query: *

I had ton of new code changes, and ran my code in the Visual Basic 6's design environment. The program went to an infinite loop forcing me to shutdown VB environment prematurely before I had a chance to save it. Is there a way to recover my lost code? Thanks, Bao

Jeff, thanks for your help. Although it doesn't work out exactly, because I have 2 columns of checkboxes, so I want to make sure the rows are lining up correctly. But I think I got your idea. Thanks, Bao

I have about a dozen of checkboxes in a frame, and depend on the choice selected only some of the checkboxes will be visible to the users? This would create some spaces between them and the screen wouldn't present nicely. So, is there a method to line them up automatically without having to...

I use the following logic in the footnote section of my mail merge document and it works fine in WORD 97. However when I run in WORD 2002, the page numbers were wrong for all the pages in the document. The page number was set to 3 for all the sections that have the page number field inserted...

Thanks for your info Duane. I used FileDSN in the Microsoft query to connect to the Oracle table. The FileDSN is on the LAN so all users can access it. Bao

I'm using access 97, and have an sql pass-through query to access an oracle table. It has the following property: ODBC;DSN=GARP;UID=demo;PWD=demo; In order to run the query, I have to set up the Data source on my machine. My access database is on the LAN, and I want many users to be able to...

I'm testing the vb code using mail merge with word 2002 for a group of users. It has been working fine with word 97, however when i ran with word 2002 and tried to call the OpenDataSource method, a Select Table dialog box appeared. Here is the mail merge code that I use: strSQL = "SELECT...

Thanks for the info swi. Now how do I copy one table into the other e.g. MyTable to MyBackup? Bao

I'm using DAO in visual basic, and I need to rename an access table MyTable to MyBackup, how would I do it? Thanks, Bao

Well, we created the two applications, and they were both standard exe. I made up the name just to drive the point. The actual names are: PlanInstall.exe which acts as a driver program, and TextFileGen.exe which is called by PlanInstall.exe. I just want to know the path of PlanInstall.exe so...

I have a driver.exe that calls a process.exe, and both reside in different servers. When process.exe starts, is there a way to determine the path of driver.exe without having driver.exe pass any parameters (e.g. the path name)? Thanks, Bao

I have a bookmark defined in the Main document, but when Word merges to a form letter 1, the bookmark didn't carry through. Does anyone know why? I'm running the word merge through VB 6 and Word 97. Thanks, Bao

Thank you all for your helpful suggestions. John: I had to make the desired tab active before looping thru all the controls, and then check for the property Left >0 on each control. This way I'll be able to collect only the visible controls on my desired tab and it worked as expected...

Hi All, Basically, from what I have tried, when iterate through the control collection, we can tell if the control is contained in the SSTab, but we don't know on which tab number that control belongs to, to be able to do something with it. Thanks, Bao

Hi John, I used your code and changed the If statement a little.Basically I tried to get all the controls on tab1 but somehow the code missed it. I step thru a few controls on tab1 and checked the tab number (cont.tab) and it showed the tab = 0 instead. For Each Ctl In MyForm On...

My question above pertain to my code. However when I tried your code out, it died on the line If Ctl.Container = MyForm.SSTab1 then (note that I removed to second part of the If) with the error code: Error 450: Wrong number of arguments or invalid property assignment

With mine...

It died at the For Each line...

Thanks Craig. What wrong with my code? I thought SSTab1 is the container and by pointing to MyForm.SSTab1, I just have to use the For Each to loop thru the controls contained within...

I have a SSTAB control with 3 tabs, if I want to loop thru all the controls contained in a particular tab, say tab1, then how would I do this? I've tried the following code and it gave me an error saying "Error 438: Object doesn't support this property or method" For Each Ctl In...