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 Rhinorhino 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 Learning123

  1. Learning123

    Getting Recent 3 dates

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

    Getting Recent 3 dates

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

    Finding Location of the windows folder

    THANK YOU! THANK YOU! THANK YOU! She's a Lithium Flower
  4. Learning123

    Finding Location of the windows folder

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

    Access XP (2002) and visual basic 6

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

    Load object thru coding

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

    Clipboard question

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

    VB and Microsoft Access

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

    VB and Microsoft Access

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

    Excel Auto Formating Question

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

    Excel Auto Formating Question

    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!
  12. Learning123

    automation in Excel

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

    automation in Excel

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

    Keep program active

    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")...
  15. Learning123

    Getting the for day and last day of the month

    Thanks a lot guys! really helped!!
See more

Part and Inventory Search

Back
Top