Search results

  1. R

    Keypad for POS application

    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...
  2. R

    Problem with expressions in a Totals Query

    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...
  3. R

    Labels starting mid-way through a sheet?

    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...
  4. R

    Date compare problem

    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.
  5. R

    Access noob - problem using query in VBA to change an object's property

    Please be gentle, I'm new to Access... I have an Order Processing app based on Northwind. I've modified table [order details] to include a yes/no field 'canVisit'. The Orders/Orders Subform look quite similar to the original, but I have buttons on the Orders form which I only want to be...
Back
Top Bottom