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!

Recent content by Eradic8or

  1. Eradic8or

    Excel pivot tables

    The reason I am using this method is that I want to return all the records in the stored procedure and then present the user with 5 buttons which select a different criteria. Rather than change the SQL and keep interrogating the database, I felt it would be easier to pull back all the records...
  2. Eradic8or

    Excel pivot tables

    Thanks for that. I will try tomorrow and let you know how I get on.
  3. Eradic8or

    Excel pivot tables

    I cant unless you can use a SELECT statement around an existing stored procedure. I am pulling in the recordset from an Oracle stored procedure of which I have no access to amend. The DBA won't change it either because it is used to other things.
  4. Eradic8or

    Excel pivot tables

    You may well be right, unfortunately, I still don't know how to resolve it :-)
  5. Eradic8or

    Excel pivot tables

    The ability to refresh from the menu is greyed out when I just open the workbook. The only way I can get new data in is to run the code. I assume this is because the pivot table is unbound as I create it programmatically.
  6. Eradic8or

    Excel pivot tables

    I tried as suggested with rsTemp.Filter = "HospitalCode='EDI'" This made no difference. And no, the table does not refresh on close and open as I have the code attached to a command button the worksheet.
  7. Eradic8or

    Excel pivot tables

    Thanks for replying but I still think I am missing something. I thought the filtered recordset is what was being used to populate the Pivot Table as in the code below. 'Filter records depending on choice rst.Filter = "HospitalCode LIKE 'EDI'". <- This redeuces the number of records. 'make...
  8. Eradic8or

    Excel pivot tables

    Hopefully, this message is in the correct forums. I have pondered over this for 2 days now and cannot find a resolution. I have a oracle stored procedure which I am pulling into a ADODB recordset. I then create a pivot table based on the recordset. This all works fine. If however, I apply a...
  9. Eradic8or

    Access 2000 replication

    Can someone tell me if I can accomplish the following? I have a Access 2000 database which has very tight network permissions on it. I want to create a replica of it where everyone has full read/write access. The problem is I don't know much about replication. I want to be able to do...
  10. Eradic8or

    Which event fires?

    Ok, thanks. In that case, I will declare a static variable that does a record count on requery. That way, when a new record has been entered, the value will change.
  11. Eradic8or

    Which event fires?

    I have a ASP form that writes to a Access database. On another machine, I have the database open at a form in datasheet view. By setting a timer to do a requery on the form, I can see when new records are enetered. However, I want to do a sequence of events when this happens but I can't which...
  12. Eradic8or

    Trigger event on Access table

    fneily, Can I ask you what you used to check when a new entry was added to the table. Did you have to use a form?
  13. Eradic8or

    Trigger event on Access table

    Just to clarify here exactly what I want, although, I think I have found a solution. I have an assistant in Edinburgh that has the access database. What I am trying to do is that if a person (in Inverness for example) opens up the web front end and raises a work request, that entry is written...
  14. Eradic8or

    Trigger event on Access table

    I don't have any forms at all. What I have a is a web based front end that I have written which directly adds a record to the dataabase table. What I am trying to is inform the user when a new record has been written via the web. I expect if I can't do triggers, I am going to have to convert...
  15. Eradic8or

    Trigger event on Access table

    Is there anyway I can trigger an event whenever a record is added to a Access table?. All I want is a msgbox that says a new record has been entered.
See more

Part and Inventory Search

Back
Top