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

    Pivot table -HELP NEEDED URGENT

    Hi all, I use access for my database and tyr to create a report in Excel with pivot tables and pivot charts.My problem is th pivot table does not resfresh to reflect the changes in the data source ,even after I ticked refresh on open in the data options tab in the table options. The flow is...
  2. mmcg

    Hi all, I have a query like this

    Hi all, I have a query like this sqlq = "SELECT Customers.CompanyName, Category.CategoryName, Customers.Area, Employees.FirstName, [Order Details].Quantity*[Order Details].UnitPrice, Orders.InvoiceNumber, [Payment Methods].PaymentMethod, Payments.PaymentAmount, Payments.PaymentDate...
  3. mmcg

    Help neede Urgent

    Hi all, I am using Access database and through VBA Coding I retrieve results of a SQL query into Excel.My problem is when I use a SQL Query with GROUP BY claus I get an error similar to [Microsoft][ODBC Microsoft Access Driver]You tried to execute a query that does not include the...
  4. mmcg

    Help needed urgent

    Hi all, I am using Access database and through VBA Coding I retrieve results of a SQL query into Excel.My problem is when I use a SQL Query with GROUP BY claus I get an error similar to [Microsoft][ODBC Microsoft Access Driver]You tried to execute a query that does not include the...
  5. mmcg

    retrieving recordset-help needed urgent

    Hi all, I am unable to retrieve recordsets (Connected to Oracle 9i) but the PL/SQL procedure is getting executed(all the delete and update queries are working fine).If I try to access the values in the record set I get an error: Operation is not allowed when the object is closed. The...
  6. mmcg

    Calling PL/SQL procedure in ASP--NEED HELP URGENT

    Hi I am having a problem in opening the recordset as a result of the following ASP code calling an ORACLE procedure Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "DSN=****;UID=####;PWD=&&&&" Set Comm = Server.CreateObject("ADODB.Command")...
  7. mmcg

    Calling PL/SQL procedure in ASP

    Hi I am having a problem in opening the recordset as a result of the following ASP code calling an ORACLE procedure Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "DSN=****;UID=####;PWD=&&&&" Set Comm = Server.CreateObject("ADODB.Command")...

Part and Inventory Search

Back
Top