Search results

@isladogs , never thought of that. Good idea.

Friends, thanks. It appears that my 'discovery' has some merit. @arnelgp , i shall have a look @ your demo. Cheers & thanks for the prompt response.

Friends, I have some vague idea of protecting a project for some kind of "trial" period. My thoughts so far are to encrypt the users email address using an RC4 technique & using that for the 'product key'. Talking of "key" I don't wish to keep the encryption/decryption key in a table, which...

@arnelgp , it has to be!!

All, i unsuccessfully tried exporting toobar customizations in word too. Same issue, will not save the file. Any Ideas?

@isladogs , that is exactly what i expected. Thanks. Upon reflection, what i've been doing is opening my project then selecting the file option etc menu to customize tool bar. Maybe i should not have been in my project but just open access then 'customize toolbar'. Will try this when i get a moment.

@isladogs , Tried again but it doesn't export. Did a search of my entire M/C in case the save location went strange but no luck. Also tried doing same on my older PC (32 bit access) same result. All I'm doing is selecting 'Access Options' then 'customize ribbon', making my changes then...

@isladogs , i thought i had a good look, but will try again. Seems simple. Thanks

All, I have customized the ribbon at 'Access Options Customize ribbon', made my changes (to Print Preview so that only both the 'print' & 'close' options exist). I wish to make a copy of this customized ribbon, so i select 'Export all Customizations', browse to my folder & select 'save' but...

@arnelgp , i shall. Cool code. Thanks.

@arnelgp , thanks. Module works well. Only change I made was dteRenewal = DateAdd("yyyy", 3, dteRenewal) - changed "m" to "YYYY" to reflect 3 years. Appreciate your help and appreciate @Gasman's thoroughness.

@Gasman , understood & thanks.

Friends, thanks. Will give arnelgp's module a go & let this thread know. Appreciate the prompt response.

Hi all, I'm attempting to write a module that will return one of several warning messages when a training 'Renewal Date' approaches as Renewals are required 3 years after training. So, I pass the last 'Completion Date' to the function below & add 3 years to it. (I call it 'dteRenewal' in the...

@Geert Adriaens, also check out Alan Browns website. He has a very good demo about filtering records. I've adapted his code on multiple occasions.

@aaronyoung914 , i use the image modules provided by Daniel Pinault of www.devhut.com. He has genorously provided modules for both rotating & resizing images. I resize then provide a button to rotate the image if required so that it's the right way up.

@isladogs , Thanks for that.

@kitty77 , i use some code from allenbrowne.com called 'GoHyperlink', the usage notes are easy to follow. I'd suggest you google this. Sorry, i'm writing this response from my phone & don't know how to copy/paste the link. Will do so for you when i open my PC.

Pat, thanks from me too. Cheers.

Pat, Great Demo. I particularly liked your 'dynamic' menu method. I've always hardcoded my menu options & was thinking of some kind of dynamic menu. Helped a lot. I also liked the way you captured 'changes' to objects with the sys table. Stuff I'll try and adapt.