Database in MS Access 2010

[Stella2015]

Hi All,

I need help on MS Access. I am creating recruiter database for them to store candidate record.

I have encountered several issue

1. How do I set for Candidate ID to be auto_increment but candidate ID have to be start from year_001 (e.g. 2015_001. 2015_002, 2015_003, 2015_004) ?

2. I have created a login form and I would like to know what's the code to login, so once they click "logon", it will open database with record

Thanks for the help in advance



Have a nice day

[Homegrownandy]

1.A. Auto number is a field in access that automatically generates incremental numbers. Usually used for ID.

1.B. Why do you need to assign an increment to the date?

2. How do you want users to use the database? will they all be on one machine? What record do you want to open? their own?

[CJ_London]

1. google 'dmax+1' for suggestions. Your id will be text so you will need a slightly more complex solution. You may be better storing this in two numeric fields - year and incremental number and just combining when being viewed
2. your description is not clear enough to provide any real help, but google 'access login form' or similar or search on this forum - login forms are a popular subject, I'm sure you will find one of the many solutions will fit your needs

[June7]

Generating custom unique identifier is common topic, start with https://www.accessforums.net/forms/a...ing-23329.html

[orange]

Stella2015,

Do you have a clear description of what you are trying to accomplish? Your post doesn't contain enough context information to offer some general guidance and advice. Others have answered your specific question, but I don't see that as your prime interest/issue at the moment.
You need a plan, and that starts with a description of what you are trying to automate.

a recruiter database for them to store candidate record.

just does not have the detail to start designing a database.

You might want to work through one of the examples here. But you have to work through it to gain the benefits.

Good luck with your project.