Search results

Thought you'd like this... I took Stoat's function and extended its capabilities to better serve my purposes but I'm sure it can be useful for other people than myself so here it is. Its a generic function (well... two) to call a saved query and return one or more rows with one or more fields...

Ah! so this how its done.... Ah! so it is possible to query the database from within a module. I was beginning to wonder why Access is so "popular" if you can't even manipulate your stuff by programming. I'm still surprised we have to reference to DAO from within Access to programmatically...

I know RunSQL is for action query but is there some kind of workaround to receive a value from a saved query ? Surely you guys get this question often, maybe its a sign that MS should give us that darn function :) I've made this query : SELECT IIf(IsNull(Max(ID)),0,Max(ID))+1 AS MaxID FROM...