Recent content by Philkred

Thank you MajP, I used what you linked and it worked perfectly :)

Yes I just found this thanks I shouldn't of asked and just looked better, however I dont this this will work as I'm using toggle buttons to hide each field ill upload an image of what the screen looks like.

Also quick question how would I lay this out if I have form > subform > subform/datasheet

Thank you for this, I will give it a go.

Thats the thing I'm not really sure how to do that with a datasheet/looping through it, I'm still learning! :)

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...

Ok I've tested it on both multi selection and single selections and it works, just worry that ive screwed up somewhere as it has to have the + 0. [emoji848] Sent from my SM-G965F using Tapatalk

1 Sent from my SM-G965F using Tapatalk

Right ok i think Ive got it to work by doing this, Me.TaskSelection.Column(0, i) + 0 = rs2!Task_ID I guessed putting + 0 because I tried adding + 1 and it selected the task above the correct selection but what did I do wrong to have to put the + 0 as without it doesn't work? Sent from my...

Ok thanks so now it doesnt crash but still isnt selecting anything, could it be that I need to use column instead of item data? Sent from my SM-G965F using Tapatalk

Hey, thanks for the reply CJ, however this now seems to lock up the whole database and access crashes :( this makes me think its endlessly looping somehow? Sent from my SM-G965F using Tapatalk

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...

Hey, thanks for the welcome messages! So I had two queries as per below, I've been editing them since so forgive the bad layouts/inconsistencies but hopefully you will get where I tried to go with it :D (I'm very much a newbie with Access/VBA/SQL) SELECT tblWorkHours.Workday_Start_Time...

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...