Search results

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

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

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

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