Activity Stream

Good spot 😀

* is 42, where is the rest?

Except your code uses dash as a separator but the results show = sign?

It would if they used the maxchars parameter of 6 OP should really show the code they used

I'm using this in my query: Setup Instructions: Replace(Replace(,Chr(13),Chr(13) & Chr(10)),Chr(10),Chr(13) & Chr(10)) Can Grow and Can Shrink are...

If you referred to a column in the combo by the control, surely that would be empty as well?

I cannot see how that function produced that output? :(

I would suggest that you base the form on a query which references the unbound combo box, in the form header section, as a parameter on the PartName...

Adding to Word: Using the function with a control in the report, the output is:

This is where I like to resort to Excel. (Yeah, I know!) but I can do an unpivot in PowerQuery and it's done.

Unfortunately, by having multiple columns for the branches, your table is 'encoding data as column headings'. A fundamental principle of the...

pass your string to this function and see results in the immediate window Function AscChar(s As String, Optional startpos As Long = 1, Optional...

To find out what those characters are, you might need to paste the original content into Word. I think it's Show/Hide in the paragraph group on the...

I would look to see what characters are meant to be the linefeed/carriage return. Then replace those with vbCrLf

In my example database you would need to run the "qryAllFields_Crosstab" to show the desired output. To get the Totals for each Column you would...

Hi Vinay Attached is an example of how you should construct your tables.

what you will be needing is a VBA to build your query. then you need a form to display the resulting query (see SampleForm on the demo). see the...

I would create a count for each branch for each record. If a branch count of zero for a branch equals the record count, then omit that branch. So...

If your data was properly normalised, it would not be a problem- you would simply use a crosstab query to display the data. As it is you would need...

Never, ever caught a glimpse of it here. :-) Unlike another site, where it pops up now and again.

No more Cloudflare, ever.

Perhaps an easy solution is to set the text box unbound until the combobox is filled. I mean to set the textBox controlsource to Null in dessign mode...

On the Load Event of the Form, use DoCmd to GoTo New Record. When a selection is made on the combobox, you Search it on the form: Private Sub...

The query is updating via a query. Maybe Qry_TBL_PRODUCTION_SCHEDULE is the problem query. Has that query changed recently, making it un-updateable?

Neither here nor there answer, but if you can find all the misspellings and add them to a table, you can add a column to it and add another column...

You will need to make the textbox unbound. The after update event of the combox can populate the textbox. The after update event of the textbox...

Hi Carmine Can you upload a copy of the Database with no confidential data?