Recent content by LearningSql

Thank You. I will try the code and let you know if I was able to get it to work. Much obliged!

In SSIS I am dynamically changing the connection string to point to the correct file to load each night. Each night, the filename changes to reflect the current day. For example, a file processed tonight (10/22/09) would have the name 22Oct2009.txt In Connection Manager on my source file...

Hello all -- - BusObj 6.5 SP2 Is there a way to programmatically select all report tabs at once? Manually I can click on the 1st tab to activate it -- then select the last tab (lets say I have 3 report tabs) -- and it highlights all 3 report tabs. I've looked through the following VBA...

Thanks both to Steve and blom0344. Being the "technical" person that gets the request to "research" the errors by clients, I am usually half-full of information but I always try to check the obvious items. My dilemna usually is that the "user", and those "power users" that say they know...

Good day to all -- Has anybody had any problems refreshing either using the Refresh button or via API using the .Refresh command? I have searched the web and within Tek-tips but have not seen anything conclusive. The main issue that is occurring for the user-base is that using either...

Hi PH -- No I have not. Let me look into that piece and see what I come up with. Geez....another method.... it's all good. It can be quite maddening at times! Thanks again. PJ

(This was originally posted in the VB6 forum however I was told that I may get a better answer here. Thanks all in advance!) Hello All -- I'm not a full fledged VB6 programmer but I can make my way around most things. I'm more of a know-enough to get around many programming platforms type of...

Thanks Ron. I'm curious about posting in Forum705 because it deals specifically with Access Modules where I, unless I asked the wrong question, I needed help in finding out how to actually call the Access module from a VB6 application. I'll still post there and see what turns up. Thanks...

OK -- I found the solution. Interestingly, the user copied over to their "My Documents" their Business Objects files ****INCLUDING**** the busobj.exe and associated runtime files. Even though I removed the software via Uninstall, cleared the Registry (manually) it appears that the Business...

Hello All -- I'm not a full fledged VB6 programmer but I can make my way around most things. I'm more of a know-enough to get around many programming platforms type of person....so please bear with me on this one.... Is it possible to have a fully working SubProcedure in MSAccess97 run by a...

Hello All -- Working on a new laptop that had Business Objects 5.1.8y. Had to de-install and add 5.1.8x. I had used Start, Programs, Control Panel, Add/Remove Programs to remove 5.1.8y. Rebooted, tried to install 5.1.8x but program report message: "final completion: software is already...

BTW -- Version 5 answered my question! Thanks again.

Duh....i meant 5.1.6...duh....that's the right version. Thanks again.

I am using v6.1.3 (I think). But for sure Version 6.

Hello all -- I have a crosstab built based upon table data. Unfortunately, my superiors are not really Business Objects savvy [thumbsdown] rather they are Excel savvy [thumbsup2] . I have unsuccessfully [sadeyes] tried numerous times to try to save the Crosstab as an Excel file with the...