Search results

Hi Gasman, I am not familiar with ASCII code so I'm not sure what you mean. If I'm being honest I don't really understand your idea at all (down to my lack of knowledge on some of the terminology you've used). Would you be able to explain it again? Thanks, Chris

As an alternative to the above, now that I'm not using autonumber for the order number I have a bit more flexibility with the number structure. It's not an issue if each part delivery is on the Customer_Orders table as a separate record however each part will need to be referenced A,B,C etc...

Thanks for the example. I have only started to use Access in the last year so I am struggling to make sense of how I can implement it into my database. However, I can see how the 'CustomSeqNum' in your example could be used in my database to generate the shipment number. At this time I think it...

No need to apologize, I am still learning Access so finding out the best way or alternative ways to use certain functions is fine by me. Thanks, Chris

Thank you for your advice, I think using the DMax method is the way to go. I've just got it working in the database and that is exactly what I need. I am still trying to solve my issue with having an order split into multiple deliveries. I'm not sure if I misunderstood your suggestion but would...

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