Recent content by mounty76

Great, thanks Doc Man, that is exactly what he is thinking, should do the trick nicely

Thanks everyone for your input, much appreciated. My IT guy said a virtual PC will do the job, he said its the younger brother of Citrix and that Citrix is an overkill for our needs (y)

Thanks guys, all good points but unfortunately our old NAS drive supports none of that :rolleyes:. Looking to potentially run it on a remote PC linked directly to the network

Thanks for the info Minty, much appreciated

Hello! I have a split DB with the backend on a server, FE is local on computer. The DB runs slow when connected over WiFi yet when using an ethernet cable to connect to the network it runs fast? Any ideas? The wireless network is a new high end Cisco network with WiFi 7 access points, my...

Thanks DBGuy

SOLVED! Just found a way to do it, however its automated in access after outputting forms to separate excel files. This works great and it keeps the same formatting as in the form.... :) https://www.access-programmers.co.uk/forums/threads/use-module-to-merge-excel-files.134480/post-623145

Outputting a form to excel works perfectly as it keeps the formatting and filtered data from the form into the excel sheet.....however I don't know how to output two forms into the same workbook.....I don't think its possible hence posting it here as a challenge lol

Hi All, I've searched everywhere and cannot find a solution for this. I want to export 2 forms into the same excel document but on different tabs. OutputTo the form keeps the formatting in excel, using the transferspreadsheet command gives an unformatted end result in excel. Is there anyway...

Perfect, thanks Bob, much appreciated

Hi All, I have a table which gets joining and leaving dates for crew, it is something like this: SeatimeID, CrewID, JoinDate, LeaveDate The CrewID is linked to a crew table and so therefore the data in the seatime table looks something like this : 1, 120, 1/1/23, 2/1/23 2, 12, 12/1/23...

Thanks for that.... I see now 🤦‍♂️

No I don't have Option Explicit declared in the module. afiles is meant to be the URL to where the PDF is stored which needs to be attached to the email, but there are several PDFs that need to be attached, hence the loop....I would suggest there is a high likelyhood that I'm not using it...

Hi All, I have a field in a table that holds file paths to PDFs of invoices, I am trying to put some code behind a button that attaches the invoices that have not yet been sent to the office, also there is a report that I would like attached to the same email. I have the code below but it is...

This is fantastic, thank you very much MajP