Well, thanks for the praise, much appreciated. Some answers to your questions:
Your strongest point? Management. User Management and that Treeview manager is amazing! You said you gleemed most of this from UA, did that management page come from here too? You should post that to the code archive because it would really open the treeview world to some of the newer users.
Well, the treeview had me pretty much daunted when I started out with it. I found bits and pieces of code all over the net, but none of them really seemed that intuitive to me. So I got my hands dirty and figured out a simple quick way to work with the treeivew on my own. Let me know if you want table and code structure.
One thing I don't do is user login management. What schema/ model did you select for this? Most of the DB's I do are for individuals who don't want/ need the passwords.
For this part, I just use windows network login, which you can get from an api call. I used the code found at http://www.mvps.org/access/api/api0008.htm
. I dont use passwords, because the windows password will be stronger than anything I can devise in access! Note that the environ("Username") method is easy to spoof (simple as using a dos promt!). I assign permissions based on the username, and what levels of the tree they can see and actions they can perform. Each record that is added or amended to the database also gets tagged with the username, so we know exactly who has added/amended what.
I see you are calling Google maps, is that slow to load?
Nope, not google maps. We have a need to pass maps between various applications. For example, we populate a word document and an excel spreadsheet with a map. The best way that I have found to do this, is allow the user to create a map in Microssoft MapPoint, save it as a jpeg and then attach that jpeg file to the database. That way, at any time I need that map, I just need to lookup the tblsite.mappath field value where tblsite.siteid = x. I do that with ado recordsets in excel and word. I didnt really show it on the userform where you saw the maps, but if you click on the small map, a new popup form opens with a full screen map. You will also note that I have linked to Streetmap (www.streetmap.co.uk), which I call like this:
Me.cmdWeb.HyperlinkAddress = "http://www.streetmap.co.uk/streetmap.dll?postcode2map?code=" & Me.txtPostcode & "&title=" & Me.txtSiteName
I am going to copy your company form, I have drifted from tabs for some reason, but really need to get back to them. Those are buttons that display a subform though right? Not an actual tab control? If it is a tab control, how did you get the tabs to change? (or are the buttons simply placed over the tabs?).
Yeah, I am still not convinced by this form. It is a tabbed form with subforms on each tab, using Access 2003. I've tryied to stick away from tabs and multiple subforms, mainly due to speed. And this form doesnt *really* fit in from a ui point of view. But it isnt used that much, so left it on my to do list.#
A listbox for associated files! Why haven't I thought of that? I have been using a continuous form, but no more thanks to you. Are the attachments reading the file attributes (like Date) or is that the date the attachment was added?
No, the date field shows the date that the file was attached. Although it wouldnt be too difficult to get the file attributes, there wouldnt be much use in that for our circumstances.
How do you print to PDF? Hard coding, add-on, .dll, or print driver such a CutePDF?
This bugged me for so long I cant tell you. I tried so many methods and drivers that it was driving me crazy. Most of all I wanted something free! I was just about to try the Adobe version ($$), until I stumbled on this http://sourceforge.net/projects/pdfcreator/
Woot! A pdf creator with a com interface that you can control from vba!! After quite a bit of trial and error, I got this working 100% in all my MS applications (Access, Word, Excel).With access, for example, if I want to email a report out, I can print the report to pdf, attach it to an email and then send it to pre-specified people in my database and keep a record of all of that. All from one simple form. Let me know if you want some vba code to go with this.
Finally, a critique. Obviously you are not showing every form, but the last two in the presentation seem to be a departure from the rest by using a large amount of light blue.
Couldnt agree with you more, this is on my to-do list! A relic from a previous version of the database.
Downloaded it and think your work is beautiful. On the "company and contacts" form, I don't see info about the company as the name implies, wondering if a better name this form might receive. Other tabs indicate that there is more info available than what "company and contacts" implies. One form used the word "contact" and "person" (radio button). I would make that consistent (both "contacts"). Not much that can be said critically, it would be getting into personal tastes. Truly professional work! Thanks for sharing and Merry Christmas.
Thanks for the kind words. To be honest, there isnt that much info on the company, other than whats found on the address tab. But yeah, this part of the database hasnt really sat well with me. Suffice it to say that certain other people in the company want certain things reflected in a way that I dont agree with either; and I am tired of arguing to the contrary!