Search results for query: *

ok, solved it. knew it was a simple function. ROW_NNUMBER() is a lifesaver! She's a Lithium Flower

Hi Everyone, I was wondering if anyone know a way to query on getting recent 3 dates in a table for example: NAME PRODUCT DATE_OF_SELL JEFF HANDSOAP 12/31/2007 JEFF HANDSOAP 10/01/2007 JEFF HANDSOAP 9/26/2007 JEFF HANDSOAP 9/03/2007 JEFF HANDSOAP 5/01/2007 JEFF HANDSOAP 4/23/2007...

THANK YOU! THANK YOU! THANK YOU! She's a Lithium Flower

Hi Everyone! I was wondering if these a method in VBScrpit to find exactly where Windows is installed? Such as "C:\Windows" or if it's in D: "D:Winnt". Thanks in advance!! She's a Lithium Flower

Hi Rodman, From what I've heard Access XP Databases was actually geared up for Visual Studios .Net. So it won't be compatible with Visual Basic 6 and below. One Solution is to simply convert your DB to a 97 format with the DataBase Utilities. Hope this help. Mark She's a Lithium Flower

Is this what you mean? put this in the form_load event: Set Command1 = Controls.Add("VB.CommandButton","Command1") Command1.Caption = "Test Test" Command1.Left = 50 Command1.Top = 30 Command1.Width = 200 Command1.Height = 70 Command1.Visible = True She's a Lithium...

Hey everyone, Just a question reqarding the clipboard command. I was wondering if it's possible copy highlighted text from other programs into a clipboard and the paste it back into my textbox? The reason is: I have to copy 10,000 pages from a Main Frame system and paste them into a text...

Thanks everyone, It works! problem solved! Man, You guys are good!!! Thanks again!

Hi Everyone, Just a quick question. I'm clueless in Access, but was asked to create a VB program to trigger a macro called "VB_Launch" inside a Microsoft Access Database (2000) located in C:\MyData.mdb. Anyone has any ideas how this is done, I've managed to reference the Access...

Thanks a lot for the help everyone, both method works, now I just need to find a way to code it. Thanks again!

Hi Everyone, I was wondering if it's possible to turn excels auto date conversion off? For example when I text-to-column the following: 9-10-1999 Excel automaticly turns it into 9/10/99. As always thanks a lot for the help!

Hi, Sorry, I meant overwriting the existing file. I found out it's similar. It's Application.DisplayAlert = False. Thanks. Andy

Hi Everyone! I'm writing a Macro to save a Excel file and overwrite the existing file. I've managed to trigger the save command, but unfortunately a msgbox comes out a ask me if I want to overwrite. Is there a write in VB to tell in to always overwrite? As always thanks a lot for the...

Hi everyone! I was wondering if there is a way to keep my program active when it's processing a file. Basically, my program copies a file that is about 200mbs everyday at 2:00 PM. the code is: Sub CopyFiles() Set CopyItem = CreateObjec("Scripting.FileSystemObject")...

Thanks a lot guys! really helped!!

Hi everyone, I was wondering if there is an API function to find all the item the user has on his/her taskbar and then print it in a msgbox? Thanks a lot! Andy

Thanks a lot! That really helped! Exactly what I'm looking for Thanks!

Great! just what I was looking for!! Thanks a lot for the fantastic reponse everyone!! much aloha!

Hi Everyone, I was wondering if it is possible to have my program to watch a program if it is closed. example, I've launched "Notepad" and would like a msgbox to pop up if notepad is closed by the user. Any ideas or comment are greatly welcome! Thanks a lot! Andy

Hi everyone I was wondering if it's possible to open files (example: .xls, .doc, .png) with their default program by flash? Something like shell. Thanks a lot! Mark