Search results

I added the procedure you described to the "close without saving button". This works perfectly when the user has started adding or changing the contents. However, if no changes or aditions have been made and the user clicks on the button to exit the form, he gets an error message "you can't...

What about the Esc key? Is there a way to "simulate" with a macro what the Esc key does before closing the form? It's more or less what I want my form to do.

I'm afraid there must be something I'm doing wrong or I didn't understand well. I can't find a contxt menu or any other command that enables me to set parameters to the pivotTable. In the meantime I've tried assigning parameters to the source-Query itself, yet the pivotTable still can not be...

When I have a form in data entry mode, there is no way to close this form once he started adding information to it. When I assign a macro to a button with the command "Close" and SaveOnClose set to "No", the information added is saved to the Table. Is there a way to get around this? I mean, what...

I have created a few pivot tables in my database which are based on select queries. All of these queries include a date field What I want to do, is to have the user to set a date which will filter the query (and accordingly the data viewed on the pivot table) However: when I use a criteria...

How do I transfer a specific value in a Query to a field in a form? To be more specific: I have a Query with three columns. I want the user to select a value from a combobox on a form (the combobox looking up values from the first column of my Query) and on another field on the same form to...

I have a data entry form based on a Table with three fields. An autonumber field (primary key) a person-codenumber and a field which looks up its values from another Table. On my form the last field is represented by a list box. I want the multi select property set to simple or extended. When...