Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Outlook style interface in Access 97

I would like to have an outlook style interface for an Access 97 app.  By this I mean the shortcut icons on the left with the main window on the right. The app would have 2-4 main forms and a few predetermined reports. Any ideas?  
0
mfb022800
Asked:
mfb022800
1 Solution
 
wesleystewartCommented:
You could put a tall, skinny form on the left with no border.  You could stick some images on it for buttons.  That much is easy.  Integrating the rest of the interface to make it "OutLookish" would require some creativity.

Another option might be one big form with a subform on it.  You can programatically change the sub-form depending on which button the user clicks.  If your app is simple (sounds like it is, with just a few forms and reports) this might work.

Another option is one big form with a tab control taking up most of the right side of the form.  You can display tabas based on which button the user pushed.  Essentially your app would then only have one form.  I have built one like that, and it works pretty good.

Otherwise, I think you're stuck with the boring old Access interface.  Best of luck!!

Wes
0
 
VBExpertCommented:
Yes the form on the left will require a nice treeview control to be populated with your Outlook type navigational data.  

Sheridan offers a nice treeview control I like to use personally for that part.  The form on the right is going to be populated almost entirely by a great big LISTBOX or a series of listboxes which are kept in sync (whatever is selected in one is also selected on the others).

Don't forget to let us know how it turns out!

0
 
VBExpertCommented:
Another thought is a good GRID control might also work well for the right hand bulk of the application.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
PhoatCommented:
i made something simialar to what your describing.. i used sheridans listbar activeX control along with a tabcontrol to change the forms... There is an easier way to do this by using a subform and then changing the source property of the subform when the icon is clicked...

I can't think of a way to do it tho without any activex controls.
0
 
mfb022800Author Commented:
Your first two ideas were the two that I thought of but wasn't sure of.  The idea of one form with buttons and multiple subforms seem the best approach, as least for me.  What I was hoping for was some outlook control.  But come to think of it the subform method is really like that.  The tab control I didn't think of, but I realize that it will wokr great for another project.  Thanks, Wes and to the others which responded!
0
 
wesleystewartCommented:
Happy to help.

You might want to follow this up with another question about the controls mentioned in the comments by Phoat and VBExpert.

ActiveX controls don't get much discussion here in the Access topic.  I think there is a slight bias against using third-party (or even Microsoft) activex controls in mdb files among the experts that contribute to this topic.

Wes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now