Search results

application.currentuser will give you the username of the currently logged in user. Larry

In the properties for the Combo Box control, set Bound Column to the column that holds the name. For example, if the source where the combo box gets it's data from has two fields - ID, and PlaceName, having bound column set to 1 will store the ID and having bound column set to 2 will store the...

It depends on how you implemented the audit trail. I have a separate table that contains the relevant audit data for several active tables in my database. For each record in this audit table there is a t/f field called 'Acknowledged' that I set to true after running the report on it. Each...

Set up user-level security and the user's will have to log in. You'll then be able to use application.currentuser to see who is logged in. Larry

Alternatively, you could set up a mousemove event on the area surrounding your control to change the color of the control back once the mouse moves past the boundaries of the control and into the area surrounding it. Larry

What RuralGuy said is true, so in the properties of the size and color controls set enabled to false. Then on afterupdate event of the product control do the following in code: me.color.enabled=true me.size.enabled=true Larry

I encountered the same problem recently - here's how I worked around it: dollars = Format(dollars, "$###,###,##0.00") 'dollars' is a variant to be displayed in the text box. It will properly format any amount below one billion dollars. Add more ###, for greater amounts if you need to. Larry