Howdy all, first time on these forums and I figured I may as well ask away. I've searched all over for a similar solution (including the forums before I posted), but I can't seem to find it. So here hopes someone might have the answer I've been searching for, makes 3 weeks that I can't find something.
I'm fairly proficient with access in most respects when it comes to forms (as well as reports) design, query building, table structure and relationships. However, I (for the life of me) cannot code worth squat in VBA (used to be able to back in high school, but not now).
I'm developing a database that contains directory information for the building I work in. I'm a security guard/front desk attendant and while the client does provide us with access to their global Outlook/Exchange address list, it's not exactly what one would call 'user-friendly' or up to date. We have some guards that aren't exactly computer gurus and they really hate having to dig up contact details for info. Not to mention the exchange servers tend to die frequently for some reason lately.
So, I and a fellow co-worker decided to work on a database that would contain all the current information necessary to be able to contact people as well as be able to locate their office in the 14-storey building that we occupy. He's already laid out the necessary table structure and data needed. While he's good getting the data laid out, he's not that great for GUI design, but I am due to going to college for graphic design.
Now here's our predicament. What we would like to do is to be able to display the floor plan along with an indicator on the screen as where a person's office is based on the floor indicator and office number in the record info (which will most likely be a set of x,y co-ordinates).
Now that being said, the images have to be stored in the database due portability requirements (as this database will be stored on 2 computers as we don't have a common network share available for the staff to use). I know it's a big no no, but I have to live in the means of what we're provided.
Here's a few things to keep in mind:
- We're stuck using a standard Access 2003 installation, so ActiveX controls that aren't part of the standard Access installation are forbidden due to network security requirements.
- I'm not afraid of having to build new tables, queries, etc. in order to accomplish this goal.
- Don't be afraid to get technical if you have to, I have an IT background despite my attending design classes. (Major in Graphic Design, Minor in IT Support)
If anyone can lend me a hand, I'd appreciate it. I only have one table at the moment with the directory information, I haven't built the table to contain the images yet. Here's the basic breakdown of the Directory table, I know that the field names could be changed to something more usable, but I don't want to alter this table too much as the data is imported from an Excel spreadsheet that's sent to us when people move around, hired, etc.
If anyone can take a crack at this for me, I'd appreciate it. There's no deadline as this is completely voluntarily on my and my co-worker's end. We're just doing this to help streamline some of the workflow.Code:Field Name|Data Type|Comment ID|AutoNumber| Room|Text|Room numbers are stored as text due to some rooms having a letter appended to the number (ex. 1102a) Flr|Number|Floor Number Surname|Text| Initials|Text|Initials or first name where available. Rank|Text|Building has some Military personnel in it. Phone|Text|Stored as text due to input mask involved as well as extensions. Group/Wing/Formation|Text|Primary Group (due to military personnel in building). Division/Unit/Ship|Text|Second level of command organization. Section/Sub-Unit|Text| Position|Text|