Page Index Toggle Pages: [1] 2  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Type size od database list (Read 2467 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Type size od database list
Jul 8th, 2011 at 3:40pm
Print Post Print Post  
Is there a way to increase the type size of the list of Database names?
  

**
Captain Infinity
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Type size od database list
Reply #1 - Jul 8th, 2011 at 5:46pm
Print Post Print Post  
Also, How to remove a database from that list? Once I opened the backup copy of a database and since the name is the same, unless I remove that from the list, one is likely to make mistake and work with wrong database.  In other words, the question is what does control that list?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Type size od database list
Reply #2 - Jul 8th, 2011 at 5:49pm
Print Post Print Post  
Infinity wrote on Jul 8th, 2011 at 3:40pm:
Is there a way to increase the type size of the list of Database names?


Hello Scott,

Which are you trying to make larger the font on the list of DB files that appear in the Open Dialog or on the Menu Tree for Recently Used Files?

-Ray

Bharat_Naik wrote on Jul 8th, 2011 at 5:46pm:
Also, How to remove a database from that list? Once I opened the backup copy of a database and since the name is the same, unless I remove that from the list, one is likely to make mistake and work with wrong database.  In other words, the question is what does control that list?


Hello Bharat,

On your system in the C:\Sesame2 folder will be a file named sesame_recent_files.txt. What you are going to want to do is open that file with Notepad, remove the ones you don't want shown, and then save it.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Type size od database list
Reply #3 - Jul 8th, 2011 at 6:39pm
Print Post Print Post  
Thanks Ray. Got it.
  
Back to top
 
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Type size od database list
Reply #4 - Jul 8th, 2011 at 8:02pm
Print Post Print Post  
The list of Forms that appear on the Application Menu tab.  Back when I designed this, you and Erica helped me set up the colors so that the Add section is Green and the Search section is Blue.

We do not use the button menus.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Type size od database list
Reply #5 - Jul 11th, 2011 at 1:39pm
Print Post Print Post  
Hello Scott,

Can you post the Code in your On Application Open event that is changing the colors. I believe I can modify that to make the names appear larger as well.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Type size od database list
Reply #6 - Jul 11th, 2011 at 3:23pm
Print Post Print Post  
I think this is all of it.  Thanks for your help, Ray.

Code
Select All
#include "sbasic_include.sbas"

Var vList as String
Var vCount as Int
Var vLoop as Int
Var vApp as String
Var vDB as String
Var vTemp as Int
Var vColor as Int

// Contracts and colors the Command Tree mode items
vApp = @Application
vList = @ListDatabases()
vCount = @CountStringArray(vList)
For vLoop = 1 to vCount
	vDB = @AccessStringArray(vList, vLoop)
	vTemp = @ContractTreeItem(vApp + "!Forms!Add Data!" + vDB)
	vColor = @RelabelTreeItem(vApp + "!Forms!Add Data!" + vDB, "@C8257536" + vDB)
	vTemp = @ContractTreeItem(vApp + "!Forms!Search/Update!" + vDB)
	vColor = @RelabelTreeItem(vApp + "!Forms!Search/Update!" + vDB, "@C32256" + vDB)
Next
vTemp = @ContractTreeItem(vApp + "!Forms!Add Data!")
vTemp = @ContractTreeItem(vApp + "!Forms!Search/Update!")
 



  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Type size od database list
Reply #7 - Jul 11th, 2011 at 4:22pm
Print Post Print Post  
Hello Scott,

Try:

Code
Select All
#include "sbasic_include.sbas"

Var vList as String
Var vCount as Int
Var vLoop as Int
Var vApp as String
Var vDB as String
Var vTemp as Int
Var vColor as Int

// Contracts and colors the Command Tree mode items
vApp = @Application
vList = @ListDatabases()
vCount = @CountStringArray(vList)
For vLoop = 1 to vCount
	vDB = @AccessStringArray(vList, vLoop)
	vTemp = @ContractTreeItem(vApp + "!Forms!Add Data!" + vDB)
	vColor = @RelabelTreeItem(vApp + "!Forms!Add Data!" + vDB, "@m@C8257536" + vDB)
	vTemp = @ContractTreeItem(vApp + "!Forms!Search/Update!" + vDB)
	vColor = @RelabelTreeItem(vApp + "!Forms!Search/Update!" + vDB, "@m@C32256" + vDB)
Next
vTemp = @ContractTreeItem(vApp + "!Forms!Add Data!")
vTemp = @ContractTreeItem(vApp + "!Forms!Search/Update!") 



-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Type size od database list
Reply #8 - Jul 11th, 2011 at 6:45pm
Print Post Print Post  
Thanks Ray, I like that.  I'll incorporate it and see what the others think.
  

**
Captain Infinity
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Type size od database list
Reply #9 - Aug 10th, 2011 at 11:53am
Print Post Print Post  
Thanks for your help with this, Ray.  The look of my application went from this:
http://www.jamiara.com/temp/Application-Menu-before.jpg
to this:
http://www.jamiara.com/temp/Application-Menu-after.jpg
Which I like.  Not sure what my co-workers will think, but I'll find out soon.

Do you think there might be a way to increase the size of the form names as well, when the database gets expanded?
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Type size od database list
Reply #10 - Aug 10th, 2011 at 3:15pm
Print Post Print Post  
Infinity wrote on Aug 10th, 2011 at 11:53am:
Do you think there might be a way to increase the size of the form names as well, when the database gets expanded?


Absolutely! You just need to use RelabelTreeItem() to rename the forms as well. So you'd use @ListFormsByDatabase() inside the current For-Next Loop, listing all the forms for each database and loop through that list relabeling them as you go.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Type size od database list
Reply #11 - Aug 10th, 2011 at 4:33pm
Print Post Print Post  
Thanks Ray.  I'll have to do some experimenting to see if I can create the code.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Type size od database list
Reply #12 - Aug 10th, 2011 at 4:51pm
Print Post Print Post  
If you need a hand with it just let me know and I can give you a hand with it.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Type size od database list
Reply #13 - Aug 10th, 2011 at 6:03pm
Print Post Print Post  
Current feedback from my folks is that the font is too big.  I'm not sure if that's just because it's new and they're not used to it, or if it's too big.  Is the size adjustable?  I imagine it has something to do with the arcane strings "@m@C8257536" and "@m@C32256" in the code, but they're alien to me.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Type size od database list
Reply #14 - Aug 10th, 2011 at 8:55pm
Print Post Print Post  
Hello Scott,

Well the size is adjustable but only between sizes 11, 18 and 24 point. You're currently using size 18, and 11 is the default size. So....

Those codes are a bit alien but that's cause they are commands of the underlying GUI library that Sesame uses and not a normal feature of Sesame. Kind of a behind the scenes thing.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Page Index Toggle Pages: [1] 2 
Send Topic Send Topic Print Print