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 Chriss Miller 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. 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...
  16. maccten2000

    Creating a publisher for your VBS script

    Hi All, I have created a VBS script which is used for backing up peoples folders at the end of each night and moving them to an internal server within the company. All works well but i was wondering does anyone know how to get rid of the message asking the user are they sure they wish to run a...
  17. maccten2000

    Building a String From A Recordset

    Hello Chaps, I have a piece of code that loops through a recordset and builds a string. The recordset contains a list of errors on a production line for a particular manufacturer. My code is below. Do Until RS1.EOF ProdStrMsg = "Item: " & RS1!Code & " - " &...
  18. maccten2000

    Locking Columns

    Hi kjv1611 I have tried this. Unfortunatly once you select that the user cam insert columns, they are able to insert columns anywhere on the sheet not just in the unlocked cells. Once the Column has been inserted into the restricted section you are not allowed to edit it but i would prefer if...
  19. maccten2000

    Locking Columns

    Dear All, I have a spreadsheet where i need to set that the user is unable to insert columns in one part of the spreadsheet but is able to insert columns in another part of the spreadsheet. For example Columns A:D you are not allowed to insert the columns and anything after that you are Does...
  20. maccten2000

    Outlook Object

    Hi All, I am currently trying to create a button in Outlook that sets the font, size and colour of text when the user is replying to the message. This requirement came up when people starting adding fancy stationary that caused my user when replying to pick up the senders current font settings...

Part and Inventory Search

Back
Top