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!

Register Log in
  • Congratulations Chriss Miller 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. MichaelPReid

    OnNotInList

    Understood. Thank you for all of your help.
  2. MichaelPReid

    OnNotInList

    I updated my code to the below expression. It seems to have done the trick. It seems to have done the trick. Each of the three fields (Source, Byline1, Byline2) will update their related datasheet eachtime a new entry is presented. Byline1 and Byline2 will do this without carring over the...
  3. MichaelPReid

    OnNotInList

    But it does carry over. For example, I can enter "aaaa" into the "Source" field and the result is the proper dialog box and "aaaa" beging entered into the proper sheet. If I move to the next field, Buline1, and input "bbbb," the "Source" field changes to "bbbb" as well. So, somehow the control...
  4. MichaelPReid

    OnNotInList

    That makes sense. How can I clear out that value so that it is not passed along to the subsequent procedures?
  5. MichaelPReid

    OnNotInList

    Me.Source.Value = NewData" is the information that was entered into the field. If that information is not in the related database, it should be entered as a new entry. Can I remedy this by changing it to "Me.Source.Value = NewDataA," "Me.Source.Value = NewDataB," and "Me.Source.Value =...
  6. MichaelPReid

    OnNotInList

    In the three fields where I have designated the OnNotnList fuction input the entered data into the related table, the data is getting sent to just one tabele instead of the designated location. I have found that everytime I set up one field's properties box to the proper settings, the...
  7. MichaelPReid

    OnNotInList

    I am using the below code in one of my forms. Three of the combo boxes in the form are populated by data from two related datasheets. I am attempting to create the option of adding new data into the associated data sheet if an entry is not already in the databse. If I break this code down...
  8. MichaelPReid

    Help with a QBF

    Yes. It does seem to be giving me the desired result. Thank you for your help. Now I just need to figure our how to have the results output into a form instead of a datasheet. Any thoughts?
  9. MichaelPReid

    Help with a QBF

    Thanks for the tip and the help. Actually, the desired result is not how you have described it. I do not want the (ALL the conditions included inside the bolded parentheses are true) OR (Last condition is true). I would like to have all of the conditions be a part of the query, but I need...
  10. MichaelPReid

    Help with a QBF

    Thank you. That seems to have done the trick. Though, I did need to move the OR expression to to the end of the string. DOES an OR statement like that affect the syntax of the statement? SELECT Clippings.Date, Clippings.Headline, Clippings.Source, Clippings.Byline1, Clippings.Byline2...
  11. MichaelPReid

    Help with a QBF

    I am developing a query by form to search through multiple fields of a datasheet, but am running into a snag. I would like to have one parameter, [Forms]![QBF_Form]![RepName], from the form be used to search through two similar fields, ByLine1 and ByLine2, in the query. When I set "Like "*" &...
  12. MichaelPReid

    organize dates into weeks

    I have a datasheet that organizes items by date ("mm/dd/yy") and would like to build a query that can count the number of entries by week. How do I build a query that can group/assign into weeks of the year?
  13. MichaelPReid

    Memo data type questions

    How do I know know what queries to use so that I can see the full text? Thanks.
  14. MichaelPReid

    Memo data type questions

    Since most queries in Access will truncate the contents of a Memo field, is there any way to sort through a db of memo fields using a query with the output displaying the full text. I have build a simple databse to track and archive press clippings using the memo field to store the text. I...

Part and Inventory Search

Back
Top