Search results

See attach db: I have an order added Open the invoice form enter a invoice number and date and press the invoice button

I am working on cleaning up a copy so it can be looked at. But it looks like my problem is partly because of the OrderPK (autonumber) and CustomerOrderNumber What needs to happen is the CustomerOrderNumber gets a BO attached to the end of it and the new order imput into the Orders and order...

I am updating a db and have made some changes to it and I am unable to figureour how to make the backorder module work correctly My tables are as such: Order table: OrderPK (AutoNumber) CustomerOrderNumber (Text) CustomerID etc. Order Details Table: DetailPK (AutoNumber) OrderFK (Number)...

Sam Thanks for the reply I had figured out another way by using queries and setting the criteria for secound combo boxes query to the first combo box. Then in the after update for the first combo box added in VBA to requery the secund combo box. It works without interfering with the save...

I have been having problems with a cascade combo using all the codes shown but when I went and did a cascade using the 1st combo as the criteria for the secound in a qry and on the after update event for the 1st combo added: Me.Combo2 = Null Me.Combo2.Requery It seems to work fine even with...

In my db I have a cascade combo which on another form works fine between a productline and category, but on this for it wont let me do the same thing with Vendor and Manufacturer. I get an error after I select the Vendor when it is supposed to set the criteria for the Manufacturer. I have...

I am stumped on how to move the data from an old data base to my new one for this example it is the Copy, because the PK will change when added. I have 2 tbls that one is the tblBikeModelIDs in which it takes form 2 other tables for year and make. Then I have tblModelIDKits which it is the...

I would but it is 1 to large and 2 there actually is 2 different db's one has the product info etc. and the other is made for special order info. I will try to clean a fake one up to show what is going on.

I am stumped right now I have a prices table that as prices increase / change we can change it and see previouse changes etc. Then there is the products table I am having a hard time figuring out how to set up a orders detail qry I have a max date qry to show the most current price for...

Thanks a BUNCH!!!!!

Works like a charm!!!! But you did burst my bubble I had made the changes to use a qry and it was working correctly. But I would rather not have a qry and do it all my code. How would you set up the code to attach it on the close of the form?? I havent had to do anything like this...

What would be the best way/ time to execute this function? It would be nice to do when the Cost frm is closed it automatically runs but I am affraid of the system hanging up

I want to thank you for the help I have been testing it and see how it all works. The only problem I have is when I enter a new cost but date it before one that is already entered it uses the one that was entered last. Would a qry be a good way to get the most reacent date or would it be best by...

I have a save function setup and would really like to keep the built in close button as you would have on any other program. Just to make the program easy to use. This is what I have setup on the before update and on close events. What I would like when someone selects the close button that...

Attached is a sample of the db I amp working on

Any body??????????????????????????????????

I have been looking and have found a couple db but one just shows the structure of how BOMs work and the other is an output db. What I am trying to do is set up that if there are C x 3 pieces in part B, and 2 x pieces of B in part A what is the ultimate cost of A...

I am trying something else and am getting a compile syntax error with the following code stWhere = stWhere & "([PartNumber] Between " & [Forms]![frmCostCurrentReport]![cboPartNumberStart] & " And " & [Forms]![frmCostCurrentReport]![cboPartNumberEnd] & "") Attached is a...

I have tried this code also with no luck and still get the same error If Not IsNull(Me.cboPartNumberStart) Then stWhere = stWhere & "([PartNumber] >=" & Me.cboPartNumberStart & ") And " End If If Not IsNull(Me.cboPartNumberEnd) Then stWhere = stWhere &...

Does any one know how to do this I have searched and searched and I know there has to be a way