Search results for query: *

Gerry, I think your in depth post should be a FAQ if it isn't already. There is a lot of valuable inoformation in there. There is also good detail about the proper construct and business rules for programming.

Oaky. The VBA looks good, however not sure if it is practical for my application. It looks to me like your code cycles through each field in a recordset, and if it has a null value, it places a zero in that field. What I want to do, is if it does not contain a null value, then I want it to...

Not sure how to do sub select? Example Update Query: Table 1: Right Joined to - Table 2: ENLPERS1 ENLPERS Field: Status Table: ENLPERS Update To: iif(IsNull[ENLPERS1].[Status]),"(I would like to skip here)","[ENLPERS1].[Status]")...

I am trying to import a table from another database and then update a table in the current database. To do this I am using the transfer database function in a macro into a new table. I am then using an update query to update the records from the imported table to the local table. The problem is...