By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

VBA CreatingNewClientAlsoloogingIn

P: 2
I am creating a login for emplyees but when they click a button I also need it to grab the next ClientID in a table called tblReferral.

Tables
tblReferral

Forms
frmChoose

Currently I am getting the name from a form called frmChoose it is the same form with the button to be clicked. So I will grab the name from the unbound form and then run a query to grab the max ClientID in tblReferral,Both parts of this the unbound form Name and the Max client ID will then be saved into the table tblReferral.

I hope I did not confuse everyone.
May 2 '10 #1

✓ answered by Jim Doherty

@Rob81473
Yes pitching your sophistication depends on how comfortable you are with it.

For your benefit and in addition to Robjens comments I have knocked together and attached a little database for you to chew over the different methods to enable you to consider some options. Its not the definitive article but its a start hope it helps you.


Welcome to Byes :)

Share this Question
Share on Google+
3 Replies


P: 37
So everything works as expected? The way you are doing it is imho the best for beginner/average Access experience. But then again, learning recordssets is easily done and very very rewarding so...DAO all the way.
May 2 '10 #2

Jim Doherty
Expert 100+
P: 897
@Rob81473
Yes pitching your sophistication depends on how comfortable you are with it.

For your benefit and in addition to Robjens comments I have knocked together and attached a little database for you to chew over the different methods to enable you to consider some options. Its not the definitive article but its a start hope it helps you.


Welcome to Byes :)
Attached Files
File Type: zip rob81473.zip (16.5 KB, 36 views)
May 2 '10 #3

P: 2
@Jim Doherty
Thank you for the sample. I had figured out that I was going about it the wrong way. I should have just made the clientId an Autonumber and updated the table when I created a new Client with the emplyeeID.

Thank you again,
May 3 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.