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: TimRHSD
  • Content: Threads
  • Order by date
  1. TimRHSD

    CreateSQLCursor Properties

    Does anyone know how to check the status of a cursor? I can't find help on this anywhere. This is updating a table. When I do a count on the table I only get 96 people and I should get 134. My assumption is there are a bunch of people missing a record altogether so I want to see who they...
  2. TimRHSD

    Locating Desktop element

    Hi, I want to put a file on a user's desktop, but I can't seem to find how to access that environment element. Seem to recall seeing a post in this group about it, but can't find it. Any help would be appreciated. Thanks, Tim Tim Rutherford www.Manna-Consulting.com
  3. TimRHSD

    adodb adDecimal help

    Currently, I am putting data into an adodb.recordset. I am using a field which needs to be decimal, but everytime I use it, the right side of the decimal is '00'. e.g. 15.35 comes in as 15.00. I have spent hours trying to find an example for this. I know I need to set NumericScale somehow...
  4. TimRHSD

    SUMIF Question

    Hi, I have a column which contains totals. I want to use SUMIF and add columns which have the word 'Total' but do not also contain the word 'Revenue'. Simple data layout is as follows; Col A Col B Revenue 1 50 Row 1 Revenue 2 175 Total Revenue...
  5. TimRHSD

    ADODB sort Error

    Hi, When I try adding a sort to my adodb, I am getting an error, 'Wrong number of arguments or invalid property assignment'. I have checked all over for examples and can't seem to resolve this. The error occurs with the sort. Will someone point out what I am doing incorrectly? Thanks, Tim...
  6. TimRHSD

    Insert line on Protected sheet Error

    Hi, I am inserting a line with the following code, but I still get an error message even though I have .displayalerts = False. Any ideas or suggestions. Thanks, Tim Private Sub WorkSheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) Application.DisplayAlerts = False...
  7. TimRHSD

    Suppress VBA Window

    Hi, I am creating a spreadsheet using vbScript. The script creates a WorkBook_BeforePrint event and works fine. However, I don't want the VBA window to open when the user runs the script. Any ideas on how to suppress the VBA Window from opening? Const vbext_ct_StdModule = 1 Dim...
  8. TimRHSD

    How to supress header on first page in Excel

    Howdy! Is it possible to supress headers (e.g. LeftHeader) on the first page of a printout? The client I am doing this for is using Excel 97. Suggestions and comments would be appreciated. Thanks, Tim
  9. TimRHSD

    Merge two computers using Outlook

    Is it possible to dump my email from my laptop into my home computer? If so, how? Both versions of Outlook are set up with the same settings and accounts. Thanks, Tim
  10. TimRHSD

    How can I put a file on User's Desktop

    I am trying to put a flat file on a user's desktop. Currently, I am just dumping it in 'C:\'. The application I am using only has vbScript available. Is there a way to put it on the desktop? Thanks, Tim
  11. TimRHSD

    Killing Cached pages (I think)

    I am a newbie so I don't know if this is my problem or if I am just missing a setting. My program presents a question with a <cfloop> for the answers. The first page presents correctly. <!-- Display the Question --> 1) What color is the sky? <!-- Now display the answers. --> <pre><input...
  12. TimRHSD

    How can I create file name from date/time?

    Hi, I am trying to create a file name with an extention of YYYMMDD_HHMM. e.g. Employee.20020916_1336 Currently, when we run a global send the error messages are trapped in a file called employee.msg, which is fine unless we find we goofed on an employee and just process that one record...
    • TimRHSD
    • Thread
    • Replies: 4
    • Forum: C
  13. TimRHSD

    Search and replace

    Is there a function or does someone have one written which searches for a substring within a string and replaces it with another? e.g. MyString = &quot;MyLastName, Tim&quot;, MySearchString = &quot;,&quot; MyReplaceStr = &quot; &quot; The result being &quot;MyLastName Tim&quot;

Part and Inventory Search

Back
Top