Search results

cheers pbaldy, this works a treat - knew it would be simple solution :)

I am trying to substitue the 1 below for a Variable in my code vol = Forms!frm_3rdSchd.att1.Value but can't seem to figure out how to do it vol = Forms!frm_3rdSchd.att & regNum & .Value gives 'Invalid or unqualified reference'

David, I tried the documenter you suggested and it produces runtime error 3021 (No current record) when it gets to my 'half missing' Module. Alisa, I have tried breakpoints and stepping into and each time this just causes Access to crash. Thanks for your suggestions guys but I think I need...

Cheers David, documenter doesn't work either though as Access can't find the procedure. As you stated a lesson learnt and a day of remembering and rewriting code ahead for me to look forward to!

Hi David No I do not have db split, it is a fairly new and in early development stage. I am building on home pc which is running 2007 but have emailed to work now where I am running 2002 and still having same problems. I do have back ups but none after I had created this Module :mad: I...

Thanks for your sugestion Alisa, but when attempting to rename it just doesn't work! It allows me to edit the name, but then when I tab it just reverts back to " again

I have just started a new access database, I had created a module with a substantial amount of code within it. The module appears to have renamed itself from mod_scheduler to simply ". If I try and open by double clicking I get an error messgae stating that the module name is misspelled or...