Recent content by Per9922

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

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

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!

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

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!!

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 :(

Any ideas ?

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

Thanks! But :( I really need this 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

Thanks jkspeed is worked!!

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

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 =...

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

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