473,322 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

VBA CreatingNewClientAlsoloogingIn

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 :)

3 1135
robjens
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
897 Expert 512MB
@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, 63 views)
May 2 '10 #3
@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

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.