Solved

Outlook style interface in Access 97

Posted on 2000-02-28
6
262 Views
Last Modified: 2012-06-21
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
Comment
Question by:mfb022800
6 Comments
 
LVL 4

Accepted Solution

by:
wesleystewart earned 50 total points
ID: 2566271
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
 

Expert Comment

by:VBExpert
ID: 2566309
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
 

Expert Comment

by:VBExpert
ID: 2566318
Another thought is a good GRID control might also work well for the right hand bulk of the application.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 1

Expert Comment

by:Phoat
ID: 2566869
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
 

Author Comment

by:mfb022800
ID: 2566936
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
 
LVL 4

Expert Comment

by:wesleystewart
ID: 2568702
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question