Page Index Toggle Pages: [1] 2  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Box type (Read 1957 times)
KGMACLEOD
Member
*
Offline


No personal text

Posts: 9
Joined: Nov 12th, 2005
Box type
Feb 24th, 2006 at 12:22am
Print Post Print Post  
Can anyone tell me how to get box type to say No Box?
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Box type
Reply #1 - Feb 24th, 2006 at 1:14am
Print Post Print Post  
Hi Kristen.....

It sounds like you are looking for FLAT Box Style.

1.  Select the element(s)
2.  Go to the Property Editor
3.  Click on the tab for LOOK
4.  Go to the second combo box on the left, BOX STYLE
5.  Select FLAT

All selected elements should now have "No Box"

Be sure to Save Layout Design when you confirm it is OK.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
KGMACLEOD
Member
*
Offline


No personal text

Posts: 9
Joined: Nov 12th, 2005
Re: Box type
Reply #2 - Feb 24th, 2006 at 2:16am
Print Post Print Post  
Thanks for the help but I tried that but it still says flat not 'no box'. Any other suggestions? ???
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Box type
Reply #3 - Feb 24th, 2006 at 2:38am
Print Post Print Post  
Depending on what you want, you could use a flat box using the same fill color as the background, or you could use a flat box with the fill setting set to "none". In either case you end up with no visible box. It isn't really about box type, so much as it is about the fill setting.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
KGMACLEOD
Member
*
Offline


No personal text

Posts: 9
Joined: Nov 12th, 2005
Re: Box type
Reply #4 - Feb 24th, 2006 at 4:41am
Print Post Print Post  
That does make the box disappear. But it still says flat box, not no box as it does on the Company combo box on the Invoice form in the SesameSeasons sample file.  I was trying to duplicate that because I can't seem to get my list of Clients to appear in a database that I am trying to create.  The box seems to shrink down to a line when I click on the arrow and doesn't display a list so I thought it had to do with the way I was defining the box.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Box type
Reply #5 - Feb 24th, 2006 at 8:04am
Print Post Print Post  
My copy of that file shows the Company combo box as DownBox.....where are you seeing No Box?

It sounds like you have a combo box with no values to select from.  Once you have something to choose from that will go away.

Right click on the element, select EDIT CHOICES, and enter some values to see if that is better.

What code are you using to populate the combo box?
And what is triggering the programming? On element Entry?


  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
KGMACLEOD
Member
*
Offline


No personal text

Posts: 9
Joined: Nov 12th, 2005
Re: Box type
Reply #6 - Feb 24th, 2006 at 3:16pm
Print Post Print Post  
I made a DSR from the data base and on the Invoice form, if you look at Look/Position it says "no box".  the combo box is being filled from another file called "clients.db" in the same application.  here is the code:
VAR VCLIENTS AS STRING



//Populate the combo Box with list of clients
vClients = @XListValues("eis1.db", "client.db!Name")
vClients = @SortstringArray(vClients,0)
PopulateListElement(LE2, vClients)

It is performed 'on form entry' attached to the field called 'le2' which is defined as a combo box.  There is nothing much else on the form.  I am looking forward to Erika doing that course.  I never worked with Q&A 5.0 which I think might have helped some.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Box type
Reply #7 - Feb 24th, 2006 at 3:38pm
Print Post Print Post  
Hmmmm. I checked that application on another system and I see the "No Box" that you are referring to.  I wonder if I had changed my other copy?  How did they do that?

But more important is that your programming statement is not correct.  You should be using the following syntax:

Code
Select All
Var vClients as String

//Populate the combo Box with list of clients
vClients = @XListValues(@FN, "FormName!Client")
vClients = @SortstringArray(vClients,0)
PopulateListElement(Client, vClients) 

Assumes that combobox is named Client
Replace FormName with the name of your form that you are getting Client info from.

And there is nothing here related to Q&A 5.0. 
Your 4.0 experience will serve you fine.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Box type
Reply #8 - Feb 24th, 2006 at 3:59pm
Print Post Print Post  
Quote:
Hmmmm. I checked that application on another system and I see the "No Box" that you are referring to.  I wonder if I had changed my other copy?  How did they do that?


Hello Bob,

What you are seeing is a side effect of a fix in 1.1.2 that allowed Combo Boxes to have different Box Types. Since that app was designed before 1.1.2 it did not have a Box type set. It has no bearing on how a combo box works.

-Ray
  

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



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Box type
Reply #9 - Feb 24th, 2006 at 8:28pm
Print Post Print Post  
I have noticed if I create a new Combo Box LE, the box type does indicate "No Box". Once I change it to something else, I can never get it to say that again.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Box type
Reply #10 - Feb 24th, 2006 at 8:38pm
Print Post Print Post  
Hello Carl,

New Combo Boxes will say "No Box" until you save, close and re-open the form. The default Combo Box style is a "Down Box". Once you save, close, and re-open the form you will see the box type will say "Down Box".

-Ray
  

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


No personal text

Posts: 9
Joined: Nov 12th, 2005
Re: Box type
Reply #11 - Feb 25th, 2006 at 4:09am
Print Post Print Post  
Thank you all for  your help.  It is really unsettling to see Bob's baby and Ray's reaper juxtaposed but I quess I'll get used to it.  Thanks again. Roll Eyes
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Box type
Reply #12 - Feb 25th, 2006 at 6:38am
Print Post Print Post  
So, what is the current status of your problem, Kristen?  Do you still need some help here?
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
KGMACLEOD
Member
*
Offline


No personal text

Posts: 9
Joined: Nov 12th, 2005
Re: Box type
Reply #13 - Feb 25th, 2006 at 3:47pm
Print Post Print Post  
i HATE TO KEEP BUGGING YOU BUT HERE GOES.  THE BOX TYPE IS FLAT AND THE FILL MATCHES THE BACKGROUND DO THE APPEARANCE OF THE BOX IS FINE.  I ADDED 5 RECORDS TO THE CLIENTS_DB USING MY FORM CALLED 'CLIENTS_FRM'.  THE FIELD I WANT TO APPEAR IN THE COMBO BOX FROM THAT DATABASE IS CALLED 'NAME'.  THE NAME OF THE COMBO BOX CURRENTLY IS 'LE2'.  SO AT YOUR SUGGESTION I CHANGED THE PROGRAMMING TO SAY:

VAR VCLIENTS AS STRING

//Populate the combo Box with list of clients
vClients = @XListValues(@FN,"clients_frm!Name")
vClients = @SortstringArray(vClients,0)
PopulateListElement(LE2, vClients)

I SAVED IT AND WHEN IT DIDN'T WORK I THOUGHT MAYBE '@FN' MEANT 'FILENAME' SO I REPLACED IT WITH THE NAME OF THE APPLICATION WHICH IS 'EIS1.DB'.  I THEN TRIED REPLACING 'CLIENTS,FRM' WITH THE NAME OF THE DB WHICH IS 'CLIENTS.DB'  AND I TRIED THAT TWICE, ONCE WITH @FN AND ONCE WITH 'EIS1.DB'. STILL NO LUCK.  THE ONLY THING I HAVEN'T TRIED CHANGING IS '!NAME' BECAUSE FROM THE MANUAL IT SAYS THAST SHOULD BE THE NAME OF THE FIELD IN THE SOURCE DB AND THAT'S WHAT IT IS.  I'M SURE IT'S SOMETHING DUMB I'M DOING BUT I HAVE DOUBLE CHECKED THE SPELLING OF ALL THE NAMES I AM USING SO IT HAS TO BE SOME COMBINATION I'VE MISSED.  HAVING JUST SAID ALL THAT I HAD A THOUGHT.  IS IT ONLY THE XLOOKUPS THAT DON'T WORK IN PREVIEW MODE OR WOULD THAT BE TRUE OF XLISTVALUES?  OF COURSE I HAVE BEEN TRYING ALL OF THIS IN PREVIEW MODE.
  
Back to top
 
IP Logged
 
KGMACLEOD
Member
*
Offline


No personal text

Posts: 9
Joined: Nov 12th, 2005
Re: Box type
Reply #14 - Feb 25th, 2006 at 4:12pm
Print Post Print Post  
I TOLD YOU IT WAS SOMETHING DUMB.  IT WORKS FINE OUT OF PREVIEW MODE WITH THE CODE AS I HAD IT IN MY LAST MESSAGE.  I THOUGHT IT WAS ONLY THE XLOOKUP COMMANDS THAT DIDN'T WORK.  WHICH HAPPY FACE REPRESENTS 'DUH'?  I WOULD LIKE TO KNOW HOW YOU GUYS GET YOUR CODE TO APPEAR IN THOSE WHITE BOXES IN THESE E-MAILS THOUGH.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: [1] 2 
Send Topic Send Topic Print Print