Replies

So I just gave it a shot. Properties set to update on file open. Changed the criteria to return different data. The advanced filter did not update. I had to manually refresh the filter. So, is the best I can do a macro button (or something) that will enable the report viewer to see updated data from the filter?

Thanks for the help. I do have another question though. The source of my data is a query to a database with a work date parameter that is setup to refresh on open. Will this advanced filter automatically adjust at each update?

This sounds like a great option. Even if I can’t track the change due to the complexity, I can gather as much information as possible. When you said to create 2 fields: record creator and date/time of creation, what is the name of the fuction for these 2? At least this way, I can generate a report for the managers to follow up on abuse of the system.

Sorry, I assumed the implication of already having Access security. Based on other threads that both you and Wendell have responded on, I have setup security with 3 group levels (admin, mgr, user) and about 30 users. I have that up and running successfully, (THANK YOU!!!!!) and what I want to do now is identify security breaches (in somewhat of a fashion). I want to identify the original user that setup the record, the name the user applied to the record, and the manager’s ID that approved the record. I want to make sure that users are not entering data under someone else’s name.

I know it all me. I can’t get the query process to work. I am missing something out of it and I spent hours today trying to figure it out. During my review is when I came across the filters situation and thought I would give that a try instead. I am really stuck on this one.

I am banging my head on this one. Can’t I just use the “On Apply Filter” function built into the form? I have been trying it unsuccessfully, of course. I am trying what seems logical to me: =[Form]![Name]=CurrentUser(), where [Name] is the main field on the form. The user selects their name from a pull down list to update their information for the day. I am just saying that I want the form to not show any records where the name on the record is not the name of the current user. Why can’t I get this?????

The manager was going to update each user’s calls individually each month. One record, per user, per month. What their looking for is a form that will list all users in a table and allow the manager to update only the call info. The user info would be fixed. But I want to be able to report on each user separately.

I have workgroup security setup with approximately 30 users. How would I go about setting up currentuser()?