Activity Stream

Hello, I am trying to make a nice database for my board game collection, with the name, publisher, year published, # of players etc... One of the...

A multi value field still has the many to many table, it’s just that it is hidden and limited in structure- basically just containing the PK of the...

Have a look here. Many-To-Many, two ways to update Junction table, includes Not In List handling

Yes, multi-value field is not preferred by experienced programmers but if you fully understand its drawbacks and how to deal with, it might be...

That's how the UnencodeColumns demo which I attached earlier recasts the incorrectly modelled data. It then requires a simple crosstab query to...

Hi Vinay Your query example is based on a table that is based on an Excel Spreadsheet. You should think Access which would display your data as...

I ended up starting over and creating a new report with the same data and settings I entered above and it stopped truncating. Thank you for your...

A late reply I know, but might be useful. For the players use a 2-column subreport within a parent report. The parent report can be bound or...

maybe create a Function in a Module: Public Function FixCrLf$(Byval sText$) sText = Replace$(sText,Chr$(13), Chr$(13) & Chr$(10)) sText =...

Okay, the text box does indeed have the focus, so the short answer is that one cannot do what I was attempting. Not a big deal, I'll just let the...

Not clear what the requirement is - buttons to appear on top of the textbox? If so, whatever control has the focus will be on top. If that is the...

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.