Search results for query: *

I have a mystery: I have a form with two sub-forms. Both sub-forms have a Yes/No field denoting whether an item has been marked as completed. On one subform the conditional formatting works: Field: txtToDo Expression is [ToDoComplete]=-1 results in the conditional formatting being applied...

I figured out the problem, though I don't understand it. I had changed the main control of the form to an unbound combo box: cmbBudgetID. The child form fsubBudgetDetails01 used the cmbBudgetID as the Master Field and it worked fine. However, when I referenced the Category ID from the child...

Hi, Duane, I set the event procedure for On Current to: 'Set the value of cmbBudgetID unbound combo box Me.cmbBudgetID.Value = 1 That works but whenever I open the form I still get the "This expression is typed incorrectly..." error. Even more odd, this form had been working...

I'm experiencing the error, "This expression is typed incorrectly, or it is too complex to be evaluated." after I add a subform. I have a text box on the main form that is pulling a category ID from one subform: Control Source =[fsubBudgetDetails01].[Form]![cmbCatID] The text box, txtCatID...

Thank you, Andy. I had tried that but the query doesn't return zero results even though I know there are three records containing a carriage return.

I have imported non-normalized data from Excel into Access. Some fields have carriage return at the beginning of the text string. How can I write a query to isolate them? My research indicates that carriage returns are represented in Access as Chr(13) & Chr(10), but when I put that into a query...

I have a hyperlink on a form that is producing the following error when clicked on: "Unable to open https://site.... Cannot download the information you requested." This seems to have occur after I edit the display text for the hyperlink, even though the URL address is valid and works if I...

I was using the wrong type of form object. When I add an image frame, it works as expected. I just mis-remembered which type of form object to use. Problem solved.

I have been attempting to use a technique I've used before to pull an image into a form in Access 2016. I populate the Control Source of the OLE Bound frame using a DLookup function: =DLookUp("PicPath","tlkpCountries","CountryID =" & [txtCountryID]) This function pulls in the correct path from...

That's it! Thank you!

A loooong time ago, someone provided a great concatenate function here on the forum. I'm hoping someone can point me to it. The function would take a field in a record set and concatenate them, separating the record values with a comma. For example, if the table contained: Yellow Orange Red...