Search results

Hi, if this kind of request is pretty weird or uncommon, please just ignore me ~_~ . I’m a real newbie with Access, but was asked by a relative to try to create a very simple DB that will track her restaurant inventory. As such, I have come up with some sort of working (hopefully) DB, but I want...

I see. I just read about the reputation thingy today and am now trying to find my earlier posts (thankfully few) to give some reputation to the wonderful people who helped me. (But I guess since I have few posts the reputation I give out won't be of much value ~_~; ). I wish we can read the...

Where can you read the reputation of the people? :)

Hi, thanks a lot, it solves my problem :) . How about if the field isn't a date or number field though?

Hi neil, Thanks for the tips :) . I tried doing that table but eventually got confused by all the links and computations I had to do. So I guess I'm sticking with the 2 fields for Inventory IN and OUT. I just followed your tip on having a combobox specify if the Movement is IN or OUT, then made...

Hi guys, I have a query that displays records that fall between 2 dates (using 2 input text fields). How can I make it dispaly all records if the user just leaves the dates blank? I've searched through some forums and found that I can make this happen by using IS NOT NULL. But when I tried...

Hi again :) , 1. No, I'm not attaching any meaning to the autonumber. Actually, I just put in an ID because there needs to be a PK for the record ~_~. 2. Yeah, I get it now :) ! Thanks for pointing out the normalization thing. I guess I'm still not used to seeing tables as all IDs :eek: , so I...

Hi bob, Thanks for the time :) . 1. For InventoryID, I left it at not-autonumbered first because I keep entering trial records in the datasheet, and I want to be able to start at number 1 when I ultimately use it to enter real records :o . I had it autonumbered before but then when I delete...

Hi guys. I need some help troubleshooting my cascading combos... that won't cascade :rolleyes: . Basically the setup is: Combo 1 : CATEGORY Combo 2 : ItemNames that fall into selected CATEGORY My 2 combos get populated OK, but when I add in my Criteria in the Query Builder, Combo 2 doesn't...

Hmm.. so I create another table that just has +1 -1 in it? I'll try that. True there are lots of ways to make things simpler... I only wish I had the skill level to do it. :) Lol, before I was trying to create combos to make dropdown DATE entries... utnil someone told me about the built-in...

Argh, that's so right. Using the Category as filter doesn't necessarily mean it goes into the table as well ~_~;;; . This is such a good idea! I'll try to see if I can make Access do the (+) and (-) based on that combobox. But if I really can't, will the separate fields for IN and OUT cause a...

Hi Neil, I put the Category field in tbl_Inventory because the main form the users will be using to encode IN/OUT movement is based on that form. I have two comboboxes there that filter the ItemID based on what Category is selected in the 1st combobox. If I only include ItemID, the list that...

Gah, I never saw that far :eek: , esp. about changing the category name thing. So, taking all that in, will this design here already be an OK design to build on? I'm not certain if the relationship should look like that (seems a bit circular) :confused: .

Hi, thanks. The Access course I took didn't really delve into normalization, more of how to create Access forms and controls. Kind of hard to conceptualize how to normalize if the DB doesn't have any data yet (actually, isn't created yet :p ). But I do get the examples on the normalization...

Hi Neil, I meant creating a structure like choice A in my first post. Instead of a TABLE formatted like: [ID] [Category] [ItemName] I'm thinking TABLES like: Category 1: [ID] [ItemName] Category 2: [ID] [ItemName] etc. I'm having trouble putting all the Categories + Items in only one table...

Hi, thank you! The calendar I used before was one of the samples on that website :o , so I guess it's a good and stable one.

Hi, thanks for the link :) . Now I know that my approach in computing for instead of storing Quantity left is not wrong. For the Stocktake Quantity, I'm not sure I can do that since I don't know how to code in VB. Can I just ask the user to sort of input the Actual Quantity left (by doing...

Hi, I was asked to help create a very simple Access DB for a small restaurant to help them keep track of inventory. The only things that the owner wants to keep track of are: 1. Item Catalog 2. Date and Quantity of Item IN or OUT 3. Current # of Items My problem here is that there are 5 Item...

@Bodisathva Hi, thanks for that info! I think that Access automatically recognizes my input as date because it does get accepted as criteria for a date column? My query doesn't return errors on that @neileg Regarding your question, it was because I never knew there was a built-in calendar...

Hi again everyone. I have a table with a Date field, format xx/xx/xxxx . I'm trying to create a form that will let the user choose the month/day/year from 3 dropdown comboboxes to make it easier for them to choose the date, then pass this formatted date off to a query and a new record...