Results 1 to 5 of 5
  1. #1
    Stevecee is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    3

    Semi old question


    I'm somewhat of a beginner, newbie, wet behind the ears, user of Access, that being said, I feel comfortable trying darn near anything in Access.

    I've read through some of the threads in here and found a few that were similar. That being said, I'm sure there is some way to build a flow chart/block diagram in Access. To start, I don't have Visio, and neither does anyone else in my department, but everyone does have Access. We do physical surveys of sound/announcing systems in ships, logging all types of data in reference to the systems. Most of the equipment I look at is similar (speakers, etc.). We've been using Excel to build our flow charts/block diagrams, but that leaves little room to add the other data we need to see (load readings, wattage, grounds, etc.).

    Is there a way to build a database so that I cant print it out as an understandable "flow diagram"?

    Hopefully this made sense.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I think I did it in Excel. Access can open an instance of Excel and use its diagram objects to make the org chart.

  3. #3
    Stevecee is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    3
    Quote Originally Posted by ranman256 View Post
    I think I did it in Excel. Access can open an instance of Excel and use its diagram objects to make the org chart.
    Thanks for the reply, any chance you could post a sample?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    its NDA and I could not keep a copy.
    but basically the table had person, dept, owner, level
    sam, VP, null, 1
    bob, Acct, sam,2
    jill, general, bob,3


    the table shows the people, and the owner.
    then the boxes are built according to owner level
    it was a long time ago, but thats the basics.
    Google may have some examples.

  5. #5
    Stevecee is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    3
    Quote Originally Posted by ranman256 View Post
    its NDA and I could not keep a copy.
    but basically the table had person, dept, owner, level
    sam, VP, null, 1
    bob, Acct, sam,2
    jill, general, bob,3


    the table shows the people, and the owner.
    then the boxes are built according to owner level
    it was a long time ago, but thats the basics.
    Google may have some examples.

    I understand completely! I'll take the info you've provided and see what I can do.

    Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Semi-Complicated Median Query
    By gcgoode in forum Queries
    Replies: 35
    Last Post: 08-19-2015, 01:48 PM
  2. Semi-Nube Simple DLookup Issue - Help?
    By bimcompu in forum Programming
    Replies: 5
    Last Post: 07-26-2013, 07:21 AM
  3. Access to filter semi matches.
    By Shido151 in forum Queries
    Replies: 1
    Last Post: 04-23-2012, 06:14 PM
  4. Semi-colon Functionality
    By TheDeceived in forum Access
    Replies: 3
    Last Post: 09-22-2010, 10:52 AM
  5. Replies: 5
    Last Post: 01-22-2010, 08:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums