Search results

I have Group On Locale Group On Test - with test I have "with a footer section" In the properties of the report footer, I did All - force new page - After Section But everything is still on one page.

Doesn't work because the locale is the same.

This should be basic but I can't figure it out. I want each page to only show data for one Test. Each time a second Testdisplays I want to go to a new page. My desired display is Header 501 ------- Logo 1 Then page TWO header 501 ----- Logo 2 Attached is a sample databse with a...

@sgrgeta - holy cow that is awesome and exactly what I need!!!! @Uncle Gizmo - that is a super handy tool, I am going to bookmark it as I'm sure I can use this for multiple projects

I receive a spreadsheet that is imported into access, and it needs to be manipulated to make columns out of some of the rows, and get counts for locations. Attached is a database that shows with two tables, the Received which is the direct spreadsheet import, and the needed which is the table...

I was initially having issues with my barcode not displaying but I resolved that, now my issue is the barcode won't scan. I'm using the 3of9 barcode. Attached is a sample database, with scrubbed data. Does anyone here see an issue as to why the barcode is not scannable? I tried to upload here...

Okay, I figured it out but I don't understand it. All I had to do was this retVal = GetRecordSetResults(sqlString) Why do the parens make a diff?

Insted of Sub Test It should be Function Test Is that what you are saying needs changing?\ Err...just kidding, I tested that theory and same error even if I place it in a function.

The table that I'm looking at is always less than 1,500 rows so I am not conerned with speed at this point, but I will keep in mind DLookup is quicker. I see you assigned the result to the function name, I didn't know you could do that! :) My remaining question is, would I get the value in the...

I'm sure this can be done, I just can't wrap my mind around doing it. I want to pass in a sql string to a Function that will open a recordset and return the result of the recordset to the calling function. I'm trying to do something like this Sub Test() Dim sqlString As String sqlString...

I have this function that I am using to pass in the recordset, filename and the querySQL to export to Excel. My last remaining issue, is that even when the workbook is saved and closed in Task Manager I still have an instance of Excel left. What step am I missing to properly clean up Excel...

@arnelgp - each recordset would be going to a different workbook.

@Uncle Gizmo - I'm using a recordset and not a query. I know I could change that recordset into a query rather quickly tho. The link you provided seems to be a dead link, when I click on it I get an error on the page

@June7 - how about the code below? I'll probably convert this to a function where I can pass in the recordset as I'll need to write about 5 different recordsets to Excel, but for now - is this code what you were referencing? Dim rst As DAO.Recordset Dim userSQL As String Dim xlBook As Object...

I am wanting to create an excel workbook and write a record set to it. I have my recordset, and I have created an excel workbook. But I am not sure how to write the recordset to it. This is the code that I have. Dim rst As DAO.Recordset Dim userSQL As String Dim xlBook As Object Dim xlApp...

Okay disregard, it was user error on my end. All set now, thanks!

I've added the 3 of 9 font to my computer, I've opened my access report in design view, added a text box, set the control source of the text box to the ID field, and changed the font size to 14 and font to 3 of 9 Barcode. When I print preview the report this is what I get -> What am I missing...

Thanks @MickJav & @Uncle Gizmo Those have been very insightful to search and read. I didn't realize there were so many options! I just learned that I need to use the 3by9 barcode, so I am going to revisit some of the threads from search and see if anyone I find specifically uses that barcode.

Does Access 365 have the ability natively to add a barcode to a report? Basically take one of the fields from the query that is the control source of the report and convert it to a barcode?

I have an excel worksheet that in column A has an IP Address, and column B has a userid. If the user visits the same site multiple times, obviously there would be multiple entires in the worksheet for that. I need a way to get rid of all duplicates. Sample data is like this 11111111 a12...