Search results

Thanks for the info. As soon as i reach this part of my project I’ll come back with all the relevant files.

Sorry, I didn't realise. Wondered where it went.

Just an update, I've been working with this contantly since the day you created it. A big thankyou again for your hard work and expertise.

ChatGPT figured it out for me. -- Query the existing values for the specified ToolNo SELECT TotalHours, MaximumHours FROM Tools WHERE ToolNo = 'your_tool_number'; -- Update the TotalHours field by adding the ImportedHours value UPDATE Tools SET TotalHours = TotalHours + [imported_hours_value]...

My schema for the basic database is fine, it's just the importing and calculating as one stage that I am trying to work out. Think I've figured it out: SELECT SUM(TotalHours) AS Importedhours FROM ImportedData; then take the current value from my existing table, run my code based on the...

Forgive me if this repeats, my first reply didn't appear. I want to move away from excel, I need a way of importing into access and and calculating the imported data against the existing records and then using those results to create entries in another table if matching a preset criteria. I'm...

Hi all I'm currently planning to convert an excel maintenance sheet which I use to record servicing and repairs for each of our moulding tools. One of the things I used to do monthly in excel was to import a monthly exported report from our planning system which contained all the orders that...

Thanks. One thing is strange on that website, it says it's free, but then asks you for payment details?

Years ago I did a course on Access and learnt a lot, but since then I've not had cause to use it, But would now like to get into it a lot more. We used this book during the course "Microsoft Access 2000 Development Unleashed" and this is a very good book. but was wondering if there was anything...

Thanks again for this, it's just what I need. The make table query seems to break things, So I've left that alone. As you said, it's just as easy to build up as you go. which is fine with me.

Thanks for all of your work so far, The amount of calculations this does it astounding. On your form Dijkstra2 where I could enter the start/end I've linked the dropdown boxes to my own table of names so that I can select them, but I've been trying to get the resulting path into it's own table...

Looks like I need to do some cleaning up. Your results will help me a lot. 125k results, wow. This is why I ask the experts.

Wow, that's some work you've put in there, Many thanks. Now I’ve got the backbone of it all I can start building on this. Will be good to start re learning access.

Thanks everyone for looking into this. I've been looking at the Dijkstras algorithm myself but as you said, I basically want to enter a start location and a destination and find the shortest path between the two. The attached file has a list of all the nodes that I'm working with.

I'm trying to get my head around using the following data to create the shortest route between 2 places in a map using VBA in either excel or access. ID Name Connection 1 Connection 2 1 Location1 2 2 Location2 3 4 3 Location3 2 4 Location4 2 5 5 Location5 3 5 So...