Search results

You are right. :) But I've already made my initial table and a form to go with it. I just used my old database in Excel and imported it in Access. I'll attach it in the next post. :)

Okay, I get it. :) So anyway, how do I do that? How can I have an autonumber with a prefix? I'll just have that and a different PK then. :) Here are my considerations: 1. I want the first letter of the Item plus the autonumber. 2. I want the number to reset to 1 after every letter, if...

I see your point. :) Thanks for this. So what you're saying is (regardless of PK), I won't be able to have a field that's autonumbered and that contains a prefix? :(

Hey GinaWhipp, Good points. Here's the process of how staff can request for items that I store in inventory. 1. Staff goes to the Property Custodian, that's me, to ask for certain items, let's say ItemCode is A001, Item is Adapter. 2. I let the staff sign an Acknowledgement Receipt that looks...

Hey, you are very much correct. HAHA. In fact, I'm only making my first table. So based on your reply, I would just have to settle with a different Field that's autonumbered, and I would still have to manually input my ItemCode, wouldn't I? Bottomline question now is, Is it possible for me to...

So you guys could have a better understanding of what I'm building... Before, I'd have to manually input the Item Codes on Excel. I had to check if I had any duplicates and stuff and it's just a lot of work. One item could have many specifications like a binder could have different sizes...

Yeah, I get your point. But doing so would totally defeat the purpose of extracting the first letter of an Item and combining it with a number. It's just gonna add more fields and a lot more confusion. Plus, I want the numbers to return to 1 after every letter, example: Item Code Item...

Hi! Thanks for the overwhelming reply. To be honest, I have no idea about the codes that you jut wrote. I'm sorry. Anyway, to answer your questions: 1. I'm not so worried about each item reaching 999. :) In fact, that's already a huge limit. I'm tracking Office Supplies in my office because my...

I know what you mean. But where do I put that expression? I mean, in which format property? Thanks by the way for the quick response. :)

Hi, I'm making a new database and I want to assign Item Codes to my inventory. For example: ItemCode (Primary Key) | Item | ItemDescription I want to generate an automated item code containing the first letter of the Item (as prefix) followed by numbers. Example: ItemCode: P001 Item: Paper...