Search results

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

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

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

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

Hey all, I have a project that i am working on and i am slowly chipping away by doing little bits at a time. I am looking for suggestions on how to automate a process with access that i have to do manually along side using my DB. Below is a map, each one of those squares i have to inspect...

Hey all, I have a project that i have been working on and i am stuck with a query, I am relatively new to access, but have been working my way through my project slowly. So below i have a list of all my active maps(TCRA MAP LOOKUP). For each of these active maps i have to generate an...

Hey all, I am working through my project and have come up to a bit that is a little out of my skill level. Hopefully some one can help. I am working on all my inputs (forms) to make sure I can capture all the data I need from the user before I work on the Reports. Unfortunately I am learning...

Could some one please check over my tables and suggest what i can do to clean them up and relationships. I have an idea but i am lost on the path to achieve it. Gotta get the foundation totally right before i try for the forms. I am using access 2010.

What i would like to know is: Is making certain Cells appear when selecting an option from a drop down box possible. I am pulling the cells all from one table including the drop down selection. Example. Its to do with the jobs I do at work so it is in regards to that as options. [Drop Down...

Hey All, OK I want to post my idea here and see what you all think, am wanting know how complicated it is. I have attached what i am trying to turn into a database. It looks simple i guess but i would like to: 1. Have drop downs for names 2. Enter all info for the day - as its done at the...

Hey all, OK well I am from Australia and I live in a mining town in the Far North Western part of Queensland called Mt Isa. I work underground in a copper mine. I have an IT background (more hardware) and i am trying to learn how to make an access database for work, as I know it will make the...