Thank you guys,

So that's how you replicate a T-SQL cursor in Access.

Thank you William again,

In your previous post you say, "we use @tablename which allows us to loop thru & plug in the table names as we go along."

but what's the...

Thank you,

When you don't know the table(s) name(s), what's the equivalent in Access for

EXEC ('SELECT * FROM Test2000...' + @tablename)

?

Hi William, what's dynamic sql and can you implement it using Jet sql as well?

http://www.dimastr.com/redemption/home.htm

Hi, have you tried saving the record before requerying form B in the AfterUdate event?

Don't know what the Action button does but recordset-driven forms formatted as datasheets are much more flexible than Datagrids when used in Access.

Why do you need the DataGrid?

Shouldn't the Building table appear in the second Select clause too?

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1131829,00.html?bucket=ETA&topic=301343

HTH

Won't the demise of VFP give more space to Access?

Thank you very much Andrew,

I believe tblReconnectODBC in code is not a system table though.

Hi Andrew, is there a chance you might want to share the code in that Access module?

Hi Andrew,

How do you export your ODBC settings from the registry?

Add the Date field to the Select statement and the Group By clause.