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

    Select Pivot chart option using VBA

    Hi, I have a Main report in an Excel sheet with several pivot tables and pivot chart where common dimensions are available. To prepare a summary of some combinations of Product and Markets, I need a macro that will select options in the different pivot charts, makes a copy in a blank sheet and...
  2. ecompa

    write new table from recordset (query on DB2 data)

    Hi, I've been working with a vba code to access dat from DB2 into Excel, but I need no to adapt this code to write data in an Access table. Public Function GetData() As ADODB.Recordset StrQuery = "SELECT * " StrQuery = StrQuery & "from Table " StrQuery = StrQuery & " with UR ;" Set GetData =...
  3. ecompa

    error 2147467259 - vbscript queries on Access DB, client-side

    HI, I am working on a tool to share data in my department. The tool is working fine for me and some colleagues, but for others it is not working. The error code is -2147467259, and the description mentions that the file is already opened exclusively by another user (which is not the case). The...
  4. ecompa

    error 2147467259 - vbscript queries on Access DB, client-side

    HI, I am working on a tool to hare data in my department. The tool is working fine for me and some colleagues, but for others it is not working. The error code is -2147467259, and the description mentions that the file is already opened exclusively by another user (which is not the case). The...
  5. ecompa

    SQL new column = difference of two months

    Hi, I've a table listing data for different clients over the last two months client year month Prod depot act instr abc 2004 Dec BLUB 120 13 5 abc 2004 Dec TOC 110 10 4 abc 2005 Jan TOC 125 10 4 xyz 2004 Nov TOC 15 2 1 xyz...

Part and Inventory Search

Back
Top