Recent content by mounty76

  1. M

    Solved Top values for unique records

    Perfect, thanks Bob, much appreciated
  2. M

    Solved Top values for unique records

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

    Multiple attachments and a report in the same email

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

    Multiple attachments and a report in the same email

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

    Multiple attachments and a report in the same email

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

    Solved User made command button that can be moved with mouse?

    This is fantastic, thank you very much MajP
  7. M

    Solved User made command button that can be moved with mouse?

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

    Solved User made command button that can be moved with mouse?

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

    Solved User made command button that can be moved with mouse?

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

    Solved User made command button that can be moved with mouse?

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

    Solved User made command button that can be moved with mouse?

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

    Solved User made command button that can be moved with mouse?

    Or another maybe better idea would be to have a subform to the side of the deckplan that just shows the job description of the dot that has focus? That way it would be easier to see just by clicking on the various dots what the job is?
  13. M

    Solved User made command button that can be moved with mouse?

    This is amazing, thank you. Yes I think having a grey dot as an unassigned job is a good idea then when it is dragged to 'create a new job' the popup frm opens whereby its data entry and forces the user to select all items.
  14. M

    Solved User made command button that can be moved with mouse?

    Thank you very much for this. I have made a few changes to the attached so it gives you a clearer picture. Basic changes would be 1. I have changed the table layouts to coloured dots that represent various priorities of jobs 2. I have added a Jobs table which would need to be linked to the...
  15. M

    Solved User made command button that can be moved with mouse?

    Thank you very much for this, much appreciated MajP. Something like this will work well I think, I'll have a go and let you know! I notice in your thread you mention about this not working well when in runtime mode? I was planning to have the FE in runtime mode when I eventually split the DB...
Top Bottom