Search results

Hi all, I need to create an "autonumber" field in the following format: FYYMMXX Where F is a constant, YY is the year, MM is the month, and XX is an incremented number. So for example, the first record in August of 2013 would be "F130801". I've been checking other threads but haven't been...

Hi, I am new to Access, and I was hoping for advice on how to setup my database. I'm trying to setup a database that will track which raw materials/submodules are built into submodules/products at various levels of assembly. So I have 3 related tables: KITTING: Records the workorder...

Hi all, I am a newbie, and I've been struggling with this problem for days now. Every different way I try has an undesired side effect with the userability of my form... I have a bad feeling that this won't do what I want it to do. Is there a way for me to have a field in my form/table...

Hi, Inside my form, I would like to have an unbound text box display a field from a separate table based on a user-input into the form. I've tried a DLOOKUP, and just putting a direct equation into the text box, but to be honest, I can't even tell from the tutorials if this is an event or a...

Hi all, my name is Laura, I'm a total newbie, trying to teach myself Microsoft Access in my spare time (of which I have little or none) to try to improve data collection at my job.