Search results for query: *

George, Thank you for that clarifying that for me. It makes perfect sense now. I can work with the second suggestion you made. Thanks again, Lee

I have an insert trigger that is working fine. I have a need to export the primary key value that was inserted into the table to a text file. My attempts thus far have resulted in an error. Here is the code: BEGIN DECLARE @MySql varchar(1000) SELECT @MySql = 'osql -Q "SELECT...

Sorry for the delayed response. I just wanted to say thanks for pointing me in a direction to get me started. The code I used is posted below. ALTER TRIGGER [dbo].[Date_Update] ON [dbo].[staff_certs] AFTER UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from --...

I'm sure this will be easy for some of you, but I am pretty new to the trigger/stored procedure world. I have a date field in two tables, and an employee id field in two tables. The dates are associated with a primary key of employee id. I would like to create a trigger (or stored procedure)...

PH, That is what I ended up doing. I saw the same thing you referenced and moved the Do loop below the connection string. Thanks for the reply! Lee

Thanks for your help! That's exactly what I did. have a star!!

I fixed it. Just added a boolean in a loop that was false until the Cancel button was clicked on the Msgbox form. Maybe not the most efficient, but it works.

...objCN.Open strConnection If strinput = -1 or strinput = "" then wscript.quit End If Dim strSQLQuery strSQLQuery = "Select * from dbo.vw_script where responsibility like '%" & strinput & "%'" Dim objRS objRS=CreateObject("ADODB.Recordset") Set objRS = objCN.Execute(strSQLQuery)...

Thank you for the reply and it is further than I was for sure. But its not quite what I was looking for. First, this only exports the information from the last server in the C:\AllServers.txt file. Additionally, the information is double quoted and pipe delimited (ex...

The following powershell script works fine.... foreach ($svr in get-content "C:\AllServers.txt") { [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null $serverinstance = new-object ('Microsoft.SqlServer.Management.Smo.Server') $svr foreach ($db in...

Gerry, Thanks so much for the code. It worked fine on the first document in the folder, but when it went to the second document, it failed on Set r = ActiveDocument.Range. Not sure why. Nonetheless, I am using Selection and it is working fine. The code is not pretty at all, but it works...

Hey gang! I know there is someone here that can help me. I have 10,000+ MS Word Docs. They are all formatted the same - another program creates them. See below: "Commencing at NGS monument "Any High 2" having XXXX Grid Coordinates (NAD 83-2001) X=XXX.XX and X=XXXX; thence from said point...

Hey gang! I know there is someone here that can help me. I have 10,000+ MS Word Docs. They are all formatted the same - another program creates them. See below: "Commencing at NGS monument "Any High 2" having XXXX Grid Coordinates (NAD 83-2001) X=XXX.XX and X=XXXX; thence from said point...

Gentlemen, THANK YOU BOTH. I am happy to report that I am posting this through aforementioned Gateway that would not previously get on the internet wirelessly. While neither of your posts was exactly what the problem was, they both lead me to what the problem was. I ran the /flushdns as...

Hey Jim, Thanks for the response. Here is what I did... On router: IP = 192.168.1.1 Subnet: 255.255.255.0 Gateway: 192.168.1.1 DHCP enabled Wireless Router: IP = 192.168.1.2 Subnet: 255.255.255.0 Gateway: 192.168.1.1 DHCP disabled No security enabled (will enable after it works) Connected...

I am way out of my league here, so I am hoping someone can help. I have a Linksys BEFSR41 Router that is connected to the internet and working fine. It is not wireless. I have a Linksys WRT54G v8.2 that I would like to use as an access point for my wireless laptops. I have found a lot of...

The list of data that I am using is constantly changing (like several times / minute). I am actually using it on the click event of the combo box. Max records will only ever be 500 and the list populates in milliseconds. Using ADO keeps the recordset on the server side and all that is passed...

I have not and did not even THINK about that. Man I appreciate you pointing me in that direction. I'll give it a shot. Have a star... Thanks man!!

...Access ODBC Driver;System = Server1;", "uname", "pword" cn.CursorLocation = adUseClient strSQL = "SELECT LIBRARY.LOGFILE.* FROM LIBRARY.LOGFILE" rs.Open strSQL, cn, adOpenStatic, adLockReadOnly All of that works - now how do I use it? :) If someone could just...

glad to hear it. Lee