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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aberry

    Method 'Range' of object '_Global' failed

    Thanks for your prompt response. Perfect fix. That's what I get for trusting the macro code!
  2. aberry

    Method 'Range' of object '_Global' failed

    I've saw several posts referencing this error but so far I've been able to fix this. First time through the code runs and creates the spreadsheet, 2nd time through it errors on "Range("B2:F2").Select". The program needs to run continuously so I can ask the user to exit it each time to sort...
  3. aberry

    No such repository

    Hi, I have a Debian server running Sarge running MySQL and CVS mainly. All was working correctly until an upgrade this morning. Now when I try and log into CVS I get an error saying "no such repository" - this is when I try and login locally or remotely. I've checked again the permissions on...
  4. aberry

    mysqlhotcopy

    Hi, I'm trying to back up my databases using the following command:- mysqlhotcopy -q --password invoicing /tmp/test/ However, I get the following error message:- install_driver(mysql) failed: Can't load '/usr/lib/perl5/auto/DBD/mysql/mysql.so' for module DBD::mysql...
  5. aberry

    IIS 4 error msg : The Data Is Invalid

    I'm now having this error, anyone know how to fix it?
  6. aberry

    Outpitting a semi-colon

    Thanks, as I thought it was. Turns out it was a different problem.
  7. aberry

    Outpitting a semi-colon

    Bit of a newbie question. I want to print a ; to screen but obviously the ; is translated as it should be. How do I get round this? Thanks, Andrew
    • aberry
    • Thread
    • Replies: 2
    • Forum: PHP
  8. aberry

    Converting PDF to Postscript using VB6

    Hi, I know you can manually convert PDF files to Postscript using Acrobat 5. However I would like to do this using VB6, does anyone have any suggestions on how to go about this? Thanks, Andrew
  9. aberry

    Extracting Pages of a PDF using VB

    Hi, I am trying to programatically extract pages from a large PDF and break it down into smaller PDF's. I am experiencing some problems however. The jso.extractpages option seems to be erroring. Can anyone point me to where I am going wrong. Code follows. Thanks, Andrew Dim jso As...
  10. aberry

    Extracting Pages using VB

    Hi, I am trying to programatically extract pages from a large PDF and break it down into smaller PDF's. I am experiencing some problems however. The jso.extractpages option seems to be erroring. Can anyone point me to where I am going wrong? Code follows. Thanks, Andrew Dim jso As...
  11. aberry

    Form Resizes at Run Time

    Hi, I have a problem that as soon as I start a project the form resizes to smaller. Any ideas what may be causing it? It's not in the code as I have set a break on the first line that says debug.print frmSetup.height and at this point the height is different to what it is set to in design...
  12. aberry

    Colouring text in a Statusbar

    Hi, Is it possible to change the text in 1 panel in a staturbar or even individual words? Thanks
  13. aberry

    CSV Files

    Hi, I am using VB to export records from a MySQL database to a CSV file so that the file can then be used in Excel in other parts of the business. However, when I open the resultant file in Excel it translates the 02/1 text field to a date which I dont want it to do. I've tried with and...
  14. aberry

    Error Updating Records - MySQL

    brilliant, thanks for your help. All working now.
  15. aberry

    BATCH Files with VB6

    sounds like it could be to do with the method you are using to write the file. I have done this in the past with no difficulty. Which method are you using?
  16. aberry

    Error Updating Records - MySQL

    Hi, I have 1 table in a MySQL database which I am trying to update all the records in programatically. If I update the records manually there are no problems. The code updates 39 records and then bombs with the following error message:- Key column information is insufficient or incorrect.Too...
  17. aberry

    MSFlexgrid and Scrolling

    many thanks for the help guys, works a treat :) The following code did it:- iHeight = (MSFlexGrid1.Height / MSFlexGrid1.CellHeight) / 2 If MSFlexGrid1.Row > iHeight Then MSFlexGrid1.TopRow = MSFlexGrid1.Row - iHeight End If
  18. aberry

    MSFlexgrid and Scrolling

    I am loading records manually into a flexgrid and depending on what data the user enters I am selecting the row. This all works good and well. The problems occurs with selecting the record programatically, because there are so many records being entered there is a scroll bar and the...
  19. aberry

    where can i get office2000 icon?

    have a look in the directory where you installed VB and then in Common->Graphics->Icons - if that doesnt exist you can get them off the VS CD.
  20. aberry

    Authenticate to Database

    The way I have found best is simply to take the values from the text boxes and build it into your connection string that connects to the MySQL database. Connection string then looks something like this:- db.Open "Driver={mysql}...

Part and Inventory Search

Back
Top