Search results

Hey, I have a script that inserts a record into another table, which works fine. However the record sometimes contains NULL values and so the Insert clause doesn't work properly as it can't assign NULL values. How do I check for these NULL values and what do I assign in their place so that it...

I would like to be able to create a new ID Code from a "next available number" field in a "config" table. How do I extract this number from the table, use it in the form (ie in edit controls) and then calculate the next number and then put it back in the table ready for the next item that uses...

I am trying to write a debug script in a module so that a Null value is left in a text box. How do I go about executing a Message Box telling the user to enter something in before the rest of the code is executed?

Is it possible to create a form that has say three fields in which you can enter either an ID, Name or something else and then use these values as the imput to a search into a particular table?

I have a table that involves a tick box with an associated date field. I want to be able to enable the date field when the tick box field is set to TRUE. Also, when the date field is enabled I need to place the system date plus 30 days into it as a default value. Also, if it is possible, can...