Thanks, Albert, it's strange that I haven't noticed it before but I've always tried to link on IdNums of some sort so perhaps I've just been fortunate.
Happily, though, the form is based on views so, with luck, I can add a computed column that does a trick or two, link on those and rename the other links. Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, March 07, 2005 6:26 PM Subject: [RBG7-L] - Re: Dynamic size Scrolling Regions: a little local difficulty > Alastair, I have some databases that use double quotes because of this problem with single quotes > in name fields such as "O'Brien". You have to somehow double up the quote in the linking field so > it takes the quote as a literal character rather than a quote, which terminates the text field > prematurely. > > Yes, the SQL standard is single quotes, but No, it's not the best thing going in some cases. The > hoops jumped through to get fields with apostrophes in them to work can be eliminated very simply > by using double quotes. > > SET FLAME_PROOF_UNDERWEAR ON > > > --- Alastair Burr <[EMAIL PROTECTED]> wrote: > > I have a form based on 4 tables. The driving table simply returns a looked-up name with the > > other 3 tables each returning a scrolling region based on the preceding table. > > > > I have been attempting to dynamically size the scrolling regions to return the number of rows > > found for each table. > > > > I have the maths working fine and each one works individually but I have two things which I > > haven't found a solution for yet: > > > > Firstly, I seem to have to click into each region to get it to adjust its size; and > > secondly: there is a lot of flashing of the screen as each one is changed. > > > > I've tried every combination of Set_Focus and Skip To and table properties for First, Refresh, > > Recalc, etc that I can think of but not found the missing ingredient. > > > > One other thing that is related to scrolling regions but not particularly to this form - as far > > as I know - is that I am getting some "Invalid Text Value" error messages - apparently - > > whenever the linking (text) columns contain a single quote (as an apostrophe). Is this something > > that needs to be reported as a bug (upgrade #80/RC2)? > > > > Thanks & regards, > > Alastair. > > > > ---------------------------------- > > A D B Burr, > > St. Albans, UK. > > ---------------------------------- > > [EMAIL PROTECTED] > > ---------------------------------- > > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] >
