Search results

I'm good at SQL, less so with VBA and I use Access 2003. I have three tables, dbo_Members, dbo_Classes and dbo_CourseRegistrations and I want a form that creates a class and writes its attendance list into about 20 records in dbo_CourseRegistrations with minimum user work. Here's the plan...

Can someone help please? The code below should add a record to another table when a box is ticked. It worked fine when I wrote it in a local Access 2003 form. I have since migrated the tables to Azure and connect via ODBC, and now I get this error: A search for Identities told me to modify...

I set up an Access 2003 database where this code works OK: Private Sub Street_Exit(Cancel As Integer) Me.Suburb = DLookup("Suburb", "Streets", "StreetName = Forms![Add A New Member]!Street") Me.StreetID = DLookup("ID", "Streets", "StreetName = Forms![Add A New Member]!Street")...

Hi. I'm retired 15 years, former computer professional. These days applying my skills to a local SeniorNet club where I'm webmaster and database manager, and I teach classes in Chrome, iPad and Facebook. Used to be a wiz at QBASIC (showing my age) and I'm here because I struggle with some of...