Recent content by hojo

Thanks Johnwm I've put this into practise. Regards, Hojo

Hello All, I have an application that requests an input from the user via an InputBox function. Trouble is that the users response can legitamatly be an empty string, but if the user presses the cancel button the method should abort. The cancel button of an Input box returns an empty string...

Hi All, I was wondering if there is a way to change a PC's Resolution when it starts my VB program. (and possibly back again once its finished) I am wanting to do this because I have created a program that works best on one resolution and it may be used on a variety of computers. To save...

YES. I have attempted to bypass the errors with "ON ERROR GOTO" but the errors seem to be originating before my program actually starts running, therefore no matter how early i put in the error handling the errors still come up.

Hello all. I have a database project that uses ADODC's. This program will run on a lot of different computers and therefore the path of the database is not constant. I can overwrite this once the program loads by finding the right pass and chanding the conection string property of the ADODC...

Thank you johnwm, but that part i'm ok with. I can track down the correct path (using app.path) and change the connection string of the database. The problem i'm having is that i can only do this once the program is running, but the error message for not finding the database comes up when...

Hello All, I am creating a catalogue in VB6. All of the data is stored in an Access database which is linked to some data bound controls through an ADODC Control. The Program works "Perfectly" except for one thing. This program will be used on multiple computers therefore the Path of the...

From memory there is a check box on this dialog box that says "Always ask before opening documents with macros?" If you uncheck this box it shouldn't ask you again. Cheers, hojo

From what i think your trying to do i would sugest 2 things. 1) When you close the second form(where the guessing takes place) unload it with the Unload Form2 command. That way when the form is opened the next time, it will have to go through the Form2_Load sub again. 2) You can...

I'm not sure of anyway to do this in Visual Basic, but i have a program called "Publish PDF". You have to manuallly tell it to convert files but its fast and simple to use. If you want files automatically converting inside an application then this wont help, but if just just want the...

Thanks All, It seems I should be right. Cheers, hojo

Juat a thought as i have not tried this, but what if you have a loop that runs down your "A" column and if the cell is empty then it equals the cell above it, but only if there is data in column "B" otherwise it will run continuously. For example: Dim i as integer 'Just...

Of course. The simplest solution is always the best. Thanks mate, I'll give it a go.

If you are teaching yourself VB, a book you might find helpful is: Mastering Visual Basic 6 By Evangelos Petroutsos (released by SYBEX) It explains most things you'll need to know about VB6 and provides a lot of example code to help. I found it very helpful when i was starting out. Cheers...

Hi all, My office is looking to update its computers to Microsoft XP operating system and office. Is this a problem for the running of first visual basic 6 itself, and sencondly applications made with VB6.(That is will they run on computers without XP.) Any input would be appreciated. Thanks.