create "eudora" like application

ayufans
ayufans used Ask the Experts™
on
Hi, can someone tell me how to create an application immitating those of "eudora mail" ? I've pretty much sorted out the tree view part of it, but putting the windows like shortcut to each item being opened is confusing for me. Anyone can help ? basically, it's outlook express with links to forms like the one we have on windows when we open an application, where we can minimize and maximize the windows. Can anyone help me please ?

thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hmm, I do have a treeview application (in dutch) reacting on the different node-clicks.
I'll drop it in your mail.

Nic;o)

Author

Commented:
Hi Nico,

thanks for the application you send me. It's doesn't solve the problem quite yet though. I can use the treeview-nodes solution, but I haven't have any idea on putting shortcut link to the form that has been selected inside the application.

Anyone else have any suggestion ?

Commented:
Hi,

I don't have the time to "dive deep" into the treeview, but I ran into: http://www.experts-exchange.com/Databases/MS_Access/Q_20407528.html
that's also discussing the treeview control.
Perhaps there's some usefull information.

Nic;o)
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Hi Nico,

I've checked the link you gave me already. It seems like it was more to the tree view side than the shortcut side though. Like I said, I got the tree view thing pretty much sorted out already. But I really appreciate the link though. It haven't occured to me to actually populate the tree view from a db ^_^

Thanks.

Commented:
Hmm, what do you mean by "putting shortcut link to the form that has been selected inside the application" ?

Looks to me you only have to get the active node info of the clicked node...

Nic;o)

Author

Commented:
Hi Nico,

what I meant is that with every single node selected, there would be a shortcut available inside the application (instead of in the windows taskbar) so the user don't have to select that particular form from the tree view the next time he/she want to view that particular form.
So basically it's like windows taskbar where everytime we open an application/file there would be one shortcut added to the taskbar. How can I do that in VB ? but I don't want the shortcut of the form to show up in the windows taskbar. I want it inside the application.

Thanks.

Commented:
Then you'll need to make an additional table to store them.
You could show that on a form.
Processing to look like Windows (assuming 10 is the max) will be:
Update sequence number of rows by adding 1
Delete of row 11
Insert of new one with sequence number 1

Getting the idea ?

Nic;o)

Author

Commented:
Hi Nico,

sorry, but I don't really get it. If a frame is used, how would I put a shortcut once a node is clicked ? and I don't understand the logic you put in as well. Could you give me an example please ?

Thanks.

Commented:
What do you mean by "frame".
When you use e.g. a listbox, this will be bound to the temp table that's filled by the above described method.

In the OnClick event use:
currentdb.execute ("UPDATE tblShortCut SET SeqNo = SeqNo + 1;")
currentdb.execute ("INSERT INTO tblShortCut (SeqNo, schortcut) values ( 1, '" & node.shortcut & "');")
currentdb.execute ("DELETE * FROM tblShortCut WHERE SeqNo = 11")

Getting the idea ?

Nic;o)

Author

Commented:
Hi Nico,

sorry that I've been gone for a while. It's holiday for a week here, and I don't have internet connection at home.

I think I got some ideas about the logic now, but where should exactly should I put the shortcut ? I know that I need one more table to store the temporary value of the shortcut, but where should I put the shortcut that are going to be clicked by the user ? Should it be a command button or something ? and how would it resize it self once there were too much button on one screen ?

Sorry for not understanding most thing.

Thank you

Commented:
To "mimic" the File pull-down menu, you could use a combobox, but a listbox is possible too.
Both can be bound to the "tblShortCut"

Both also "solve" the size problem, just give it a try :-)

Nic;o)

Author

Commented:
wait a minute.. I don't intend to use listbox or combobox for the shortcut. I was thinking about using a command button out of all things. You give me an idea of using listbox or combobox though (thanx ^_^) but I still want to use command button as a shortcut which was put in a frame. Try to picture this (if the graphic can be sort out) :

-----------------------------------------------------------
* Node 1       |   form are shown here
* Node 2       |
  - Node 2a    |
  - Node 2b    |
* Node 3       |
* Node 4       |-------------------------------------------
* Node 5       |   I want to put shortcut here
-----------------------------------------------------------

do you understand the layout ?

Thanks

Author

Commented:
oh.. one more thing... from what I have in mind, the shortcut would be placed in a frame, so it would not 'go' anywhere.

Thanks.

ps: I'll increase the point to 150 ^_^

Commented:
Nice graphic :-)

OK, so you want 1 to e.g. 8 buttons to appear with a shortcut text.
To do so you would have to place them "invisible" on the form. When a node is clicked you add it to the temp table and depending on the number of rows you activate that number of buttons with as the caption the shortcut text.

Am I getting in the right direction ?

An alternative might be to use a Tab-control with the tabs on the down side. Then the number of tabs can be manipulated by the number of stored shortcuts in the temp table. Will probably resemble the sheet tabs in excel and I guess the scrolling when they get "too wide" is standard behaviour of such a control. (At least in access that is)

Nic;o)

Author

Commented:
Hi nico,

nice graphic ? ha..ha..ha.. c'mon ! he..he..he..

yeah, you're in the right direction. Thanks a lot. I'll give it a try, I think I would use the tab control if it is possible. I'll give it a try and let you know about it later ok ? ^_^

Thanks.

Author

Commented:
Hi again Nico,

I have got what I wanted so far, but this is the final question regarding this tree, form and shortcut stuff.

Now.. I finally use a tab strip out of anything else for the shortcut, because it could handle multiple shortcut without me having to do any more coding of it and I don't even have to connect to the db to store any value. And it's working fine for me.

However, one last thing I want to know is how do you prevent a node from being clicked on a tree view ? for every node that has been selected, there would be one tab created on the tabstrip with unique key. If I click the node again, it would try to create another tab with the same key as when it was first clicked. Here's the source code for it :

Case "q Port Code"
  fmPort.Show
  count = (fmTab.TabStrip1.Tabs.count) + 1
  tabx = "tab" & count
  Set tabx = fmTab.TabStrip1.Tabs.Add()
  tabx.Key = "Port"
  tabx.Caption = "Port Code"
  If fmTab.Visible = False Then
    fmTab.Visible = True
  End If
  tabx.Selected = True

as you can see everytime the node with the key of "q Port Code" is selected, I would add one tab with unique key. So, what I wanted to know is how to prevent the node being clicked if it has been clicked previously without using any db table ? The only thing I can think of is using a table, but I wonder if there's any other way around it ?

I'll give you the points once this is done he..he..he.. sorry :p

Thank you
Commented:
Preventing a click will be hard :-)
You'll need to check the created tab's for having the same shortcut before adding a new tab.
That can be done on the tab's shortcut, but could also be done on a temptable with a select.
When the shortcut is there, you do nothing...

Nic;o)

Author

Commented:
Hi Nico,

I've pretty much run out of idea actually.. and would use a temp table instead of not using them. I'll give the points to you because it's out of topics anyway if I wanted to ask it here, because it's not the same problem anymore. So, I wanna thank you a bunch for your time and suggestion all this time ^_^

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial