Search results

That's great thanks Mike; I have it working well now. Mike.

Many thanks Shadow, all working perfectly now. I wouldn't have got there without you. Mike.

Thank you Shadow! I'll try this tomorrow. Mike.

No problem! See attached - the form in question is KeypadFrm. Thanks Mike.

Shadow, I've replaced Or so that now I have (for instance) "Case vbKey1, vbKeyNumpad1". However, the result is the same. ... and yes, each button definitely has a click event; the form has been in use for a while. Thanks for all your help - any more would be welcomed! Mike.

Thanks Shadow. This is how my code looks now: Private Sub Form_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case vbKey1 Or vbKeyNumpad1 Me.Command0_Click Case vbKey2 Or vbKeyNumpad2 Me.Command1_Click Case vbKey3 Or vbKeyNumpad3...

Thanks Coach, but as I understand it the example you've given is taking click events and producing keyboard equivalents, which is the reverse of what I'm trying to achieve. ... or am I missing something obvious? Thanks Mike.

I am writing a POS application and need to make an on-screen keypad more efficient. I want to allow the user to 'click' each of the number buttons by pressing an actual number key on the keyboard, as well as by clicking the button controls. I have changed KeyPreview to Yes in the form's...

I am designing a keypad, with command buttons cmd0, cmd1 etc having captions 0, 1 and so on. Is it possible to extend the above idea so that (only on this form), pressing "0" on the (physical) keyboard's numpad will trigger the On Click event for cmd0, pressing "1" will trigger the On Click...

Success! Thank you Brian for spelling out what Paul was saying, and thanks Paul for helping me along the way. Mike.

Thanks everyone, I'll give that a shot tonight, gotta dash now (been failing to get the db small enough to upload). Mike.

pb, the full SQL (following your suggestions) is: Thanks! Mike.

... so Mailman, would that look like GROUP BY [Orders Qry].OrderID, PP_Gross, PP_Charges, PP_nett... ? I've tried that and get the same error: "You tried to execute a query that does not include the specified expression ‘IIf([PaymentType]="PayPal",[SumOfExtendedPrice],Null)’ as part of an...

I tried that and - you guessed it - the same error ocurred for the last expression, so I summed that too. Now, I have a new problem! The error reads: "Subqueries cannot be used in the expression (Iif([PaymentType]="PayPal",[PP_Gross]*0.034+0.2,0))." Subqueries...?

Thanks Mailman, but could you show me what the SQL should look like? I'm new to this... :o pbaldy, I tried your suggestion and this looks like part of the answer, since the interpreter has got a bit further: now, I get ''You tried to execute a query that does not include the specified...

I have what I think should be a fairly table structure for orders: the tables are [Orders] and [Order Details], and I have queries [Orders Qry] and [Order Details Extended]. This is all based on Northwind. I want to create a query which summarises orders, to be used in Excel; the user wants to...

Many thanks CraigDolphin, this works absolutely perfectly. All the best Mike.

I have used the Label Wizard to create a pretty standard labels report laid out to suit a specific Avery format (3 across by 7 down on an A4 sheet). However, I'm calling the report from a form on which I want to place a control asking the user to select a starting label from 1 to 21 (where 1 is...

Hmmm, Thought I had tried that but obviously not because it worked. Thank you! Mike.

I have a date field [orderDate] on a form, and a calculated text box with control source:=IIf([orderdate]>"30/04/2009",2,1)... the idea being that the box will display 1 for order dates up to 30th Apr 2009, and thereafter a 2. Why is it 1 whatever date I enter? Thanks Mike.