Search:

In VB6, there is a package and deployment wizard function. User can choose Internet package to pack the application files into Cabinet file, etc. Anyone know about how to do the same in VB.NET? How...

In VB6, there is a package and deployment wizard function. User can choose Internet package to pack the application files into Cabinet file, etc. Anyone know about how to do the same in VB.NET? How...

Thanks for all the advices. I think the BMP type image is a source of the oversize. My PP pages do not just contain single screen shots for each, i.e. some page may contain up to 8 small sized of...

Sorry, I cannot have the Object sub-menu by right-click on any of the images and cannot find this Object|Convert function else where. The images were produced by using "PrintScrn" key on the...

I m casual user of PP. I just made a 7 page file. 6 of them have animation effect and image obj paste from other places. Then I found the size is abt 3.4 MB big that far larger than a floppy size...

Thanks a lot Dottie,

This is what I asked for. I have two clear answers: 1. VB form has no scroll bars; 2. VB can solve my problem by using MDI form. Now When I move the child forms in MDI parent,...

It seems there is no way to put scroll bars around form like what we can do in design time? It is a bit disappointed. As my application needs to show as many as possible of records from db, the users...

My question should be simple to someone who has relevant experience. I need to have scroll bars of my forms for running on diff monitors. My PC is at higer solution where I develop my application...

It could be adodc's problem. But so far I failed to to find out where it is.

Comparing to your code, my connect properties are not much different. One thing is diff for sure is that you use one...

Thanks Charlotte.

My input boxes including DTPs have to be dynamically bound, also ADODC's are connected by code as the db location may be changed later (cannot use udl file). So cannot set...

Thank you Hans!

During run time, I need to check SQL statement which is assigned to string variable strSQL and can be 400 hundreds characters long. When use Watch Window, I can only manage to see max abt 250...

It seems a hard question or rarely people use this control as nobody response the post for days.

I also found when delete all the records in the related table, the same msg occur too but at the...

The original question is "How does VB Handle the IIF command? ". I dont feel any special for VB handling IIF function than VBA or Access. I used it several times in my VB6 applications (with NZ...

I m using two DTP controls in my VB app linked to Access 2000, one for Begin_Date and one for End_Date field. These two fields are grouped together with other input boxes (text boxes). The two DPTs...

Thanks a lot Mark.

I am just going to change back to VB6 for my work as there are so many things confused me to use adapter, dataset, datarelation object, etc without much time and useful...

This lounge should have a seperate area for .NET in addition to the currrent MS Office and Windows sections. VB7 has had significant changes from VB6 and become a real software language. This makes...

I seems that many people have not really learn VB7 yet. This is the first time I posted my question without any reply for three days and the question is not a deep question.

I read some material...

I just start to try VB7/.NET version and feel strange that adodc component doesnt exist in the toolbox although it includes a lot of non-standard components in VB6. There is no more "Components"...

Thanks Hans. I m interested in only the second option. I dont think many people like the first one - name the DB table field names only as F1, F2, ... , not so practical. The last one is a good...

Thanks Francois,

I m not so sure abt what is the relational structure in Excel. Nevertheless I cannot control how to make the Excel files but can know their format. I had similar rough ideas as...

THanks Hans, your advice is critical to me as you gave me the syntax/ref for how to embed the Access VBA in VB.
Since had a bit experience doing VBA for Excel before, I thought it might be a quick...

Thanks Wendell,

Unfortunately, the request is to do this by VB6, as my subject title mentioned. I knew it coulbe done by hand from Access, but I need a code to do the same and the code is to be...

I got requirement to transfer full data from columns of Excel sheets to Access tables and this has to be done by VB code (e.g. by press a button in a VB application). I guess someone somewhere have...

Yes, I tried to use Compact and repair function as you suggested. It is so easy to compact the size down. The same file by using this way is reduced to 1076KB, a little bit more than import method,...