Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • 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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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