Record username of last modified when query is edited

[jehanim009]

Hi,

I've used the fOSUsername() macro to record usernames easily in forms previously.

However, I now need the following:

a) Generate a query via a filtering form.

b) The query should have a checkbox field which has to be ticked if a record is valid.

c) The username of the person ticking each record should be recorded in a separate field.

I've completed parts a and b.

However, I'm not sure if adding a macro into a query in order to complete part c is possible.

Please help!

 

[sneuberg]

Let's say for example the name of control source (field name) for your checkbox is "ValidRecord". You could display the users name in a query with an expression like:

FieldHeading: Iff([ValidRecord], fOSUsername() , Null)

if the fOSUsename function is public. If it isn't I'd just make it public. Of course in place of it you could put in a reference to the form's textbox that contains the user name.

 

[HiTechCoach]

Hi,

I've used the fOSUsername() macro to record usernames easily in forms previously.

However, I now need the following:

a) Generate a query via a filtering form.

b) The query should have a checkbox field which has to be ticked if a record is valid.

c) The username of the person ticking each record should be recorded in a separate field.

I've completed parts a and b.

However, I'm not sure if adding a macro into a query in order to complete part c is possible.

Please help!

Use a form.

Queries do not have vents, but form forms do.

I find it best to only let uses edit data on a form, never in a query or table. I gave seen to many user easily destroy data while in a query or table.

 

[edwards142]

Thanx for giving such useful suggestion

 

[HiTechCoach]

cross posted here: http://www.accessforums.net/queries...ified-when-query-edited-56727.html#post302753

Please Read: A message to forum cross posters