Search results

Hmmmn, The textboxes which contain the values have to be unbound for them to recieve the values from the called functions or public variables (I think). And I want to create a new record in a table with the various values from those text boxes. If what you say will work can you give me a small...

The answer for my case was simple : As if the user clicks cancel the input box value is null so;. Where I check the return value of the function I simply added If {function name} is null DoCmd.Close which closed the form and reset everything nicely.

I have a form with text boxes that are updated with their values from other forms or dlookups. I want to take that information on the form and create a record in a table with that data. Whats the Best / easiest way to do this?

Because the input could be comming from a barcode scanner. All I really want to know is how to check if cancell button is pressed and if so perform an action.

I have a function which uses an input box to get a customer number and passes it to a query criteria. The input box has OK and cancel buttons, which i have not defined. If the user click ok all is fine but the query displays blank if they click cancel. here is the code. Dim MSG_BAR...

I have made some progress thanks to your help. And now I have another question. If I have a query which runs and selects a record according to specified criteria. Is there a simple way of finding out if the query has a record or not. Eg. if i queried a table of sales with criteria of a price...

EERM! Really it is just because They select the customer first which opens a form displaying the customer details and includes a sub form showing history of orders, To add a new order they click a button and I didn't really want to open another form on screen.Just to know the Item is available...

Maybe if I elbaorate you'll See what i'd like to do and if it is possible. I am going round in circles! Im writing a tool hire database. The User has selected a customer and the desired tool and has also entered start and end dates. All of which are held in Variables. I want to check the...

Is it Possible to open a query and for the criteria to be equal to the value stored in a public varible? If so can you give mee an example of how. Thanks

I Have a query based on a Customer table , I wish to pass a value to the criteria from code, well a function is it possible? eg function returns customerID and want the query to display for just that ID. The reason I did it like that is so the selected ID can be validated before opening the...