Here' a GUI with a different approach. I'm furthering my attempts to make an Access application NOT look like a standard Access application. Heavy use of graphics and 'reaching around m'backside to scratch my ear' approach for image control. Of course, had I stayed with just normal Access controls and used no images, the code would have been much simpler. But then, it would not have the appearance it does. It was creatd in Access 97, presented here as a zipped Access 97 file and will covert readily to A2K, AXP and or A2K3. I have tested it in A2K7 and it fails miserabley. More conversion debugging to do there.
This interface is merely the stage make-up of an interesting tool already posted in the U.A. Code Archive: StriveForPeace's Backup To (and Restore From) Text Files. Her offering inspired the foundation for this little project. I would be amiss were I to fail to mention Arvin Meyer and Brent Spauling (datAdrenaline) for their respective parts in deriving the SaveAsText/LoadFromText procedures and such. And Leigh Purvis helped with the code for accessing a remote database. (Because my error trapping is not consistently comprehensive across the app, and the fact that I tend to employ Klingon commenting techniques, you may notice vast inconsistencies in the coding.)
The look is achieved by
• using Photoshop to create the "screen"
• taking screen-shots of the Access form(s)
• design/layout the main background
• applying cut-outs for the Access form controls
• then saving the cut and sized images as BMP files for more efficient integration into Access.
• repeat and rinse as necessary
This time, though, instead of just "butting" up the edges of all the image elements, I started with a comprehensive background that is fixed in size. This tends to dis-allow easy editing of the form's size because it would distort the image. One would need to re-do the artwork in Photoshop again to compensate.
My intent was to make a "Fun" GUI that included sounds. This one does. When you open the attachment, copy all the files to the same directory. There is just one Access 97 file and 9 short wave files for the sound portion. You don't have to use the audio files. The code was designed to auto-detect the presence of each audio file, and if it is not found, it won't play or throw an error. Also included is a switch on the main screen that will let the user turn the audio on and off, for when the audio files are in the same directory as the app and the baby is sleeping.
I chose to post here instead of the Code Archive because here, I have a greater opportunity to get feedback, StriveForPeace has already posted the meat and potatoes of the code in the archive, and it just fits better here.
Hopefully, if I do enough of this type of GUI, they might start actually looking better and have some real use.
All comments welcome.
(the image may also be clicked to download the fille)