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: *

  1. ecompa

    Executing Update query thru code (passing parameters)

    I never worked using this way, but what you could do also is to define a variable for each of your form inputs and run the query inside the code, as a string where the two parameters are the variable. Now, I had already that kind of message, when something was wrong in the resulting query: a...
  2. ecompa

    Select Pivot chart option using VBA

    right to the point. Excellent. Many thanks !!
  3. 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...
  4. ecompa

    write new table from recordset (query on DB2 data)

    HI PHV, well to make a long story short, that is the way I was working until now. But for technical reasons it won't be possible in the future (due to change in the way IBM handles the ODBC link + question of privilieges I have on DB2). So I really need to feed a table with the recordset...
  5. 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 =...
  6. ecompa

    Query MSSQL Database with VBScript

    Hi digiman1134, with the OLEDB syntax that you are using, I think you need to replace UID and PWD by a the full name as shown below "Provider=SQLOLEDB;Data Source=server;User Id=xxx;Password=yyy;" The site http://www.connectionstrings.com can help you. Also you could use a recordset object...
  7. ecompa

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

    HI Tsuji, thanks for this[thumbsup2]. I'll give a trial. But I agree with you: surfing around on the internet, I've found quite a lot of different reasons for this error code...[sad] I'll let you know. E.
  8. ecompa

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

    Tsuji, sorry, you seems to have more technical skills than myself. The fact is that I can't install whatever I want, as we are working in a Citrix environment (Windows 2000 advanced servers, Citrix XP metaframe). The application has worked properly with the old, not supported, connectionstring...
  9. ecompa

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

    Thanks for your proposal Tsuji, It is not working for the moment unfortunately, but apparently because of the wscript.sleep command. The error message is 424 Object required. Do I have to define this object in the beginning of the script ? How ? E.
  10. 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...
  11. 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...
  12. ecompa

    Put an MDB backend in a hidden folder on server

    I am facing a similar problem. I don't use an mde but let end-users run queries in a vbscript client-sde interface (only IE is used in the company). The problem is that they only have a read access on the folder where the db are stored, and they can't access the data as the ldb cannot be...
  13. ecompa

    SQL new column = difference of two months

    Sorry for the typo mistake(data give me 12 month of history) and for not being very clear. To give you a bit of context, I use VBA to read data on DB2 and automatically generate some Access tables each month that will be used in VB script queries on an intranet. These final table should be as...
  14. 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