Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lewatkin

    Export inserted value to a text file.

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

    Export inserted value to a text file.

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

    Trigger/Stored Procedure help

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

    Trigger/Stored Procedure help

    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)...
  5. lewatkin

    vbScript - vbRetry Question

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

    vbScript - vbRetry Question

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

    vbScript - vbRetry Question

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

    vbScript - vbRetry Question

    Ok vbscript gurus, this is probably a simple question. This is my first attempt at vbscript. I am querying a database with input from the user, and when the records are returned to the message box, I have a retry button there. If the information that is returned is not what the user is...
  9. lewatkin

    Powershell script

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

    Powershell script

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

    Find something in a MS Word paragraph with VBA

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

    Find something in a MS Word paragraph with VBA

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

    Finding something in a paragraph with VBA

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

    Use WRT54G as access 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...
  15. lewatkin

    Use WRT54G as access point

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

    Use WRT54G as access point

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

    use ADODB.Recordset as RowSource for combo box

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

    use ADODB.Recordset as RowSource for combo box

    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!!
  19. lewatkin

    use ADODB.Recordset as RowSource for combo box

    Hi all, I am trying to use an ADODB recordset as a rowsource for a combo box. I can loop through the recordset and write the values to a table just fine, but that is not what I need to do. Here is the code: Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.Open...
  20. lewatkin

    File Export Question

    glad to hear it. Lee

Part and Inventory Search

Back
Top