Search results

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

This is great, good job MajP. Last two things :-) Is it possible instead of deleting a job just marking it as complete with a date stamp, that way we have a history of jobs rather than just deleting it. Lastly is it possible to filter the jobs by department and/or priority with a combo box on...

Yes get the same. This really shouldn't be an issue as there shouldn't be unassigned dots on the plan, only where you grab a new one from, then in that case it assigns a new job. May be a fix would be that no dots can be left unassigned on the plan

HI MajP, sorry for the delay in reply, been a hectic couple of days. Is looking good, I'm not seeing the issues the that Mike is. With placing a new dot/job if you click once on the dot then click again and move it then it works fine, this must be a focus thing I think? The other feature that...

haha! We got plenty of liferafts! Thanks MajP, is working good. Attached is idea of the jobs pane. I think when a new dot is moved to the plan/deck then it would ideally open up a new record/job for this new dot that has been added, this would highlight as a new job in the jobs detail pane...

The deck attachments need to be downloaded into the file location of the db