Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hojo
  • Order by date
  1. hojo

    Input Box Cancel

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

    Input Box Cancel

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

    Setting Screen Resolution

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

    Over riding ALL errors

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

    Over riding ALL errors

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

    Distributed Database Program

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

    Distributed Database Program

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

    I created MAcro based fiel in excel

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

    Running code when a form is unhidden

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

    Convert doc to pdf using VBA

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

    VB6 and XP

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

    Filling Data in Columns

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

    Stopping Excel from changing data through OLE

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

    Data Sources

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

    VB6 and XP

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

    Stopping Excel from changing data through OLE

    Thanks for the try but Excel still sees the data in date format. I've noticed that the Excel OLE object has a "rejectallchanges" method. Pehaps this my be helpful if i knew its parameters. Its askes for [when,who,where]. Isn't problem solving fun. tar
  17. hojo

    close program problem

    I know it may seem like a cheats way out but if this is causing you too much trouble, try just disabling the "x-Button". This way the user has to exit through your menu.
  18. hojo

    Stopping Excel from changing data through OLE

    Hi All I have a Visual basic program i've developed to control the stock levels at work. To print out reports in a logical set out i've sent the data from a MSFlexGrid(which i use to display on screen) to Excel so as it will print in columns. This works fine but excel in all its genius...

Part and Inventory Search

Back
Top