Recent content by gisler87

any method that would be good to do this? at least to get me in the right direction. i am unexperienced with vba but feel i can learn it if i just know where to begin. thanks for all the help

thanks for all your help. got it working now. Many thanks

No i am using an embedded macro. the macro is opening up a query and then i am checking a field to see if the value is empty. many thanks

Hi, I am creating a cd borrowing system. currently i have a form that shows the borrowers name and details then i have a subform that shows all the cd's they have borrowed. in the subform i have a button next to every cd borrowed that will allow you to renew the loan. what i am trying to do...

Hi, I am using the correct container name. I did try using there cod: Forms("frmTest").Controls("MyContainerName").Form.recordsetclone.recordcount instead of getting #name? With the above code i get #error. Is it possible i am getting #error because i am running in sandbox mode? Edit: The...

hello, i have been working on trying to get a atribute in the main form to count the ammount of records in the subform. tried this code but just get #name? =form!mainform!subform.form.recordset.recordcount any input would be apreciated many thanks andrew