Search results for query: *

Following on from my previous posts is it possible to get my own text box to pop up for an input mask violation and to get the cursor back at the beginning of the input field after ok is pressed.

Another question: I have a combo box that populates with serial numbers based on a query. It goes through a Me.refresh before the next one can be input. When a duplicate entry is attempted it triggers the notinlist error. You click ok but then you have to delete the shown data before trying...

I have a combo box that has two choices, good or faulty which then appear in a text field on the next form. How do I prevent a user pressing the enter button without making a choice from the combo?

I want to vary the contents of form Bs title caption depending on what is entered in a text box on form A that leads to form B. Any idea?

Sorry to be a pain, here is a sample from my table ID Serial actionDate action location status 562 0001 22/09/2004 add stock warehouse good 563 0002 22/09/2004 add stock warehouse good 564 0003 22/09/2004 add stock warehouse good 565 0004 22/09/2004 add stock warehouse...

I have a query that finds the 'max' value of a now() field but how can I find the one before the max?

I need to prevent the input of serial numbers in to a text box if they appear in a query called duplicates which lists all stock currently in the warehouse. I cannot use a simple no duplicates in the table because we sometimes return items to our supplier and have them re-issued to us at a...

Hi, My simple table consists of 'ID' (autonumber), 'serial' (number) and 'movement' (text) eg: 1 1001 add to stock 2 1002 add to stock 3 1003 add to stock 4 1001 issue 5 1002 issue 6 1001 return 7 1002 installed I need to write a query that will list...

I have a simple table with data input via a simple form. Each record consists of 'id'(autonumber) 'serial number' 'action date' 'actioned by' and 'action' 'serial number' is looked up from, and limited to, a stockholding table. 'action' has just two alternatives - 'issue' and 'return' I have...