Search results

Is it possible to use wildcards to see if a table exists? For instance I want to delete alle temp tables that are in a database. The tables do not have a fixed name, it is based of the form and the recordnumber that someone used. is it possible to check if a table exists that matches 'temp*' as...

I use the following code on the subform, however when I change or add a record nothing is saved. I have a mainform with a ok (save and close), annuleer (cancel) and toepassen (save only) button. I want to be able to rollback the data on the mainform and userforms. What am I doing wrong?? Option...

I have a form and a subform. Is it possible to cancel all the changes that a user made to the mainform and the subform, even if there are multiple records added to the subform? to cancel all the changes made on the subform I use the DoCmd.RunCommand acCmdUndo command. However, this does not...

My database is used in a multiple user environment. I want to upgrade now from the DAO structure to ADO so that I can work with transactions and 'rollback' them if necessary. People work on different computers and I do not want to check a lot of computers if there is a reference to the ADO dll...

Great, that worked, thanks!

When I use the following lines, it works perfectly With Forms![frmvandaag]![subfrmbijzzovandaag].Form Me.Artikel = .Artikel Me.Op_zicht_van = .[Op zicht van] Me.Op_zicht_tot = .[Op zicht tot] etc. but.. When I use this code, i get an error that the form cannot be found...

I have a form 'FrmVandaag' with a subform 'SubFrmBijzZoVandaag' If i click on a record in the subform, a new form (FrmZichtorders) is opened with non depended text boxes. The form Frmzichtorders can be opened from from different forms that's why I declared the variable 'formuliernaam as string'...