Search results

Fabulous. Thank you!!

Hey all! I'm trying to make a query off another query where it will give me a list of unique managers, and the number of sales reps underneath them. I'm also trying to set it up to omit two sales reps who appear under everyone (hold placements). Here is what I have: SELECT...

Of course I would have never thought to look through the sample databases :) I didn't know it was called Audit Trail. I've implemented it and it works like a charm. THANK YOU!! For any future viewers who are looking for the code, here it is. Just create a table called tblAudit with the...

That is correct.

Actually, what I don't understand is how to implement it. I'm still a newbie when it comes to coding. The user wouldn't be entering a new record, so that portion wouldn't be necessary. What I've gotten thus far has been somewhat complex. The user opens the database, enters some information into...

Well the issue is that the filtered subform will contain many records and I only want to mark the changed ones as modified (not all the records in that filtered subform).

Anyone know how I can accomplish this?

I have a subform that is filtered by a textbox on the main form. Is there any way I can add a timestamp to a record on the subform when a user changes anything on that record? I've tried the Macro that is listed on Microsoft's website regarding timestamps, but I had serious issues implementing...

I changed the filter to what you had suggested before: strFilter = "[Rep Number] = " & Me.RepNumberField & "'" & _ " AND " & "[UserName] = '" & Me.UserNameField & "'" RepReassignmentSubform.Form.FilterOn = True This does not stop the filter from "refiltering"...

If the change no longer exists in the subform, I cannot export those changes easily. My goal is the manager will reassign in the subform, click a button, and it will email me the changes so I can deal with it on my end.

I'm not certain how that would help me filtering. I have a table with all the reps listed (separate from the assignments table). My issue is keeping the subform from filtering out the change as its made. I want to be able to filter a subform by rep number and then change them on the subform and...

The ex-employee is only listed in that subform(table), so if you removed him from that subform, he would be gone completely. If you removed the filter completely, it would show all territories under all managers and who is assigned to that territory. The current dataset only includes current...

Got it! Thank you!

That is correct, that ex-employee would not be linked to anyone.

Yes. Basically its taking out the ex-employee's number and replacing them with a new employee, which is under the same manager.

I've edited the filter to: strFilter = "[Rep Number] = " & Me.RepNumberField & "'" & _ " AND " & "[UserName] = '" & Me.UserNameField & "'" RepReassignmentSubform.Form.FilterOn = True The UserName field is based off the user's computer login. There are about 12...

I'm filtering from the main form. But I'm not sure how to go about doing this.

Thanks for your reply, but its a subform I want to attach in the body, not a textbox.

Thank you, but I'm not sure I follow... The filter is in a string (strFilter). How would I concatenate the filter to the saved values?

Hi all! I'm trying to do a lookup between two tables, whereas table A includes the product ID and table B includes the price. Is it possible to create a field in table A with a DLookup function on the product ID to get the product price from table B? Whenever I try to type in the DLookup...