Recent content by daved

Update on progress - an imperfect but tolerable solution. I spent the last couple of days trying some keyboard hooks, They all seems to work OK in VB but as soon as I port them to Access I run into problems. I always thought that VB and VBA were essentially the same but there must be some...

Because I'm writing an EPOS system which needs to use the numeric keypad Enter as the totalize key, whereas the main keyboard Enter key is used in its traditional role everywhere else. Visualize the number pad as the data-entry keys on a cash register if it helps. The number pad number keys send...

SOLUTION NEEDED FOR ACCESS 2003/VBA, NOT FOR ANY VERSION OF VB. I need to differentiate between the Enter key on the main keyboard and the numeric keypad and obviously tried using vbkeySeparator in the form's Keypress event. However, both Enter keys return KeyCode 13. MS Q188550 (below) offers...

Incidentally, I'd wrap the dlookup in a Nz function - Nz(dlookup(....)) or Nz(dlookup(....),0) just in case MemberID is Null. Also, you'll probably need to move the quotes so they don't include MemberID, thus: Nz(DLookUp("[LastName]","tblMembers","[tblMembers].[MemberID]=" &...

The SQL error re ambiguus outer joins is caused by the 'RIGHT JOIN ((tblMembers' - it must be an INNER JOIN because otherwise you're asking the query to return all members of the right hand table. The type mismatch is because (presumably) MemberID is numeric and you've typed it as string in the...

Thanks for that, Neil - it's so obvious that I hadn't thought of it and it will certainly be the way to combine the Yes/No fields once I get the query right. However, there is still the problem of checking each account against any other similar accounts before the combine can be done. I can't...

I need to combine data from a Yes/No field such that for any instance of a Yes/True the query will show Yes (checked). Only if there are no instances of Yes should the query return No (unchecked) for the field. In addition, this rule must apply for each individual account number in a [separate]...