Search results

Thank you, I'll work on that :)

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

Thank you Paul. Yes, it works! I can't remember any other instance where the order of what looks like a list of parameters mattered. Clearly the second parameter depends on the first so they aren't really a list.

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 hope you enjoy your visit, Paul. March is early autumn here but the weather is still usually good. I haven't been to Nevada, the nearest was a stopover in Phoenix. Loved flying over Arizona! Great response to my first request for help, I'll definitely be back :)

Thank you, that works well and I'd forgotten about spaces! I don't understand single quotes in DLookup criteria well and I've read conflicting advice about them in forums. I decided to rename everything individually as the database will be multi-user and most won't understand Access settings so...

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