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 gkittelson 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. sabrina30

    Passing Field Value

    I know this is not my thread, but I have been using it for my database. I set up my main form and my form that opens through the button like it has been suggested in this thread. The records are opening as they should...except for any records that were created after I attempted to remove the...
  2. sabrina30

    Word 2003 - Auto-numbered Headings

    While that is a great idea and I have used that solution for Change Page documents, it is very time consuming when you have a document that is 2 to 3 hundred pages long.
  3. sabrina30

    Word 2003 - Auto-numbered Headings

    Thank you, I ended up going back and reset all the gallery positions for heading 1 and heading 2 and although I would swear I already did this it worked this time. Word has a mind of its own.. :/
  4. sabrina30

    Word 2003 - Auto-numbered Headings

    I have searched the forums and have not found an answer to my problem and it seems none of the other tech writers in my office can answer this either. We use numbered headings 1. heading1 1.1 heading2 1.1.1 heading3 Problem is that sometimes it gets messed up, will be working fine and then...
  5. sabrina30

    Passing Field Value

    This sounds like the exact same problem I am having. TheAceMan1 suggested for me to check out this Faq FAQ702-5860 , and while it was helpful for what I wanted I would like it to open the form without me having to enter the RecordID...I want that process automated.
  6. sabrina30

    Changing SubForms to Pop-Ups

    I set everything up as suggested in FAQ702-5860, but it wants me to enter the RecordID before opening the SubForm..This was supposed to be an invisible field. I only have it visible now to make sure the correct records are being pulled. Did I do something wrong?
  7. sabrina30

    Changing SubForms to Pop-Ups

    oh, that makes so much sense. Been awhile since I set up the sub-forms initially. I will check out the link provided. Thank you
  8. sabrina30

    Changing SubForms to Pop-Ups

    I have a forms with a sub-form on it. The sub-form has 5 tabs, but a few of the forms have a lot of data in it to be entered and causes the page to be huge and requires the user to do a lot of scrolling up and down to get anything done. I would like to remove the sub-forms and put the forms into...
  9. sabrina30

    Report between dates - allows 2006 dates but not 2005

    Well, I can't edit my previous post. You have to put a value to each field in an option group. I will stick with the formula you provided, lameid, thank you
  10. sabrina30

    Report between dates - allows 2006 dates but not 2005

    Interesting, Thank you. I have it set to no Decimals. So I get 3 instead of 3.3, which is less confusing for my boss. So, in an Option Group, if I simply do not put a value to the N/A would that be considered as Null?
  11. sabrina30

    Report between dates - allows 2006 dates but not 2005

    Thank you. I ended up regrouping the 2 fields that were giving me trouble and setting a default to the field. That way all fields have an answer of some kind. I do however, have one other issue. My boss wants a report of what the average answer is. The problem I think is the way I have the...
  12. sabrina30

    Report between dates - allows 2006 dates but not 2005

    Ok, the problem was caused because one of the records had a question unansered. For some reason if none of the Checkboxes are selected in each question, then an error occurs for that field and the report will not run. I will do some research on bypassing this. How to not get an error in a field...
  13. sabrina30

    Report between dates - allows 2006 dates but not 2005

    Thank you for the tip, but unfortunately that did not fix the problem.
  14. sabrina30

    Report between dates - allows 2006 dates but not 2005

    I have a report. I set it so that it opens a form to select the dates, such as 01/01/06 - 12/31/06 and that works fine. But, if I select 01/01/05 - 12/31/05 or 01/01/05 - 12/31/05 I get "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression...
  15. sabrina30

    Report by Year

    I figured out at the report being wider than the page issue. Thank you. How do I get the unbound form to display for the user to enter the dates for the report?
  16. sabrina30

    Report by Year

    Thank you THWatson, that worked. Thomas Lafferty thank you also for your input. I had a between dates query set up in the beginning, but it seemed to be pulling more then what I wanted. I would enter 01/01/06 - 06/12/06 and I would have dates from 2005. Now to figure out how to get the Form to...
  17. sabrina30

    Report by Year

    I have a report that is pulling data from a query. I figured out how to get the report to pull for just a specific month, but was told they would rather have the report pull by year with a breakdown in quarters. I think I have the quarter part figured out. I can not however, figure out what to...
  18. sabrina30

    Excel - Sum is not updating - WHY

    Thank you, I figured it had to be something simple...DUH
  19. sabrina30

    Excel - Sum is not updating - WHY

    The formula is simple and was working before, now it is not and I can't figure out why. =SUM(C5:H5) It works when I first put in the formula, but will not update.

Part and Inventory Search

Back
Top