Search results

Hi Everyone :) in need of some assistance if possible! I want to be able to capture only visible fields from a subforms datasheet, export to excel file and attach to email. I can toggle visible columns on the subform's datasheet, export as excel attachment (via docmd.transferspreadsheet) to...

Hi All, I want to open up a form and on-load have a multi select listbox have its values already selected based on a table/recordsets values. I think I need to loop through both the recordset and the listbox but im not sure on the correct code. My failed attempt, For Each varItem in...

Hi All, I'm looking for help/advice in regards to calculating an end date for a variable period of time in minutes factoring in, working days, fixed working hours, fixed break times and holidays. I've tried to work it out via queries but kept hitting either a "Query is too complex" issue...