Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dca
  • Order by date
  1. dca

    Subform will not work off a left join - need help

    I could use a combo box that lists the port number in column 2 and then uses column 1 to fill in the map-id in the connections table but this doesn't address some other issues. Each switch has a different port layout. Instead merely entering in connection information I was hoping the form...
  2. dca

    Subform will not work off a left join - need help

    I am working on a database to keep track of the devices in my SAN. Currently I have the following schema Table KeyFields SwitchInfo ID (SwitchID) ModelID ModelInfo ID (ModelID) ModelMap ID (MapID) ModelID Connections...
  3. dca

    I need to list all available ports (left join) in subform?

    I am working on a database to keep track of the devices in my SAN. Currently I have the following schema Table KeyFields SwitchInfo ID (SwitchID) ModelID ModelInfo ID (ModelID) ModelMap ID (MapID) ModelID Connections SwitchID MapID I have a SwitchInfo form which...
  4. dca

    Update embeded visio diagram from excel data

    I have an excel form for collecting application architecture information such as component deployment for application development projects. I would like to embed a Visio uml deployment diagram which may be updated from the information entered in the form. I attempted to use the flowchart...
  5. dca

    Excel - MS Query - Parameter Query

    Did you ever figure out how to do this? I am currently trying to do the same thing. I have performance data for all of the systems I administer in a sql server database. I linked the IN clause parameter field to a cell where I would like to list multiple systems and have the data returned...
  6. dca

    Two table join on datetime with unlike intervals - please advise

    I have two tables with information that I need to join together. One table has records for each server on a 15 minute interval containing system utilization metrics. I then have another table that posts records only when a system configuration change occurs. So records exist containing...

Part and Inventory Search

Back
Top