Smart route planning Inside a building

[bsugrue]

I got thrown into a new project at work using Access to build a data base, User input apps and smart route planning. Being semi new to Accesss, any suggestions on how I might go about this?



Thank you,
Brendan

[orange]

Welcome to the forum.
I suggest you tell us a little about yourself -how did you get volunteered etc.

What do these mean in your organization

User input apps and smart route planning

Some examples/expectations would help clarify.

[bsugrue]

I’m a new hire that got attached to a few projects. It’s been a few years since I’ve used Access and Excel (slowly catching up on these). Here’s what I’m trying to do.
Phase 1
-build a database of users
-build a database of units
-have a self-generating list that the database searches. Have work scheduled on them based on set parameters
-have the users entered new information based on service into a simple form (Tablet)
-display % of work completed on a master board

Phase 2
-implement smart route planning (from unit to unit) into the database to reduce “wandering”
-update info in real time via Wi-Fi

I realize this is a lot. Just trying to get a leg up on a project that was let drag for a few months. Any help would be appreciated.

[June7]

Still not sure what you mean by 'smart route planning (from unit to unit)'. What is a 'unit' - room, building, street, city or some other entity?

If you want a graphical display of 'route', might better invest in mapping software.

Did you Google or Bing: Access database shortest path route

[bsugrue]

Basically I’m trying to make google maps inside our warehouse that would allow our techs to have a preplanned route to follow for maintenance each day. Also have a database that we can enter what machine what need maintenance.

[orange]

?? How big is your warehouse??
Do you have some special affiliation/contract with Google?

I was aware of Google mapping public roads.

[June7]

What? You are mapping routes within a single building?

I have used ArcGIS to export vector data to XML file that can be loaded to GoogleEarth. Access can export to XML.

Have also done a little programming of web page embedded maps but far from an expert and I don't have access to the resources any more. And it wasn't easy.

But apparently none of that is relevant to your situation.

I suppose the shortest path algorithm can be programmed in Access but way over my capabilities.

[bsugrue]

?? How big is your warehouse??
Do you have some special affiliation/contract with Google?

I was aware of Google mapping public roads.

I'm just using google maps as a reference. Not sure of any other available programs. I'm new to this and just trying to figure out the right way to ask questions.

[bsugrue]

I don't have the exact size of the warehouse but we have several different wings. I got put on this project that was a stand still and trying to make the best of it.

[June7]

Only thing I can think of is you use a graphics software (MSPaint ?) to create a bunch of image (bmp, png, jpg, wmf) files of the various routes. Table has Start and End fields and another field with the image.

User selects start and end locations as search criteria and the correct image record is returned for display in an image control. No algorithm calculation.