Nifty Date Picker – With Year Selector Using a relatively unknown feature of a combobox, I have added a year selector to the Nifty Date Picker. It would be fairly simple to add a list of years into the combobox as a value list, but you would be stuck with a hard coded range of … Read more
MS Access Form Loads on PC Startup This video in answer to this question on Access World Forums (AWF) here:- DB on opening Win 10 — The OP wanted a Calendar Form (in MS Access) to load when the computer was switched on. To set this up, open your MS Access database, then open the … Read more
Nifty Access
Who we are Our website address is: https://www.niftyaccess.com. What personal data we collect and why we collect it Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymised string created from … Read more
ACRE Acknowledgement I have helped several Charities over the years and I was very pleased to see that the Alliance for Cohesion and Racial Equality (ACRE) a Reading based charity acknowledged my work in there 2014/2015 annual report Link HERE:- (PDF Download)I’ve taken the liberty of making an extract from the report because it’s 30 … Read more
Naming Convention Implementing a naming convention in your database is an absolute must. Now, I know I said that, but also, it isn’t necessary! So why do it if it’s not necessary? Well your database will function perfectly happily without it until.. One day you’ll give one of your text boxes, (or any object in … Read more
Welcome to Nifty Access! Welcome to Nifty Access! There’s a list of “Pages and Posts” on the right hand side, where you can look for things of interest. Then just below HERE there’s a link to Pages, Posts and Categories – A complete list of everything that’s on the site. There’s a Link to YouTube … Read more
Nifty Access Shop I've used these SELLFY download website for many years, I was lucky enough to be subscribed to their free offer when they first started. However recent upgrades to the Sellfy site have made it impossible for them to offer a free option any longer. I am using the first tier paid for … Read more
Testimonials Tony Hine who operates under the handle “Uncle Gizmo” has received thanks and acknowledgement from many of the people he has helped. Tony really enjoys the process of sussing out the OP’s problem and coming up with a suitable answer. I DON’T WANT TO BE HERE! – Click Here for Main Menu…… Nifty products … Read more
Combo Box Flow SELECT qryQAMeasures.ActualDateUTC, qryQAMeasures.LineID, qryQAMeasures.ProductFamilyCode, qryNEWESTProductFamilyStandards.SheetMin, qryNEWESTProductFamilyStandards.WidthMin, qryNEWESTProductFamilyStandards.LengthMin, qryQAMeasures.Name, qryQAMeasures.Value, qryNEWESTProductFamilyStandards.MaxOfMaxOfEffectiv eDate, ( SELECT AVG([Value]) FROM [qryQAMeasures] WHERE [Name] = "Sheet Length*" ) AS AvgSheetCount FROM qryQAMeasures INNER JOIN qryNEWESTProductFamilyStandards ON (qryQAMeasures.LineID = qryNEWESTProductFamilyStandards.LineID) AND (qryQAMeasures.ProductFamilyCode = qryNEWESTProductFamilyStandards.ProductFamilyCode) GROUP BY qryQAMeasures.ActualDateUTC, qryQAMeasures.LineID, qryQAMeasures.ProductFamilyCode, qryNEWESTProductFamilyStandards.SheetMin, qryNEWESTProductFamilyStandards.WidthMin, qryNEWESTProductFamilyStandards.LengthMin, qryQAMeasures.Name, qryQAMeasures.Value, qryNEWESTProductFamilyStandards.MaxOfMaxOfEffectiv eDate, ( SELECT AVG([Value]) … Read more
