Search results for query: *

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

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

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

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

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

Hello All -- I'm trying to enable Folder Redirection however when looking for the node under User Configuration / Windows Settings I only see 4 of the 5 Nodes (Remote Installation Services / Scripts / Security Settings / Internet Explorer Maintenance). Does anybody know how to get the Folder...

Hi All -- Is there a Maximum Length for a SQL Statement to be passed using the CFQuery tag? I'm looking for documentation out there on the web and have come up with nothing. I have CF6.1 and MSSqlServer2K -- all the appropriate patches etc. Thanks in advance to all that answer. PJ

Hello All -- [peace] Simple question on maximum limit for MSAccess 2000 / 20002 / 2003. Is there a limit on how much RAM MS Access can/will use? Or will it consume all RAM available if it needs it? Any documentation or other threads would be extremely helpful. I've searched to no avail on...

Hi All -- I searched through many of the Access postings for any information on this one. I could not find anything that related directly to my question. Does anybody know of any "documentation" on Processor Utilization by MSAccess2K (A2K)? I am trying to document (by anybody outside of...

Hello all -- Is there a way to modify the way Outlook prints out a calendar? What is happening is that when I print out 1 month on 1 page in Calendar it shows me the current month (assume March 2004) as well as in the top right corner 2 additional months. Interestingly the 2 months are the...

Hello All -- I'm new to Business Objects and wanted to ask about where the processing of variables actually occurs AND how to optimize long running queries. I am running BusObj 5.1.6 with multiple universes of data -- but only using 1 universe at a time. I've created a few reports to bring...

Hello All -- Thanks in advance. I've searched through the Help Menus / Web / Keyword Searches and have not found anything to assist. I may be searching by the wrong term. If there is another post on this just point me in the right direction. I have Excel 97. Working on a Macro to create a...

Good day to All -- First off Thank You for all the advice everybody has given to me. I need to start to mark posts as Helpful as I have not given my dues to those that have assisted me. My apologies for that -- I'll do better. Second -- I do not know if this is a post for this Forum and/or...

Good day to All -- First off Thank You for all the advice everybody has given to me. I need to start to mark posts as Helpful as I have not given my dues to those that have assisted me. My apologies for that -- I'll do better. Second -- I do not know if this is a post for this Forum and/or...

Hello all. I am trying to figure out how to do this correctly. I have set the permissions of 2 tables in SQLServer 2000 to "SELECT" only (for both public and 1 user using SQL Server Logon). I have set the USER permissions for SELECT only also. When an MSAccess97 application is...

Hi all -- I've searched through the forum for how to modify a Scheduled DTS Package. I even looked into BOL and SQLDTS.COM. I must using the wrong search term or am just missing it. How do I modify or stop a DTS Package that I have scheduled to run every day at 6AM? Thanks to all.

Hello all -- thanks for your assistance on this one. I am trying to Append data from Table A to Table B. The data from Table A is a Null value. The field the Null value is appending to in Table B is a DateTime datatype. ============================================= Example: A.ShortDateData...

Hi all -- I'm still learning, fun but frustrating -- thanks in advance. I have a Master table with a Primary key consisting of 3 fields. I have incoming data on a daily basis that will replace duplicate records. I would like to follow the process below -- I'm still in development so this can...