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!

  • Congratulations strongm 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. 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
  16. Per9922

    Print screen

    Hello xwb, Thanks for the response. Maybe I explained alittle bad. My application will be on two monitors. The two minitprs work independent. I would like to have button on each monitors that prints the contest of that monitor. Regards Per
  17. Per9922

    Print screen

    Hello, I have an application there I would like to print the screen. It is possible from VBScript to print the screen ? I have two monitors to my application, can I seléct which monitor I would like to print ? Thanks Per
  18. Per9922

    String

    It does not work. Do you have to set the "size" of the Tab ?
  19. Per9922

    String

    How do I include tabs in the string ?
  20. Per9922

    String

    Hello, is this possible: I would like to get even space between words. Ex: Row1 Text1 Test2 Test3 Row2 NewText1 NewText2 NewText3 I would like the words to line up as abowe, is that possible ? I tried to put in spaces, but with ni luck. Can I use tab instad ...

Part and Inventory Search

Back
Top