Hi Seth,
It seems when the form is first opened the hotkey is OK but once the focus goes into a tab the hotkey functionality 'ceases to exist' or at least that is what I have found. I suppose it depends on the form.
Anyhow, with earlier versions of Access 2010, hotkeys and tabs just don't mix.
PGAC
Last Activity: Aug 4 '12, 10:19 PM
Joined: Jun 23 '12
Location:
-
Do you use tabs on the form with the command button? I heard and know first hand that in earlier versions of 2010, tabs seem to interfere with hotkeys (interfere meaning non-functional).Leave a comment:
-
I suppose you could try using an IIF in the report's underlying query:
This returns a zero-length string if the grade report is zero.Code:[Grade Report Calc]: IIF([Grade Report]=0,"",[Grade Report])
Leave a comment:
-
Why not use the EmailDatabaseOb ject macro command on the form's after update (just don't specify an object to send).Leave a comment:
-
If you modify the form's recordsource to include the field from the related table, then add this as a field to the form you are using, you should be able to include it into your email.
In you macro, update the Body field to:
I have done something simliar in the past, emailing from a form used to manage contacts and used fields...Code:="your message" & Forms!FormName!FieldName & "your message"
Leave a comment:
-
Hi ariful alam,
I can think of two ways to get what you want but there is no simple solution that I can think of for what you are asking for.
First Way
=========
If trans_id is an interupted numercial sequence then you could create a query from the trans table and add a calculated field:
trans_id_previo us: [trans_id]-1.
Save this query. Create a new query which uses...Leave a comment:
-
Hi ahd2008,
Why have a default value of 0%? Why not use a Null value to indicate an unstarted task? Try taking away the default value of 0% and see how that works, that way you would not need some code to "sort out" the data. You would have to remove all those 0%s that correspond to unstarted tasks from the relevant tables though.Leave a comment:
No activity results to display
Leave a comment: