Correction Key2 is generated by a formula using key1

example:  Key1 = (20+30)/5   key1 = 10
key2 = (10Key1 +50)/3   Key2=20  Remember PEMDAS Please excuse my dear Aunt Sally. I used to teach this.  Many years ago.

I need to have have Access generate key1 then do formula 2 to generate Key2

How do I do that?

This will have a form for the user.  Upon opening the Form Key1 needs to be generated.  The user then inputs the key1 in and the user gets key2.

What command can I use to activate the formula for key1?

Is that one or two questions? And if it's one, which one?
Are you working in a form or report or something else? Are you using VBA or something else?
Do you mean something like: ("This is key1: " & key1 & "and this is key2: " & key2) inside your msgbox?
(10 * 10 + 50) / 3 = 50 not 20

I'm very confused. If key1 is generated, then why is the user entering it?
And if it is generated, then why not calculate key2 in the same procedure and be done with it?
I'm not quite sure of your difference between generated and calculated for a formula.

Ok, Thomas  Let me answer your questions.

I am working off a form.  I have to use VBA.  Key1 is generated by the code on the users software.  Which I provide.  They in turn call me I put the key1 into my Return code generator.  Which I am programming right now.  Once entered it generates a key2.  Which I give back to the user.  The formula on their software checks if it is a correct Registration code.  If yes,  It registers the software.  makes changes on their system.

Correction the user is not entering key1.  Its generated by their software.  They then call me and I enter it into my code generator and get back a return code.  They then enter it back into their system.  the software is registered..
Question #1
the statement  MsgBox "key1"  does what?

I don't blame you for being confused.  I just learning the registration seminar.  I am confused.

I have an idea.  Lets both sleep on it.  I will be back at it at 10am E.S.T.  Its 12:21am here and I am falling asleep while typing.

Thank you for your help.  May God Bless you and your family!!!!

Jeff

key2 = (10Key1 +50)/3   Key2=20   I put the 10 next to Key1 to show that the value of key1.  Its not 10*10.

If key1 is generated, then why is the user entering it?  I was wrong on how I explained it.  The software on the users computer generates Key1.  He has the formula for generating key1.  I have the formula for generating key2 from the formula on in my administrative options.  
And if it is generated, then why not calculate key2 in the same procedure and be done with it?
I'm not quite sure of your difference between generated and calculated for a formula.

Generated and calculated is the same.  in either case the formula is on two different computers.  We are talking via cell phone.  I guess the software on the user computer can generate key2.  It defeats the purpose of registering the software.

Back on 12/31/24 at 10am.  Till then sleep silently and softly.  Jeff

Thomas,  I got a case of insomnia after my last message.  I got the formulas for Key1 and key2 working.  I am going to close this blog.  Open another one for some issues.  Thank you for your help.

Are you following the Access Registration Seminar?

Yes, Alex I am following the Access Registration Seminar.  I thank you for your help.  My software is getting so complex that I have to start putting stuff on paper.  I am going to flowchart.  What happens when a customer calls to register their software.  I need to know what information I am collecting and finally generating a " return code" and registering their software.

I've moved it to that page, if you could ask questions on the related page it helps with context.

Also what isn't working from the Seminar, did you just copy parts across to your db?

I created a form in my database for customers.  This is where I will generate a key2.  I will also collect customer information.  Alex I have to be aware of letting out information about the registration seminar.  As you are aware.  there are hackers wanting to get information on how we do things.  So if I am quiet on things.  Its because this site has ears.  As much as I like to fill you in on details.  I can't.  Richard gave orders not to share the workings of that seminar.  It protects us all.  There are some things that I am going to have to do myself.  Does this site have your email address?  

To answer your questions.  I took parts and copied them in.  currently I am generating both key1 and key2.  Now I have to write them to a table for customer records.  Which I will use dlookup.

That's the reason I moved your thread from the public forum you posted in originally to the private lessons page of the Seminar.

So your original question was about MsgBoxing, but you actually want to save it?

Why not just bind the calculation fields to a Table or have an After Update event or a Button copy it to where you need it?

I just copied the code to my customer registration form.  It generated key1 and key2.  Both displayed in a msgbox .

Now my question is "How do I get Key1 displayed in the (keycodein field) and Keycode2 to display in registration return code field?"

"Remember key1 is generated by the customer software.  I take that code and enter in to my customer registration form and key2 is generated.  That is then given to the customer for entry into his software.  The data base is now registered.

When you said you copied this to another spot.  I am not sure what you mean.  Thank you for your help.  Jeff

Nearly every page on this site has an option to add a Comment.
You originally posted your question in one of the Access Forums, it had no context of what code you were working with, which Course or Tech Help it was from. If you were to ask on the course/video in question you could then say it relates to the code in that db.

See how the IDs are different:
Registration Seminar Lessons (This Page)
https://599cd.com/blog/display-article.asp?ID=1964

Access Forum
https://599cd.com/blog/display-article.asp?ID=352

Access Developer Forum
https://599cd.com/blog/display-article.asp?ID=1620

Do you understand how the Registration code is generated and how it interacts with the Form you are using it with?

Other post: Need to get key1 printed in key1 field