Search results

I am totally lost with this usage of the IIF function. I can't figure out what is the truepart and what is the falsepart. File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))

I was reading somewhere that it is not good to update two tables from a single form. Something to do with data integrity. On the other hand it seems to me that using an update query for the two tables is exactly what is required to populate the form. I'm confused...again....

I was watching a tutorial on YouTube about migrating to SQL Server and what I understood from the guy was that it was not possible to have a multi-user Access application. This is a small company for which I am creating this application. At this point there will be at most 10 concurrent users.

I have not used Access in many years and even then it was not developing an application. However, as I mentioned in my introduction, I have worked with other databases for about 30 years. Anyway....I assumed that an Access application could be used by multiple users simultaneously. I thought it...

I was laid off from my engineering job last June so I decided to semi-retire. I wanted to keep working part time so I got a little project converting a company's Excel based "database" to an Access database. While doing engineering / design work, I used Dbase III/IV and another database that...