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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.