Recent content by ajarrell

You're right about the paper size. I finally got a couple of pages of the badge paper. I will actually need to print 2 columns of 1 each. I think this would be really simple if I could add a Column break after each badge. Is there a column break? My searches only bring up page break.

I wasn't sure what "use the label feature" meant, so I used the label wizard. The problem persists - the labels are printing in different sizes based on the number of bars (the detail section). Even though the "label" is set to 6" long by 4" wide, it is printing 3x2 labels on the page. The...

No, the badges are not exceeding the size, but some with fewer bars or without bars cause the badge to be short and the next to start printing at the bottom of the first. I will look at paper size and label layout. Thanks for answering.

I have a report that prints badges from a query of registrations for an event. Now I need to print bars across the bottom of the badge to denote Speaker, Sponsor, Exhibitor, etc. Some badges will have no bars, some as many as 4, varying in background color. Formerly, each badge was printed as...

Solved! When I changed my default app to be the 32-bit version, the error went away. I'm not sure why I should be using the 32-bit, but it works. Thank you all!

You guys have led me in the right direction. I find that opening Access first brings up a 32-bit version (which works), while double-clicking the db file gives me the 64-bit version (which gives the error).

Frothingslosh - no other apps running

Starting Access, then Opening db file (works properly): 1. Visual Basic for Applications – C:\Program Files\WindowsApps\Microsoft.Office.Desktop_16051.11126.20266.0_x86_8wekyb3d8bbwe\VFS\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA7.1\VBE7.DLL 2. Microsoft Access 16.0 Object...

Thank you, Steve. This is what I found; not sure what to do with it. :rolleyes: These are checked: Visual Basic for Applications Microsoft Access 16.0 Object Library OLE Automation Microsoft Office 16.0 Access database engine Object Library

After moving to Windows 10 and Microsoft Office 2019, I am getting this error message in queries and reports: Undefined function 'Nz' in expression. The error occurs if I start Access by double-clicking on the database file. If I start Access, then Open the file, the error does not occur...

Thanks for the tip!

Okay, I returned to my original criteria using [CompID] with the added quote marks and it works. Many thanks to all of you!

Can someone tell me why this DCOUNT returns the number of records in the query without regard to the criteria? Thank you in advance. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) 'Increment iLine on each detail format Static iLine As Integer iTotal =...

In a database used for event registrations, I have a form with 2 subforms that are linked by Event ID and Attendee ID. The subforms are for the attendee pay items and event options. This worked perfectly for the first event in which we registered almost 500 attendees. For the 2nd event, I...

Thank you so much - works like a charm!