Search results for query: *

Yes - do you still have a need for this... Just noticed the date of this question...

Great - Thank you for your time..!!

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...

Hi Terry, Thank you for your thoughtful response - am working with it now.. Thanks Jon

We see this behaviour - often. There are a few different reasons... First, set your FORM property - Recordset type to [Dynaset-Inconsistent Update]. There are good refernces on Microsoft Technet with this issue as well. Jack

Yes, quite easily. 1) Setup an ODBC connection to you SQL Database. Be sure to configure your client connection with TCP/IP - it will usually default to NetBIOS. There are a few threads here that detail the steps - otherwise let me know. 2) In Access - select File, Get External Data, Link...

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...