Recent content by Joeman2020

Hi Arnelgp, If you have time can you help me set up the Actual table for the PO? I'm not exactly sure what needs to be in that table. Thanks for your help.

Thanks. That did the trick. One more thing can you look at the purchase order form. When I added the quantity to item 0101 it didn't update the on hand field in the on hand quantities query. Appreciate you help again. Joe.

Hi, Can you take a look at my stock database? I am having trouble updating the stock when I run the query "Parts Below Min Stock." I'm not sure what is going on with that. Thanks for your help. Joe, Michigan.

Hi Plog, Thanks so much for helping me on my project. I want to understand how I am doing this. I looked at your link and tried to mimic the tables that were in the video. I've added some fields that were in the video. I placed the junction table as order details and made the relationships...

Thank you for the advice. It may take me a little while to complete are you on here, or can i shoot you an email?

Hi Plog, Thanks for the advice. After I make the adjustments, can you look at it again. In terms of multiple parts be in multiple locations: I'm thinking that one multiple parts can be found in multiple locations and multiple vendors can provide multiple parts. Joe.

Hi Access World, I was just wondering if you can check out my data base, specifically the form. When I enter the new record, it's not showing up on the table parts. Also, the buttons I put in doesn't seem to working either. I would appreciate any advice that you can give me. Thank you...Joe...

OK i will try to fix those issues. I'm just kind of starting out so, I don't have a great deal of knowledge in Access.

Great, thanks for the advice plog and pbaldy, i will try to correct the issues.

Hi, Thanks for the article, but I would still like someone to take a look at it.

Hi Access World, Hope all is well. I have a couple questions regarding my database inventory project for my class. I'm trying to set up a reorder alert and not sure how to go about that. I tried running a query called qreorder, but it didn't seem to work when I ran it. I put a criteria in...

I made the adjustments according to your post, thanks plog

Hi Plog and Db Guy, Thank you for replying to my post. I'm just starting out with Access so l'm a bit of a novice. Any help to improve this data base would be greatly appreciated.

Hi, Here is my database with the combo box in it. Except I don't think it's working because when I try to click on the item its not registering in the box.

Hi Access World, First post here. I am trying to auto populate a form from one combo box. For example I would like to select item name and have it automatic put in the category, room, location, price per item, quantity in stock, and quantity sold. Also, when I select the vendor id it would...