Recent content by denko

It works. Thanks a lot

How can i assign macros to multiple buttons in excel? I have a code where i create a toolbar, add a button and assign macro to it, but when i add a second button macro is being assigned to the first button instead of the second. Dim cbar1, myBar ' Set cbar1 = CommandBars.Add(Name:="Future...

Hello, Is there a way when copy or cut data from one Excel sheet into another to preserve the column width, data formats, and print layouts? Thanks

How stupid of me, I had the second and the third arguments switched around - InStr(4, "CL B",Table1.Field1,) It works now Thanks

I have a query that uses "Like" keyword. Select Field1, Field2 from Table1 Where (Table1.Field1) Like "*CL B" I do not really like that syntax, can someone tell me what function I can use instead. I tried InStr but it did not work, or maybe I did not use it properly, not...

I meant to say - Is there a way to set a file and location name for a report that prints to CutePDF, not CuteFTP, from VB Sorry Thanks

I'm trying to run the report from Vb code. Is there a way to set a file and location name for a report that prints to CuteFTP from VB - something like: With Form1.CR1 .DataFiles(0) =DBPath 'database path C:\TestDir.ReportFileName = RptName 'report name - Report1.rpt .Destination =...

It worked for me too. Thanks a lot

Hi guys I'm using CR6 and need to export reports into pdf format. Does anybody know the way to do it or maybe a freeware that works with VB or just on its own and does the conversion? Thanks Denko

Hi I need to import a table from one Access database into another using VB5? Thnaks

Thanks a lot - it worked

Hello, How can i replace one line in the Text file with another without deleting any other lines in the file? Example: F444AF02050 03/05/31 09:56:19 188579Y101 XXX 88579Y10118M 188579Y101 BBB 88579Y10118M 188579Y101 ZZZ 88579Y10118M Need to replace date in the first...

Thanks a lot man - this is what I need

Hello What control can I use to browse for a Server/Share name? The same way I use DriveListBox and DirListBox, but they do not allow browsing through my network? Thanks

Thanks