X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> My Newest System, Office 2007    
post May 20 2011, 11:01 AM

Posts: 13
Joined: 22-February 11

Hi All!
I have been working on this project for a while now and thanks to everyone for the code examples that get posted here. I incorporated a bunch of them. I figured I'd show everyone. I'll work on a stripped out copy to post as I have some original code that I can't share.
Right now, I am working on porting the data to SQL Server 2008 to make my IT department happy. I still have to tune the database and change my DAO code over to ADODB. My main routine, which is to schedule a new contract (About 1400 new rows between two tables), takes about 20 seconds to run when the setup was a normal access database. Once I changed it to a FE/BE setup, it takes about 7 minutes to run. Eventually, the plan is to try to create some three way relationship between SharePoint 2010 Access Web Services, a dedicated SQL Server with Analysis Services and the Access FE. I'm waiting on IT to finishing getting the bugs out of the SharePoint 2010 deployment and for Office 2010 to be distributed. One day, I plan on converting the Access FE to C#/F#.
I have kinda lost track of everyone's contributions so if you see something, tell me so I can give credit where credit is due.
System Login Screen. You can change your password. It is based on NTID and also has a Guest account that bypasses the authentication system. If the system sees that this is your first time entering the system, it will prompt you to change your password and select your default contract settings and theme.
Attached File  Login.JPG ( 29.73K )Number of downloads: 768

This came with the Login Form. I haven't decided if I want to keep it yet.
Attached File  Slpash.JPG ( 25.43K )Number of downloads: 556

THere is the main Workspace. If you unmaximize it, it becomes a border less form that I have made moveable if you click on the title and resizeable if you click on the lower left hand corner. I still have to expand it so you can click any border to resize. It was a pain to find the code to do this, so I think I will post that code to the wiki for everyone.
Attached File  Dashboard.JPG ( 61.61K )Number of downloads: 671

Each user can select their default contracts and such.
Attached File  User_Settings.JPG ( 37.54K )Number of downloads: 487

Here is where each user can manage their data.
Attached File  CDRL_Manager.JPG ( 150.58K )Number of downloads: 648
Go to the top of the page

Posts in this topic
- originalread   My Newest System   May 20 2011, 11:01 AM
- - MikeLyons   Looks quite slick - shows off some of the user int...   May 20 2011, 12:19 PM
- - dannyseager   My only comment (and this is nothing about the des...   May 20 2011, 02:25 PM
- - originalread   Thanks for the tip. I'll look into it. The mai...   May 20 2011, 02:40 PM
- - HiTechCoach   Looks great. Could you mind sharing which code exa...   May 20 2011, 05:00 PM
- - originalread   This is the workspace/sidebar I worked from: http:...   May 20 2011, 10:18 PM
- - HiTechCoach   Thanks for sha   May 20 2011, 11:20 PM
- - NigelShaw150   Hi made a routine to pass between dao & adodb...   May 21 2011, 06:59 PM
- - originalread   That would be great Nigel! I'm just using ...   May 22 2011, 10:07 AM
- - NeilT123   Hi OriginalRead, I have also recently used the Sid...   May 23 2011, 05:20 AM
- - HiTechCoach   Neil, It is best that you start your own question ...   May 23 2011, 11:08 AM
- - jhcarrell   Very clean look! I'm glad to someone has ...   Jun 1 2011, 11:04 AM
- - originalread   Update time! I have been working hard on getti...   Jun 24 2011, 04:14 PM
- - originalread   Sometime in the next week, I'll release the co...   Jun 25 2011, 06:50 PM
- - HiTechCoach   WOW! Looking forward to seeing it. :thumbup:...   Jun 25 2011, 07:39 PM
- - jhcarrell   Nice work. These are two of the features I've...   Jun 27 2011, 08:37 AM
- - originalread   I'll post when I get a free moment the code I ...   Jul 3 2011, 10:38 AM
- - HiTechCoach   Thanks for the update.   Jul 3 2011, 11:43 PM
- - originalread   Sorry all for the lack of updates. I got promoted ...   Jul 26 2011, 11:03 AM
- - HiTechCoach   Congratulations! Thanks for the update. Have y...   Jul 26 2011, 02:20 PM
- - originalread   It's been awhile. We lost a major contract bid...   Sep 18 2011, 12:55 PM
- - HiTechCoach   Thanks for the update. Looking forward to learning...   Sep 19 2011, 01:46 PM
- - HiTechCoach   Is this what you are using? Securing Connection St...   Sep 19 2011, 01:52 PM
- - originalread   I can't use windows authentication since I can...   Sep 19 2011, 04:18 PM
- - HiTechCoach   With Windows Authentication you do not add the use...   Sep 19 2011, 04:41 PM
- - HiTechCoach   The Cached connection should be exactly what you n...   Sep 19 2011, 08:12 PM
- - originalread   Woo Hoo! Thanks a bunch. Your advice set me...   Sep 20 2011, 09:19 AM
- - HiTechCoach   Glad to hear that it was helpful.   Sep 21 2011, 10:20 PM

Custom Search

RSSSearch   Top   Lo-Fi    24th August 2019 - 06:13 AM