I have a secret shortcut key which opens an entry form. I want the users are
able to change this shortcut key with their own key. If the shortcut key
definition is saved in a table, how do I call it programmatically ?
Thanks.

Private Sub Work_Order___DblClick(Cancel As Integer)
   Dim stDocName As String
   Dim stLinkCriteria As String
   stDocName = "work order"

I have an action item datasheet with current work orders on it. When a
work order is clicked on i would like it to open up the work orders
form to the work order number that was clicked on. I have gotten the
work order number into a variable and the work order form open but I

OK - I am getting an odd error in my application.  I have done my
research and discovered that the error I am getting (Function is not
available in expressions in table-level validation expression) is
actually a references problem.

I'm probably trying to do the impossible here.
I want to have a union query in a combo box to select "all" AND have
that combobox filter off of another.
I can get the first part of code working, the second part of code

hi,
Let's say I have a field with this as the value:
"z:/daily/bk/DDR_DEFERM_BK.csv"
I would like to know how I can take the "z:/daily/bk/" part only.

hi,
I have the following in a module saves as Module1:
Option Compare Database
Option Explicit

Access 2003.  How can I programmatically determine if a form (say "Print All
Reports") is open?  Thanks for the help.

I am using Access 2002 my users are having some trouble with their forms it
seems that they cannot push any command buttons or move to next record or do
anything within their form.  Many of the users open other programs, excel,
word, and other software.  Many of them may have 5 ...

I need to write an IIf statement with 3 criteria and need a little help
if you could please.
If ItemType= 1, [ItemName]&[EMemo]
If ItemType=2, "  "&[ItemName]&[EMemo]

I am tring to build a expression. To changed a date color. I have a form with
a subform. The subform is a service record, which has a service date and next
service date due(1 year from Service date). The form also has a next service
date due.In the form next service date due I ...

Thanks Graham, apart from me changing some names for controls and objects. It
worked like magic. Below is the code again u gave me.
"A bit of the old Kiwi Ingenuity" :-)
Now I have a query that incoporates planting information, application of

At least I think it may be referred to a as a floating decimal.  I have
an input form that has a single where a user can enter data as follows:
12345 or 12345.67 or Text
When the user enters the value, he also selects a radio button

I got a text field called "Distribution" where i input names of personnel -
usually it is 1-3 persons out of 5-6 from a list, but sometimes it could be
somebody who is not in list.
I would like to introduce 5-6 unbound check-boxes on my form, clicking each

I am successfully using fRefreshLinks() to allow me to specifiy differing
databases for my application's backend.
The problem is that fRefreshLinks() always prompts the user everytime the
applicaiton starts and not only if the current backend database path doesnot