Search results

An example would be great Vinzz :-):-) Regards Ugurovic.

Lpurvis, Thanks for your advice, but your solution also do not cover completely my question to undo changes to subrecords. Once changes made, how to undo and get the previous value of the record. Yes my subform and mainform is bounded, and I think it will stay like that. Your solution is...

Hello I attached my DB, without some data and other forms. With the "NEW" button, I make a new record. With "MODIFY" button I want to make changes to subform and mainform. But when I press close, I want that the changes made to be cancelled and the records returns to his previous version...

Thank you, Your code is only working on the first record of the subform and not on the rest of it. Is it because I use continous forms, I think so. Is there a possibility to perform a loop of all the records of the subform...?? Regards Ugurovic

Ok. Is there any possible way to undo changes on a subform not using unbound fields AND the escape button? If not, I'm gonna kill myself. Regards Ugurovic

gooooosh, is it that really hard? pppffffffffff The stephen lebans example of commandbars form didn't impressed me that much. Do you got another example? Thanks Kind regards Ugurovic

But how to save the records of the unbound fields. What code do I need? CurrentDb.... .Edit and so on, I don't know the code, can someone put a clear and code on how to do it. Thank you. Kind regards Ugurovic

I want to undo changes made to the subform. I think it also works with .Edit. But is it possible that I make my Mainform Bounded to the table and write edited unbounded fields of the subform by .Edit, currentdb... I don't know the exact code to write unbounded fiels of a form to a table...

THanks for your reply. But it doesn't work. You can only refer to events of the subform and not what's in the form. What expression does refer to a button on the subform? Kind regards Ugurovic

Hello I think the title explains a lot. 1. How to refer from mainform-button to subform-button AND execute whats underneath that button? Setfocus->Execute. Button on subform will be 'unvisiable'. Thanks in advance Ugurovic

Hello Can someone attach a file where a form and subform is connected BUT where the subform is unbound. In het "Unbound.zip" it is just 1 form and not a subform. Thank You Kind regards Ugurovic

No that doesn't... I need the code to undo the strSQL function so I can search in the listbox via another field... undo strSQL, that's what I need.. Kind regards U.

Anybody who can solve my issue? Kind regards Ugurovic

Ok, I have 2 situations 1. I have a table 'Names'. In the rowsource of the properties of my list I have a SQL that filters records of the listbox via an extern field. When I put a value in this field, it filters records on this list based on the table. Ok? So my suggestion was, I have...

By locking I mean that the rowsource sticks locked by strSQL I've done with VBA (see above), so I need another function to clear this rowsource so that I get the whole table in my list and not the one I've searched for in my strSQL in VBA. How the clear rowsource strSQL, any idea? Is there a...

Hi, I have a Form, Listbox and a field 'field1'. In 'field1' I search for label, description in table1, and table1 is connected to Listbox so I get in my listbox, only the records that I searched for. In the rowsource of the properties I have a sql the get records when I put something in...

topic is moved to the VBA forum of this site thank you U.

Hi, I have a Form, Listbox and a field 'field1'. In 'field1' I search for label, description in table1, and table1 is connected to Listbox so I get in my listbox, only the records that I searched for. In the rowsource of the properties I have a sql the get records when I put something in...

Hey thanks for you reply. It is not obligated that the word 'Label' is put in front of the number, the number by himself is also OK. But with what code do I have to number it? Maybe I have to count te records in the table and adding 1 to it to make a new one. Do you have VBA code for that...

Dear all, I want to have a clear numbering in my access db. Problem is like this. Now I have field with an input mask of "LABEL"0000;;_ , I have to put the value of the label myself but I want that the db checks de last value en adds a "+1" to make a new one. 'Autonumber' is not Ok because if...