Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

brilliant, thanks for your help. All working now.

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?

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

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

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

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.

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