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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Per9922

  1. Per9922

    Delete first 2 records

    Thanks Olof & jbenson001 for the respone! You are so helpful!! Thanks and have a nice weekend
  2. Per9922

    Delete first 2 records

    Found the solution: DELETE FROM LoggingData Where DateAndTime In (SELECT TOP(2) DateAndTime FROM LoggingData ORDER BY DateAndTime)
  3. Per9922

    Delete first 2 records

    Hello, I need the help from you! I would like to delete the first two records. I have tried this: DELETE FROM LoggingData WHERE (SELECT TOP 2 * FROM LoggingData ORDER BY DateAndTime) Please help!
  4. Per9922

    Open save as dialog

    Thanks! But I think it is to complex for me :(
  5. Per9922

    Open save as dialog

    Hello jkspeed, I tried with excel as well. So if you ran the script and by misstake click on the excel sheet the BrowseForFolder will end in the background :(. For me it is easy to get it up but the user that will use my application maybe does not know about it :( ohh, what is HTA ? Thanks!!
  6. Per9922

    Open save as dialog

    Thanks again jkspeed! You are so helpful!! If you click on the side of the browse folder dialog could end up in the background ... Could that be prevented in some way ? And you do not get it up if you press the button again :(
  7. Per9922

    Open save as dialog

    Any ideas ?
  8. Per9922

    Open save as dialog

    Hello Nu2java, Yes, I create the text file with vbsscript. Do you have any idea if it is possible ? I tried instead to open where to choose the directory with the code below, but the dialog is coming in the background, can I make it to be on top ? Dim AppShell Dim BrowseDir Dim Path...
  9. Per9922

    Open save as dialog

    Thanks! But :( I really need this dialog
  10. Per9922

    Open save as dialog

    Hello, I have created a text file which I would like to save by chhosing in the pop-up save as dialg. How do I get up the save as dialg box ? Regards Per
  11. Per9922

    Open internet explorer, print the contents and close internet explorer

    Thanks jkspeed is worked!!
  12. Per9922

    Open internet explorer, print the contents and close internet explorer

    Thanks jkspeed! I will try it tomorrow. Do you know how to in landscape ?
  13. Per9922

    Open internet explorer, print the contents and close internet explorer

    Hello all, I really ned the help from you! This is what I want to do: 1) Open internet explorer with a html file 2) Print the html file 3) Close the internet explorer Or can I print the html file direct ? I have manage to do set 1 with this code: Dim objExplorer Set objExplorer =...
  14. Per9922

    VBA SQL Create database and table

    Yes, but I can not find any good example.... This does not work, how to create the connection string ? How to create the tables ? Dim str Dim conn, rst Set conn = CreateObject("ADODB.Connection") conn.ConnectionString = "Provider=MSDASQL;DSN=WINCC;UID=;PWD;" conn.CursorLocation = 3 conn.Open...
  15. Per9922

    VBA SQL Create database and table

    Hello all, I really need the help from you! I would like to do the following from a VBA script: 1) Create an SQL database with UID=User and PWD=Password 2) Include a table in the database I have serached the forum but I can not find anything Please help! Per
See more

Part and Inventory Search

Back
Top