Search results

  1. A

    Locking records on sbform (Data View)

    Hello, I want to lock selected records on a subform - which is in data view - at the moment I'am using; Private Sub Complete_Click() If [Complete] = True And (IsNull([Forms]![AmendOrders]![OrderItems].[Form]![InvoiceNumber])) And...
  2. A

    white out

    Hope you dont mind a novice trying to help on this. Here are my thoughts on your problem. Grey check boxes indicate a state for the box where no value is set (It is neither Yes or No). This is commonly seen when going to filter by form. To set the box to white again set the value of the control...
  3. A

    Help with subforms

    Hello, I have 2 problems that I could do with a little (lot!!) of help with. 1. I have a subform that books in records stock coming in/out of a warehouse. Initially the stock is recorded on the form and a picking list produced. Once the stock has been "Confirmed in" I want to write a stock level...
  4. A

    Help with autocomplete

    Kevin You're a Diamond. I've been struggling with this for absolutely ages. I just wish that I had found this forum about 3 months ago when I first started this project, I'm sure that it would have saved me a lot of 'fumbling in the dark'. Once again, many thanks. Regards Noel.
  5. A

    Help with autocomplete

    The problem I have a simple DB that i would like to perform a little automation with, however I cant seem to get my head around it. I have a form to allow records to be kept for purchase orders. The from has a subform on which the actual details of the items are kept. This is the bit that I...
Back
Top Bottom