Search results for query: *

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.

Addy, Thanks for the input. My only question I suppose is, short of using system security, what's to stop a user unhiding the database window and still accessing the tables directly?.

Does anyone know how I can open a table view and prevent users from entering information in a column. I did initially place the tables on a SQL server and do a column lock but although, in pricipal, it works. It's not user friendly. What I want is some people to be able to edit the entire table...

PaulF: None of the references had missing in front of them. AppStaff: This problem is happening after the databases have been converted.

Thanks for the reply. Unfortunately, DAO 3.6 is already as far up the list as it will go. Still having the problem though.

Hope you can help here people. We have recently upgraded all out workstations from Access 97 to Access 2000. The problem we are now experiencing, on most of the databases is that the find function doesn't work. In some cases, we click on find and the dialog box appears but the "Look in"...