Recent content by jerrywolf

I can't get it to work for me this way, for some reason I keep getting errors.

Not all fields are required, for example, an order may not have any specific notes listed. As for dbFailOnError, yes good call I left that out :eek: , but the app isn't finished yet :cool:. Hmm, I like the idea of referencing the fields directly in my SQL syntax. I will try this. Hopefully...

Hi all- not sure if this is the correct forum to post this, but here it goes. I have a form called order entry for well entering orders. A user types part number into a textbox, and my code finds all related parts (for the assembly), and inserts them into a temporary table, linked to a...

So if I'm correct in my understanding, I would have tbl_Parts PartId Customer PartNumber PartDescription tbl_PartRevs PartRevId PartId (FK, tbl_Parts) Rev tbl_Orders OrderId Date PartRevId Qty Basically, In my orders table I would have...

jdraw - your link to the BOM structure was very helpful. Thank you for that! Good point - Rev 0 could be a default, however, then a user would manually have to add a rev 0 record, which isn't a huge deal. As for inventory control then, I guess it could be based on partid because inventory...

Ok sorry - I should have been more clear. A customer supplies us with a drawing of what is to be made. Many times we keep inventory, and we do repeat products. A revision is related to a part, and it is whenever a customer makes a revision to a part drawing - it is clearly marked on the new...

Hi all - we are a make to order manufacturer, and are in the process of creating an access database that can handle orders, customer history, inventory, etc. The problem is we make all kinds of parts for our customers, and the puzzling thing for me is how to structure the database to handle...

So after a few days of some more research, I have decided to use Alpha Anywhere V12 to develop my application for an iPod touch. This seems like very well designed software - not to mention I can interface directly with an access database! So for any of you who may have this same dilemma I...

Hello all! These forums have been great and I have learned quite a bit from here. I have completed a few applications for our business - HR, Orders, and Inventory. We are a manufacturing company, and our inventory database needs something I am not able to find an answer to - mobile...

Thanks!! it worked perfectly!

here ya go

Hmmm ok i'm a little lost, what would you recommend? Thanks

SELECT TOP 10 tbl_Transactions.TransactionDate AS [Date], tbl_Transactions.QtyIn AS [In], tbl_Transactions.QtyOut AS Out, tbl_Transactions.Notes FROM tbl_Parts INNER JOIN tbl_Transactions ON tbl_Parts.PartId = tbl_Transactions.PartId WHERE...

Hi All, I've been banging my head against the wall all day today trying to figure out what should be super simple. I have a products form, we are a manufacturing company, with a listbox to show recent inventory transactions. This is based on a query which shows all transactions with the...

For some reason saving it that way made it more than 2 mb. Here is a link to download the document. Thank you.