Search results

Hey all, Once again I turn to you for assistance. I have a problem I do not understand I have a form to record batches of products made. The indgredients I get from a drop down menu. Menu has the supply name-colour-manufacturer-lotnumber When I get the ingredient, it seems it gets the name from...

So I have a Supplies table which is my non-cooking materials like bottles, jars etc And I have an Ingredients table which is my cooking ingredients like oils, butters etc And I have a Purchases Table where I input what purchases I make for the company. How can I set it that when I purchase an...

So I need to format a cell to create lot numbers. I want it to be the SupplyID-Date-Ascending number I have figured how to get the first two parts, but the last part needs to be an ascending number for every different ingredient, so I can't use the lot autonumber for instance. For example, I...

Hey guys So I want to create invoicing history for the prices. I have done the same for the addresses and it worked but for whatever reason it doesn't work with the prices In the Order Details table I created a field called OrderPrice to indicate at what price that product was actually bought...

First of, let me say this community is amazing. You have helped me solve one problem after another and really helped me learn, so I'm grateful for that. Now onto the next and hopefully final one. I'm trying to create a list of my products with an add button that will be unconnected from the...

I have 3 reports printing for wholesale and retail customers When printing for wholesale everything is fine When printng for customers however, the OrderSum field (using a Dsum command) shows an error, even though the individual costs are all calculated correctly. In the relevant form it shows...

I seem to be blind but I can't find the error here. All it tells me is "Expected: =" but I don't think I'm missing one. Can you please tell me where I'm wrong? IIF("Paid"=False,docmd.OpenReport(QuotationR),IIF("Paid"=True & "AND CustomerType=" & "Χονδρικής"...

Hey I have a button that opens a query with a filter. It's supposed to show me the customer discounts. I have the following conundrum. I could possibly have multiple orders of the same item with the same discount. I don't want to see all of them. However, this discount might change at some...

So I have 2 sets of prices (retail and wholesale) and 2 sets of customers (retail and wholesale) I created an OrderPrice query so that it will recognise the type of customer and immediately draw the proper set of prices. So far so good Then this query I load on another query that has all the...

Hey all So I have an OrderF form with a subform inside for order details. I have made a combo drop down menu here to show me my products. The combo box is taken from a query with only one table. When I go to create a new record, I put the customer's data, but when I go to choose the products...

I have 2 identical buttons and one is working properly and the other is not. I have a form (SuppliersListF) that has a button to open another fom (SuppliersInfoF). When it opens I need it to be unfiltered, but also find the specific record I'm asking. However this one will always go to #1 no...

My database is in Greek so I'm suppying the picture below with explanations. I have an Order Detail Form and a Order List form. It just so happens that my returning wholesale customes sometimes call me and I need to have that total sum listed in their list. However, the total sum is an unbound...

I'm not sure where to post this, so I hope it works here. If not, feel free to move it around So I am new to access and I need some help I have a table with a customer code field and a customer type field. The customer type is simply 2 options (Retail or Wholesale) and I made it a drop down...