Recent content by Eradic8or

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...

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

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.

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

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.

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.

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...

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...

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...

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.

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...

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?

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...

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...

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.