Hello everyone, I am in need of assistance I have tried to go on this on my own for a while now and no googling or blog reading has got me any closer to the end result and I hope anyone here can help. my problem as follows:I have included a test DB at the bottom with fake everything but with the problem in hand. As you will see with my failed approach I can see the 5 employees listed "5" times each with theirs Training Status displayed as "All Good" or "Expire"In this small DB the only employee…See More
"Hi Steve I am no expert in fact I am more of a newbie, I took a look at your problem and since I am in need to learn I attempted to make it work as close as you want it.. here is what I came up with, I hope it helps you a little bit..
Following on from my last blog "Adding a "Check-list" to your MS Access Database" it's a simple step to add multiple Check lists. Adding Multiple Checklists to MS Access 1 Time --- Description0:35 Sample Data a "Wedding List Spreadsheet" found on the web 0:42 Fancy Spreadsheet modified so it will import ok. 0:57 This is the original list 1:17 The Imported Data 1:39 The "Group" Column is "Text" it needs to be a number 1:44 A Number like this Column "listSets" 2:19 Extract the "Text" into a new…See More
"Replace the first few lines of your code with these:-
Private Sub btnPopulateRequiredTraining_Click() Dim rstRSTTable As DAO.Recordset Dim rstTrainingList As DAO.Recordset Dim sSQL As String Dim rstFindRecord As DAO.Recordset Dim sSQLFindRecord As…"
"Hi Tony, I took a look at your presentation and I know understand how your function works.. Unfortunately I don't think I can apply it to simplify my code.. I have included a copy of the Function I use on a "Button"HERE:
I will msg…"