Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. flistea

    Excel 2007 protected worksheet problem

    Other people can't tab. I have a feeling this is just one of those lovely quicks that microsoft like to add to thier software. You can password protect an editable range as well as the whole sheet. I've tried not password protecting the range but it makes no difference. Thanks for your help
  2. flistea

    Excel 2007 protected worksheet problem

    It is the after you enter data, it still won't let you tab into the next cell. You can select the next cell with either the mouse or cursor keys. Using "Allow Users to Edit Ranges", cells =$A$2:$E$41 can be edited once the password for this range has been entered. Then I've used protect...
  3. flistea

    Excel 2007 protected worksheet problem

    I have a range of cells that are unlocked but it still wont let you enter data then tab into the next cell? I've attached the excel spreadsheet to show what I mean.http://cid-968e27f0ea048b12.office.live.com/view.aspx/.Public/testfile.xlsx
  4. flistea

    Excel 2007 protected worksheet problem

    I have an excel spreadsheet that is protected so that only certain fields can be edited when the password is entered. The problem i have is that as soon as the sheet is protected it won't allow users to tab between cells when entering data in the cells they can edit. Is there any way i can...
  5. flistea

    Form validation help

    Thanks theniteowl. [medal] I knew it had to be something stupidly simple! I had been trying to test it using (myForm.country.value == "UK") but it wasn't working.
  6. flistea

    Form validation help

    I'm creating a form where users enter their address (not all shown on the code) and their postcode. If it is a UK postcode I need to make sure it conforms to UK postcode standards, so I have a series of regular expressions. Users are asked to check a radio button to say whether their address is...
  7. flistea

    CSS and Firefox 1.0.3 Problem

    Thanks Dan! [medal] That's solved the secondary nav bar problem. The only other problem to solve now is why the settings for the left box don't seem to be working: #left { position: absolute; left: 5px; top: 190px; width: 585px; height: 510px; border: 1px solid navy...
  8. flistea

    CSS and Firefox 1.0.3 Problem

    I'm having a problem with css and firefox. My page works fine with IE but all the settings come out wrong with firefox. This is the css code /*Navigation bar*/ #navigation { font-family: Verdana, sans-serif; font-size: 12px; font-weight: bold; } #navigation ul { list-style: none...
  9. flistea

    Selection issue

    The only group I am using is Item.Item_RSN and then ItemAnswer.Alpha is the only detail. So I've created the {ItemAnswer.ItemLine_RSN} = 1380 AND {ItemAnswer.Alpha} in ["x", "X"] formula and done a group sum ({@1380xX}, {Item.Item_RSN}) > 0 and it's worked!!!! I've cross checked it with...
  10. flistea

    Selection issue

    lbass- I can't group on people as people are not on a separate table. I'll expand my explanation. The tables I'm using are Item, ItemAnswer, ItemLine, ItemSection and ItemType. An individual item is a specifice item type. Each ItemType is made up of sections with questions (lines) and...
  11. flistea

    Selection issue

    kskid - Thanks for the suggestion. Unfortunately when I tried it it just returned 0 records. I'm not sure whether this is because CR10 creates links are made between the field in the ItemAnswer and ItemAnswer_1 tables? lbass - if only it were that simple! All the information I need for the...
  12. flistea

    Selection issue

    Thanks for the suggestion - the problem is that if this becomes selection criteria then all the information I need from {ItemAnswer.ItemLine_RSN}1382 to 1387 is excluded from the report.
  13. flistea

    Selection issue

    I'm trying to do a report in CR10 from a SQL database (3rd party software called Authority Legal) with ODBC connection. The problem I'm having is that the field I need to extract from - ItemAnswer.Alpha - contains both the address information and whether or the person was insured last year...

Part and Inventory Search

Back
Top