Search results for query: *

Greetings all, In VB - the EVAL() function can evaluate a literal string within an expression... How would I do that in T-SQL..? Here's what I'm trying to do: I am updating a variable name that changes...initially @PSt=Phase1Start, then @PSt=Phase2Start, then @PSt=Phase3Start...and so on...

OK - I'm a bit of a newbie here... I would like to 'process' a table - read a row at a time and INSERT or UPDATE a row in another table. In more practical terms - I have a denormalized table that allowed for 5 items, that now need to be put into a normalized child table. So, I wish to read a...

If DoCmd.RunSQL can only be used for action queries, how can you perform a simple SELECT (from a SQL table) to return a table value to an Access function...? Sorry, this seems too simple to me - I'm missing something here.... ? Thanks, Jack

Am trying to create an Access function to quickly create a new, empty 'master record' that contains only the key - then pass that key back to the program for form entry, queries, etc. We like to create the key - right away in order to create other associated rows in other tables - in order to...

Hi, Have a check printing routine - where the check register no longer prints correctly (check number no longer increments). The register's check number is based upon the number of lines detail section can handle - 92. A temporary table is created by a SQL command (Access 2000) that calls a...