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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: SHardy
  • Content: Threads
  • Order by date
  1. SHardy

    How do I code this BAT into VBS?

    Hi, I am in the process of setting up a new Business Objects repository, as a replacement for the existing one. This needs to be rolled out to all of our Business Objects users as transparently, and as smoothly, as possible. I started writing a script to update all the necessary files on each...
  2. SHardy

    Acessing User Folders via Batch File

    Hi, We have recently migrated from NT domain to Active Directory. At the same time everyone's network user IDs have changed. For example: - my old login = SHardy - my new login = BRO_SHA Now, windows appears to have remembered the association of my old ID. So (for example) instead of...
  3. SHardy

    Bus Obj 6.5 - Saving to Excel - Long Cells

    Hi, One of our users has been having trouble saving a Business Objects 6.5 report to Excel. When refreshing and saving the report, the following is returned when trying to open the Excel file: "Microsoft Office Excel File Repair Log Errors were detected in file 'C:\ReportName.xls' The...
  4. SHardy

    SQL Server 2000 - Active Directory Migration

    We are shortly going to be migrating from NT domain to Active Directory. We are running Windows Server 2003 & SQL Server 2000. Most of our SQL Server applications are using Windows authentication/ passthrough. However, I believe that we may use some SQL authentication (at a sys admin level)...
  5. SHardy

    "IF EXISTS..." against remote database

    Hi, I was trying to perform a one of task to gather information from LOADS of tables from two different SQL Server 2000 DBs. They are both similar, but one is the backend of a LIVE system, the other is the backend of a TEST system. As such, there are likely to be several structural differences...
  6. SHardy

    USB 2.0 Problems - XP Home SP1

    Hi, I am having problems with a USB 2.0 Card installed in XP machine. Technical details as follows: O/S: XP Home SP1 (build 2600) Motherboard: MSI MS-6558 1.0 (SiS Chipset) Onboard USB 1.1 Controller: SiS 7001 PCI to USB Open Host Controller PCI USB 2.0 Card/Controller: ALi PCI to USB Open...
  7. SHardy

    Navision - Importing Data from Excel

    Version 3.70.B When importing data from an Excel file, is there a way to get Excel to return the character length of the cell value before trying to assign the value to a variable? The problem that I have is that if a cell contains more than 1024 characters then it will bomb out with out...
  8. SHardy

    Excel 2003 - Open File / Suppress Macros

    When opening an Excel 2003 file via VBA, is there a way to tell it to open with macros disabled? Disabling via Excel's options is not an option for various reasons. Thank you
  9. SHardy

    Business Objects 5 - Conditions Over 2 Data Providers

    I have a BO report with two data providers. The first is a BO query, with a condition included that asks the user to select one or more "region codes". The second data provider is a freehand SQL query. Is there a way that I can apply the same region code(s) as a condition in the SQL provider...
  10. SHardy

    BO v5 - Report Maps

    Hi, I have areport in Business Objects v5 that currently has sections (in this order) for area, salesperson & week number. I need to have the week number as a section, rather than a break, to enable me to have a week specific pie chart alongside each week's table. However, I would rather not...
  11. SHardy

    Batch File - Copy Shortcut to User's Desktop

    Hi, I have a batch file to be run by certain users here to update certain files. One of the files that I want to copy is a shortcut to be copied to each user's desktop. What is the variable to be used for the current username? How do I use this to copy the shortcut to the user's desktop within...
  12. SHardy

    Wordnet Voice Recorder

    I am not sure if this is the correct place to post, but it seemed to be the most suitable forum that I could find. We have a RACAL (now NICE) Wordnet Series 1 voice recorder. Ancient I know, but we've had it years and it does what we need. I am in the process of writing up some documentation...
  13. SHardy

    Outlook2002 - Moving Sent Items

    Hi, I am using Outlook2002 as my email client. For a while now my received items have stayed in my inbox, and my outgoing items have stayed in my sent items. As these were getting quite full, and awkward to find things, I decided last night to have a tidy up. I set up some new folders that...
  14. SHardy

    Word97 - Removal of VBA

    I have a Word97 document in which I had written a VBA procedure to perform a specific task. This was just a one off run. I then removed all VBA code, as I didn't want to send the document out with macros in it. However, despite having deleted all modules and all code, when the file is opened it...
  15. SHardy

    Outlook97 to Outlook2003

    Hi, At home I have been using Outlook97 for some years. However, I have a copy of Outlook2003 (I think. Could be 2002.) and would like to start using this instead. If I were to install this over the top of 97: 1) Would it keep all the settings for the different email accounts that I have...
  16. SHardy

    Word97 - Auto change format

    I have a word document that someone has been through and highlighting items by changing the font colour to red. Before issuing a copy of this document, I need to change the formatting of all these highlighted bits of text. In effect going through the whole document and wherever the background is...
  17. SHardy

    File Associations/ Image Viewer

    We have a user here who, for some reason, does not have Imaging for Windows installed. She has NT4 SP6. She needs to view DCX & TIF files. 1) She tried opening a TIF file, and somehow managed to associate it with Adobe Reader. I need to remeve this association, and associate with an image...
  18. SHardy

    Citrix does not connect

    Hi, We have an external client for whom we provide reporting via an Acces DB. This is setup as a Citrix app, which is then accessed through our secure web site using the Citrix ICA Client (version 7). This client has been accessing these reports without problems for sometime now. However, now...
  19. SHardy

    Word97 - Paper Size Problem

    Hi, Bit of a strange problem here. We have a mail merge document that is launched from an application that runs through a Citrix session. This means that ALL users use the same source document. Also, as it runs through Citrix, it is opened for ALL users in a Word session on the Citrix server...
  20. SHardy

    Access97 - Remove Menus in Print Preview

    I have an Access97 app, in which I have hidden the standard menu & toolbars. I have a custom menubar that is used throughout. However, I have only just noticed a potential problem. In the app, it is sometimes necessary to print preview reports. When in the print preview screen, another menu is...

Part and Inventory Search

Back
Top