Recent content by Euler271

Thanks to everyone for taking the time to respond. I ended up created the string and array at the same time: PKs = "(" ReDim A(Me!MyListBox.ItemsSelected.count - 1) For Each ListItem In Me!MyListBox.ItemsSelected PKs = PKs & Me!MyListBox.Column(0, ListItem) & ", "...

Since I set A() as Long I didn't think I needed quotes. I need the items to remain Long datatypes. When I stopped the code and printed what was in PKs I found (23456), just one primary key which is as it should be since I only selected one item in the list box. If I select two items in the...

I'm creating a string of primary keys, called PKs, and then converting that string to an array, called A(). I'm using a comma as the delimiter. The problem is that I'm getting a "Type Mismatch" error on the line: A = Split(PKs, ","). Here's the code: Dim PKs As String Dim ListItem as...

Thank you very much for your help.

I'm trying to print labels but I need them to print horizontally using three columns. So, let's say I have four records to print. Ideally, I want the first three records to print on the first line of the sheet and the last record to print in the first column of the second line. Right now...

Thank you very much for taking the time to respond.

It's in another procedure.

The only other line is Set xlWb2 = xlApp.Workbooks.Open(TestFilesLocation & "Avg_Hours_Report 8-1-22.xlsx")

From within Access I'm trying to populate a column with a VLookup formula that references a second workbook that is also open. Here is an example of what I've been trying: xlComp1.Range("Z2").Formula = "=VLOOKUP(G2,[xlWb2]Avg_Hours_Report!$A$2:$D$20000,4,FALSE)" I'm doing something wrong...

My question was correct. I wanted to know how to get the results using a crosstab query. And I don't need a lecture about "confusing the issue"

That doesn't work either because each WeekdayNumber is still a row heading.

I want to create a crosstab query where I can get an average for a select number of row entries. In other words, let's say I have a database with three fields: days of the week, company name, hours worked. The row heading would be the days of the week, the column heading would be the company...