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...

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 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...

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...

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...

Hi, I'm new to the forums and Access in general :o . I just have a question regarding storing a selected combobox value in the datasheet. I don't have VB coding experience so I'm just using mostly the wizards in my database (Access 2003). In my form, I created a combobox in Design view, then...