Search results for query: *

Understood. Thank you for all of your help.

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

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

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

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 =...

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

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

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?

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

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

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 "*" &...

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?

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

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