Search results

The order could be for multiple products, but the quantities of each product ordered could be split into multiple deliveries of varying amounts. We work in manufacturing for construction so the customer might order a bulk amount but want specific quantities delivered sporadically when required...

I was thinking an autonumber was the way to go as my colleagues would require the database to generate a unique order number (our reference number for the order). Is there a better way of doing this then instead of using an autonumber? As gasman said, it is more of a 'company key' which we will...

Thanks for the link, this looks great as guide but as I have already followed Allen Browne's Inventory Control: Quantity on Hand guide I am sort of forcing it to work with what I already have. I have added a shipments table and it's looking promising but now the problem is getting it to work...

Hi, I have created a company stock database which is working well but I am looking to expand its functionality to more of a customer orders database with the stock side of things being a feature rather than its primary use. I have been updating the customer order numbers manually based on...

Hi, I have a query which runs the following syntax to show the inventory totals for all products based on a specific date (Onhand is the function to calculate the inventory totals): OnHand([Product_Code],Format([Enter stocktake date to report on],"mm/dd/yyyy")) In this instance the user...

Hi arnelgp, Thank you for your input, I have got that working now. However, how can I change the code to allow the user to only select one criteria (such as product code, so all due in dates show for the specified product code) or none at all (so all records show in the report)? Currently an...

Hi Adiga88, I tried the following but again I got a Type mismatch error, probably for the same reason as my previous reply Me.Filter = " Due_In_Date =#" & Me.Text16 & "#" And "Product_Code = " & Me.Text11 Me.FilterOn = True Thanks, Chris

Hi theDBguy, I tried the following: DoCmd.OpenReport "Active_Purchase_Orders_Report", acViewReport, , "Due_In_Date=#" & Me.Text16 & "#" And "Product_Code=" & Me.Text11 But I am getting a Type mismatch error so must be doing it wrong. Will the Wherecondition work even when the user doesn't...

The form has a command button which the user clicks to open the report. This is the command button code: Private Sub Command14_Click() On Error GoTo MyError DoCmd.Close acReport, "Active_Purchase_Orders_Report", acSaveNo DoCmd.OpenReport "Active_Purchase_Orders_Report", acViewReport...

Thanks for your reply theDBguy. I am unable to get that working. Please can you provide an example of the the syntax using my current syntax as reference? FYI, the 'Product_Code' is typed into 'text11'. Also, how would I get around the fact that the user may want to filter by two fields or...

Hi, I am using the Filter property in the Report Property Sheet and it is working great when filtering one field. However, I would like to filter by multiple fields at one time. This is the syntax I am currently using in the filter property: Date_Due_In...

Hi, I have attached a couple of images to show you what I would like to achieve. I would like to change the subform with the yellow background so the shading is similar to the subform with the red background. I used the form wizard to create both but selected Tabular for the red subform and...

What I mean is my subform is datasheet and I would like to edit its appearance. Am I able to change it to a different format so I can edit it? Thanks, Chris

Hi, I have a form with a subform and would like to change the subform layout from datasheet to tabular without having to redo the whole form, is this possible? Thanks, Chris

Thanks Isaac, that is a great suggestion. I will give it a try and see how it works in my database. Thanks also for your help in resolving my issue. Chris

Thanks very much for your help theDBguy, in the end it was a very simple solution as I thought it might be. It was difficult to explain exactly what I required help with so maybe next time I need help I should attach my database from the start. I used the below for my query and it's all working...

Oh, okay, I was trying to run it in a query and was getting 0 but I can see it's working in the immediate window . Ideally I would like the user to be able to choose an arbitrary date and for it to return values for all products at the same time. I have sometime like this working with my query...

Going by what you have said there I am concluding that you are right, as that is what the total should be. The first stocktake data for Product 1 is 1413 and there wasn't any transactions before 8/1/20 so that value is right. I am doing it wrong as I get a value of 0. How did you get it to...

Hi CJ, I have attached my database to this post. I am currently using the code (named Quantity_On_Hand) with the query 'Quantity_On_Hand_All_Products_Query' and it returns the current quantity on hand for every product, just as I want it to. However, as well as the current quantity on hand...

Thank you theDBguy and Isaac for your kind help but unfortunately I haven't been able to get your suggestions to work. They both return a zero so it seems it isn't calculating the quantity on hand as of the previous date, or I am doing it wrong... Looking back at Allen Browne's original article...