F
Falty
I have a database which is for call logging for the IT dept, there is one
form for entering the call and this form is duplicated 8 times, one for each
of the sites that we manage. It all works fine except there is a fair bit of
visual basic code which is then duplicated 8 times and it slows down the
whole database. Is there a way of writing the code once and having an active
form call on the code when required. I tried writing it into a module but it
does not like the keyword Me and if i type into into a class module it does
not recognise the sub at all. When i wrote the code into the Module and Class
module it was just an exact copy of the code from the form. Is there an
easier way? Do i have to change the code or have i done something wrong?
form for entering the call and this form is duplicated 8 times, one for each
of the sites that we manage. It all works fine except there is a fair bit of
visual basic code which is then duplicated 8 times and it slows down the
whole database. Is there a way of writing the code once and having an active
form call on the code when required. I tried writing it into a module but it
does not like the keyword Me and if i type into into a class module it does
not recognise the sub at all. When i wrote the code into the Module and Class
module it was just an exact copy of the code from the form. Is there an
easier way? Do i have to change the code or have i done something wrong?