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!

Recent content by maccten2000

  1. maccten2000

    Parsing Date

    Hi I have a SQL Statement where i want to set the dates to be variable. The format of the dates appears to be timstamp i.e. MM/DD/YYYY HH:MM AM/PM I am using the code below database.col1 > = CAST (CAST (CURRENT_DATE - interval '7' DAY AS DATE FORMAT 'DD/MM/YYYY')||' '|| CAST('09:00' AS...
  2. maccten2000

    Basic VBA Question

    Hi All, Basically I have macro that calls a function I want to make this function as generic as possible for maybe someday being able to use it in future for something else I want to pass in a variable of cell ranges like for example "A1:B2" I then wish to subtitute the static "A1:B2"...
  3. maccten2000

    VBA Power Point Changing X Axis Labels

    Hi All, Just in case anyone eas following this thread I found the answer here on MS's website http://support.microsoft.com/kb/267974 Thanks again
  4. maccten2000

    VBA Power Point Changing X Axis Labels

    Hi Skip, I have been told that we have to use the Chevrolet as its being used for all of our reports. This is just the first one that we are trying to automate. Do you know how to edit the labels with VBA? Thanks
  5. maccten2000

    VBA Power Point Changing X Axis Labels

    Hi Skip, Thanks for the quick response. We are stuck with Powerpoint 2003 so im afraid I have to use the MS Graph Library to achieve this although im open to correction Thanks
  6. maccten2000

    VBA Power Point Changing X Axis Labels

    Hi All, I have a report i am trying to automate. In essense it pulls data from MS Access, generates a pivot In Excel whose values i will then use to update several graphs all sitting behind a button. I have encountered a problem i was wondering if you could help me with The X-Axis on the...
  7. maccten2000

    Kill Excel Object Brio 6

    Hi All, I have the following function which I put together by skimming this very helpful folders. Basically from my understanding is the function creates a vbs script and kills the last Excel process which is perfect for my needs. My problem is it doesn't seem to activate the script on the PC...
  8. maccten2000

    VBS Script Killing Excel Process

    Hi MrMovie, Thanks very much for your feedback I have fixed the syntax error you have pointed out but i have another error at line 7 Char 19 where it is expecting an end of Statement. I have put in a ; but that doesnt4 seem to make a difference I was wondering if you could see the issue. I...
  9. maccten2000

    VBS Script Killing Excel Process

    Hello All, I have a VB script which deals in Processes. Basically we are using a third party application that allows you to interact with the Excel object but refuses to kill the object once it has quit excel. I have founda VBS script to fix this problem but would like someone to tell me the...
  10. maccten2000

    VBS Script Progress Bar

    Hi All, I have recently tried with the help of these forums to create a script that simply backs up a folder giving the user feedback by creating a progress bar. My script is below. The error i am getting is on Line 51, char 4. Object required NS. The error is puzzling because d'ont I create the...
  11. maccten2000

    Excel: Nested If Statements

    Yup, Terribly sorry about that, It only came up after an additional request
  12. maccten2000

    Excel: Nested If Statements

    Hi Skip, Thanks for the prompt reply. However it is possible for A1 to have a value other than a number which is why i need to get the three conditions into the nested If statement If i wasnt using conditional formating The formula would be something like below...
  13. maccten2000

    Excel: Nested If Statements

    Hi All, I have an excel worksheet that i want to colour code cells based on the values in them. So lets take cells A1 & B1 as examples. Effectively what i want to say is If value in A1 is 0 AND the value in B1 contains a value AND this value is a number Conditional Format it Yellow Can...
  14. maccten2000

    SQL Error Handling

    I must apologize, The table is transfered into the Access Database ' Link Files DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strImportTblNm, mstrXlsFile, True ' Transfer Selected Columns From Linked Table into Specified Table strSQL = "INSERT INTO tblMCountPickIn ( SpecRecID...
  15. maccten2000

    SQL Error Handling

    Hi All I have code which imports an excel sheet into a MS Access Database as a linked Table. I then have a Query which selects all the items in the table and inserts them into another table. My problem with this is the user gets to select the xls sheet they wish to import. The SQL statement...
See more

Part and Inventory Search

Back
Top