Recent content by KadeFoster

  1. KadeFoster

    Not sure where to start.

    Yeah a little but the alternatives are interesting as well. I didn't think this would get replied to quickly. OK i'll give this/these a go and see how it works, and try to understand whats going on.
  2. KadeFoster

    Not sure where to start.

    Hey all, Has been a while since i have been on here. I am tying to create a weekly report. So today -7. TASKID Status Updated 130 Scaling 1/12/23 130 Completed 2/12/23 131 Completed 25/11/23 132 Completed 2/12/23 134 Scaling 22/11/23 134 Scaling 4/12/23 134 Completed...
  3. KadeFoster

    Update Another Tables Record

    Well there you go, i didn't think that worked with a split database. Poor knowledge on my behalf.
  4. KadeFoster

    Update Another Tables Record

    My Database is split.
  5. KadeFoster

    Update Another Tables Record

    Am still learning, and yeah i agree duplication is not good. I have one table where i keep the records for the Inspections and the main table keeps the information regarding that inspection. What i was trying to do is Update the status of the Inspection Overview each time the user adds an...
  6. KadeFoster

    Update Another Tables Record

    Its under an triggered by an Update Button
  7. KadeFoster

    Update Another Tables Record

    Hey all, I am trying to update a record in another table when i create an update in the current table. I finally figured out the SQL to get it to update for the selected record, but the problem i am having now is that it updates the previous Status not the one that i just set...
  8. KadeFoster

    Solved Need Help

    OK i feel like an idiot, but yes it did fail due to the fact that there was a Null value. It was not in the TCRAInspectionT.InspectedDate field but was in the TCRAID field in the TCRAInspectionT Table, as TCRAID is an FK in that table. Thank you every one for giving me ideas and in the end...
  9. KadeFoster

    Solved Need Help

    So when i run the query i get the below results. So when i delete Not In (SELECT TCRAID FROM TCRAInspectionT WHERE YEAR(INSPECTEDDATE)=YEAR(DATE())) from the criteria it works and shows all records. Also when i remover the "Not" from the statement it displays all the records even the ones i...
  10. KadeFoster

    Solved Need Help

    Hey All, I am not good with queries and my focus of my project has been my forms for getting the data in. Unfortunately one of the queries i had has broken and i cannot work out why, due to my lack of understanding and limited knowledge of them. So i have a continuous form that "was"...
  11. KadeFoster

    Disable "Not Responding"

    This has given me a lot to look into, a very constructive discussion. I will read up and watch the info you have all suggested and try to come up with my solution. This is why i love these forums, not that i post heaps but yeah.
  12. KadeFoster

    Disable "Not Responding"

    Hey all, OK so in my project I have automated the copying of files from the BE location to the FE location. This process takes about 1 minute as there are a few gig of maps to copy across to the end users FE location. While the code is executing the Access bar goes white and says No...
  13. KadeFoster

    Open To Suggestion

    Simple is good tho. I am a VBA noob.
  14. KadeFoster

    Open To Suggestion

    Awesome man I'll have a look. I am still relatively new to coding bout 6 months into this project, just trying to automate my job away lol. Unfortunately the maps I am working with are not Google maps but underground mine plans. The engineers use a program called Deswik to generate the maps...
  15. KadeFoster

    Open To Suggestion

    That sounds like not a bad idea, i would think the image would be reasonable in size. Over lay a table on top of the image and just address each cell, fill each cell with a colour. I guess i could then just export it as a pdf, so then some one to use the map with the colours overlayed from the...
Top Bottom