Search results

everytime i try to create a new webpage w\ vb express 2005 , it freezes up. can work on previous project, but thats it. any suggestions would be great Thanks

fileDt = Format(Date, "MMDDYY") fileNm = "\\jazzs\acc\" & "johndoe" & fileDt & ".txt" MsgBox (fileNm) DoCmd.TransferText acImportDelim, "SPECS", "3RPV Export", "\\jazzs\acc\" & ""johndoe" & fileDt & ".txt"ileNm"", False, """ ' Runs query a code to 3rpv export

Thanks a lot for the help, I finally got the program working, just minor tweaking left. I really appreciate it. Thanks again

Option Compare Database Option Explicit Sub Import() Dim jane As Date Dim john As String Dim RESULT As String RESULT = "johndoe" & Format(Date, "MMDDYY") & ".tx" End Sub here's my code i dont know what i'm doing wrong Thanks

I tried writing the code and even reformatting the date, but since it is formatted in 10/18/07 the file isn't recognized. the date of the file is 101807, without slashes. do you know a way around this.

Thanks a lot

thanks a lot. my next question would be, do i have to convert my macro to VB? if so, would i write the code inside my event procedure? Thanks

i'm currently running a macro to import and export files based on a filename that will not change proceeded by todays date dot txt. ex: johndoe101607.txt. is it possible to create the macro so that it will grab johndoe(today's date).txt? if so, how do i set it to do that. Thanks