Recent content by Nevsky78

namliam, That is absolutely fantastic, thank you so much! Way, way cleaner. Thank you! Nick

Hi all, I am a very basic VBA user who has filled out some code for a continuous form multiple filter. The code is working quite happily. However, and this is more for my education, I'm sure the coding could be smaller and more efficient, but I don't know how! So I was wondering if anyone...

Hi Pat, Thanks for your response. The only way I can see to perform the custom primary key is after a selection has been made in the combo box. The ID is a combination of 2 other fields therefore those fields need to have been added for the current record to create the custom Primary Key. I...

Hi guys, I thought I posted a thank you yesterday but I think I had an epic fail somewhere and failed to actually post it! Thank you both for your help - I have gone with your suggestion Cronk which is working fine in not allowing duplicate values. My only issue with it is that I am using the...

Hi all, I have attached a simplified version of the issue I am having at the moment. I have tbl_orders which records orders. I have a linked table called tbl_order_lines which details the items against each order. In a nutshell, an item can only appear once in an order. However, I do not know...

Hi SOS, I was using the UK format for dates i.e. dd/mm/yyyy but I did convert them all to the US date format of mm/dd/yyyy to see if that helped. I think it must be some regional setting somewhere in that case...

Actually, even when I do that I still get an odd result! qry_running_total scode Date po_qty RunningTotal 10254 06/01/2013 40032 110160 10254 09/01/2013 30096 100224 I've attached the current database. Could this be a Database Sort Order issue? Mine is General Legacy...

Hi SOS, Apologies for the delay in getting back to you. I pasted that SQL in there but the totals are now blank. I think this is to do with your date format being US and my date format being UK. I guess I need to convert my UK date to US for this to work? Nick

Hi SOS, That's certainly an improvement, thank you! I did have the order in there previously but stupidly left it out on the uploaded version (I've also changed it to ascending date order) However, for the scode 10254 example the running totals look a little strange. scode |Date...

Dear all, I have searched in depth through the forums for an answer to this but all running sum posts do not quite answer my problem. I have a table ("tbl_idq_all") with a text field for product codes ("scode"), a date field (dd/mm/yyyy) and a quantity field ("po_qty"). This table therefore...

Hi plog, Thanks so much for that - that's far easier and just what I'm looking for! Excellent, really appreciate the help. Phew! Nick

Hi all, I have absolutely no idea how to solve this issue. I've attached a stripped down version of a small order database I'm working on. A user would enter an order, the amount and the date the order is required by. As you can see from tbl_seasons, the business has financial periods that...

Dear all, I have a table of data (tbl_marginsummary) with a record for every combination of Customer, Season, Brand, Month and StockCode. What I am trying to achieve with my frm_summary is some kind of DSum (or a query of possible) based on any, all or some of the comboboxes I have at the top...

After all that I worked out how to do it myself! Please find solution attached. Nick

Dear all, I have attached a simplified database highlighting my issue - AnnualSpread.mdb. I have users who create a project and enter one amount for the cost of that project for the whole year. For financial purposes I have to automatically spread that one amount equally across 52 weeks. In...