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!

  • Congratulations Mike Lewis 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. LearningSql

    Month "Name" from Date in SSIS Expression

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

    Month "Name" from Date in SSIS Expression

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

    VB / Programmatically select all Report Tabs

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

    Unable to Refresh using Refresh button / Programmatically

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

    Unable to Refresh using Refresh button / Programmatically

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

    Calling an Access Sub Procedure from VB6

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

    Calling an Access Sub Procedure from VB6

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

    Run SubProcedure in Access97 from VB6

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

    final completion: software is already installed (27148)

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

    Run SubProcedure in Access97 from VB6

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

    final completion: software is already installed (27148)

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

    Save in *gasp* Excel with Formats

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

    Save in *gasp* Excel with Formats

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

    Save in *gasp* Excel with Formats

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

    Save in *gasp* Excel with Formats

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

    Folder Redirection Node Missing

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

    Max Length of SQL Statement using CFQuery

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

    Maximum Ram Utilized

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

    Access utilization of 1-4 Processors

    Thanks to both JRBarnett and foolio12 for the information! I appreciate the feedback.
  20. LearningSql

    Access utilization of 1-4 Processors

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

Part and Inventory Search

Back
Top