Search results

@arnelgp , A few moments of your time please. I like what you've done & wish to adapt to my project. I've copied each of the 3 modules, frmValidate & MsysCode. I notice in your example that MsysResources is populated from the data in the class Module. How do I do that?. Also MsysCode table is...

@arnelgp, Brilliant!. Will adapt your method to suit my purpose. Really appreciate the time & effort all members have applied to this issue. If you don't mind, I will probably have additional questions as I absorb your technique. Thanks again.

@arnelgp , thank you. Will have a good look at it. Appreciate your help once again.

@arnelgp I get a variable Not defined error when compiling the following; Public Function IDfromCode(ByVal code As String) As Integer Dim iKey As Integer For iKey = 1 To c.Count If c(iKey & "") = code Then Exit For End If Next IDfromCode = i End...

@isladogs , Colin, thanks. I've a lot to digest. I'm also looking at @arnelgp's example too & have a few questions for him. Thanks.

@isladogs , sounds similar to what i am trying to achieve. Will replace my rc4 code with yours and try again. Thanks A question, why did you elect not to use an RC4 code on your applications?

@arnelgp , yes final version will be .accde. Will certainly have a look at your version. Thanks.

Colin, The only form you need to worry about is 'frmRegistration'. Upon entering the firtsname, lastname & email address, then hitting 'Obtain Registration Key' my intention is to derive the password from email&HDD# then save it as [PWD] in table 'MsyUsers'. The email routine then runs and...

So, I've attached my database 'Password' my intention is to develop the code with this application then adapt to my 'real' project. Thus, no attempt to make it look good etc. It's also a repository of code that I'm playing with. The background is that 'frmMaster'opens upon startup (I've put some...

@sonic8, i think you maybe right. When i encrypted only the email address i suspect i did not generate the offending character by luck rather than planning. I'll upload my database & you can see what i mean. Thanks

@plog , both PWD & RegisteredPWD are short text set @255 Characters. I made the form to illustrate the issue. Even if I directly copy/Paste within the table, the last 7 characters are missing. As I said, if I run an update query to copy from one to the other all works. It's something to do with...

All, I'm toying with a user 'Registration' form. I take the users email address and concatenate the hard drive serial to it, then run an RC5 cypher to come up with a "Password". All that works fine. Upon registration, my idea is that the user sends a system generated email that, of course...

To all contributers. Got it working as an unbound form, but elected to go bound for simplicity. Something to be said in letting access manage it'self. Appreciate all recommendations and i achieved my 'learning' goal. Now onto the next challenge....

@ebs17 , that is the reason i did not give up with my challenge. Thanks.

@cheekybuddha , thanks once again. I hate to be beaten by lack of understanding. I've elected to use a bound form, but was still not happy that i could not achieve my initial approach. Thanks will give it a go.

Gents/Ladies, although I've elected to use a bound form for my 'registration' ,It still bugs me that I cannot derrive the correct SQL insert into string syntax. This is my code & the project is for me to learn, but nothing important. I just don't wish to be beaten And this is an example of...

@cheekybuddha , I ran your code. Still generated errors. The debug.print did not show anything obvious to me, but I elected to revert to a bound form. Much easier to work with for us amateurs. Appreciate your input. Got it going as we speak.

All, I cannot get the select query to work & admit defeat. I will adopt a bound form instead. Let Access do the work. Steep learning curve sometimes.... Thanks for the support.

Office 365 repair did not work!

@bob fitz , my attempt at an unbound form. It's designed to be a 'registration' form that i adapted from the logic of @isladogs logon system that i've been studying (and adapted successfully previously)