Search results

Never mind I totally fergot about the criteria section

That really isnt my complete structure which I finally figured out what I was doing wrong and got it to work but now my problem is on the (on open event) which I have this append qry setup to work I need it to only append data linked to the OrderPK.

I am trying to setup a Append query in which you use an open form button and it appends data to the form that I am opening The data on the main form is order info OrderPK ProductFK UnitPrice Quantity On the Invoice form I want the data ProductFK UnitPrice to append to the Invoice details...

Actually I do want to do each record one at a time becuase for some orders I dont have enough on hand and will have to do a production run. So say today I get an order for a computer and a monitor and the customer is ok with back orders and I only have 1 computer on hand and no monitors I will...

If I have a form invoicing details sub form viewed in a datasheet view in which I want it to look up info from the order details form and save it in the invoicing details tbl would I be able to use the Dlookup function? Also if there are more than one items in the invoicing detail sub form would...

I need some help!!! I have a form Invoice with a Sub form Invoice Details master child fields are InvoiceID. The invoice form is linked to another for Orders by OrderID and in the Orders from it also has a sub form Order Details master child fields are OrderID. What I need to do is have the...

I just want to work on just one order at a time and dont want a temp file because I need to show each time a product is shipped I looked threw the VB but nothing there is really what I want to do with the db. But I will look at it a little closer and see if there is something I could use that...

Ive already look at that and the way it is set up with a temp tbl ect wouldnt work for me.

In the invoice frm I would like to have a subfrm that is viewed in datasheet. In which I see what the customer ordered (Part Number), Description of product, Qty ordered, Qty already invoiced, then a place that is unlocked to which I can enter the qty to be invoiced, and one more cell to show...

With all that is said about the bads of lookup fields I have a quick question: If have want to import from Excel and there is no lookup field how would Access know that the State Name is the same as the State ID when I do the import to the main table.

I am still learning how to setup db's but am able to get myself around with some VB and have a decent knowledge of Access. With that said: I am having a hard time figuring out how to setup my invoicing form to which it will pull the products ordered from the order to show how what and how...

I need some help with linking a list box on the invoice form to show the information selected in the list box above it in which a user can change either the product Qty etc. then when the information is changed the user can push the accept button and that will update the list box or cancel which...

Here is what I am working on so you can get a feel for what I am trying to do there are a lot of small things I have to fix but what I really want to do is get the list box linked with the accept or clear buttons.

I am working on a Invoicing DB that I would like to be able to place an order and then Invoice that order and ship what we have in stocka an back order remaining qty then when we recieve more invoice the rest to that order. I have set up my table as such tblCustomer Cusotmer information...

Sorry I figured it out I forgot to update my report when I made some changes and that is why the macro was not working

I am kind of new at all this and am trying to set up a database with the ability to print different size labels depending on the size of package the label will be affixed to. I have a combo box with large and small Set up the reports for large and small I am now just trying to figure out how...

There is some code that you will have to write in order for it I tried to look for it in my data base but couldnt find it.