Search results

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!

I am selecting groups: ACPA-SE BOD ACPA-SE MBR Contractor Thank you!

How do I do that? (Sorry.)

That fixed the error. SELECT tblContacts.[ContactID],tblContacts.[First Name], tblContacts.[Last Name], tblContacts.[Company], tblContacts.[Email], tblGroups.Group FROM tblGroups INNER JOIN (tblContacts INNER JOIN tblContGrpLink ON tblContacts.ContactID = tblContGrpLink.Contact) ON...

SELECT tblContacts.[ContactID],tblContacts.[First Name], tblContacts.[Last Name], tblContacts.[Company], tblContacts.[Email], tblGroups.Group FROM tblGroups INNER JOIN (tblContacts INNER JOIN tblContGrpLink ON tblContacts.ContactID = tblContGrpLink.Contact) ON tblGroups.GroupID =...

Thanks for your timely response! I have not allowed records in the link table to have the same person and group more than once. Now I am getting the message: "Your query does not include the specified expression 'First Name' as part of an aggregate function." Thanks, again.

I have a db of contacts that includes a linking table to match contacts to the groups each is in. I need to be able to query for contacts that are in a specified group AND in another specified group. My query instead returns all contacts in [SelectGroup2]. Is there a way to make this work...

In Access, in SQL view, I modified a query to change one of the JOINS from inner to outer. I got the error message that the query couldn't be executed because of an ambiguous outer join. However, now I can't get back to SQL view to fix it. Whenever I click on SQL View, I get the error message...

Setting the default value was exactly what I needed. I didn't know that property existed. Thank you!

Now, my macro is returning 12:01:26 AM. I am attaching a db file with a form, frmContacts. Entering a new record will demonstrate the problem. I am hopeful that someone can help. Thank you in advance!