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, 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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 & " - " &...
  11. 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...
  12. 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...
  13. maccten2000

    Run Time Error 3073

    I have the following code ' Set Variables strSQL = "UPDATE " & strQueryDef & _ " SET " & StrColDest & " = (SELECT " & StrColSrc & " FROM " & strQueryDef & ");" ' Insert Records Into Table DoCmd.RunSQL strSQL This code takes a column...
  14. maccten2000

    .GetOpenFilename

    Hi All I am trying to get a prompt in MS Access that prompts the user to select an excel file in a particular directory and import it into an access table. I have been messing around with the code below and have one issue and one question ' Declare Variables Dim Filename As Variant ' Open...
  15. maccten2000

    Unqualified References To The Application Object

    Hi, I am doing a project that involves exporting a queries Results from Access into an Excel Sheet and formatting it. I am getting an error on the second time running the code which says this Error 462: The remote server machine does not exist or is unavailable. This I have found out from...
  16. maccten2000

    The Microsoft Jet Engine does not recognize a column in a Query

    Hi, I have 2 queries, One which gives me three columns of data and a second one which inserts nulls based on an "iif" statement and giving me a new table. The SQL for the first table is SELECT DISTINCT C1.customer, C2.attributeFROM myTable AS C1 INNER JOIN myTable As C2 ON C1.Customer <>...
  17. maccten2000

    A SQL Question

    I have a SQL problem 1) I have a customer who has multiple attributes in a table 2) There is more than one customer in the table – so many customers many attributes 3) I need a query (this will involve a sub query) which will take all the customers in the aforementioned Table and spit back...
  18. maccten2000

    Transferring Data From An Oracle Database to an Informix

    Hi All We currently have a production live system which contains many tables which i need to roll up into summary tables This needs to be done so we can build reporting web pages off them and not impact the live database To do this i was going to use a stored procedure The procedure was going...
  19. maccten2000

    Simple Brio Questions

    I was just wondering 1) Does brio allow you to write back to tables 2) Can you add event handlers to buttons ie On Rollover
  20. maccten2000

    Syntax Error ON line one

    For (var i =1; i <= ActiveDocument.Sections ["Results"].Columns.Count ; i++) { ListBox1.add(ActiveDocument.Sections["Results"]columns[i].Name); } Can anyone see it

Part and Inventory Search

Back
Top