|
|
|
|
Thread Tools | Display Modes |
|
|
Oct 20th, 2007, 11:20 AM
|
#1 |
|
Newbie
Join Date: Oct 2007
Posts: 8
Rep Power: 0
 |
Acces using VB
I created a macro that should be able to export/import a file based on the filename and date. when i insert the code:
=\\c\desktop\"johndoe" & Right("0" & Month(Date()), 2) & Right("0" & Day(Date()), 2) & Right(Year(Date()), 2) & ".txt in the filename field it gives me an error of either filename must end in .txt or .csv or microsoft access cant parse the expression. Can someone tell me whats wrong with my code? this is a macro created in access with the transferText Action. Thanks |
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VB using Access | u2cannv | Visual Basic | 4 | Oct 19th, 2007 11:25 AM |
| What can you do with vb? | g2k556 | Visual Basic | 31 | Oct 19th, 2007 6:38 AM |
| vb to c#... Need Help!! | Sil3ncer7 | C# | 8 | Oct 17th, 2007 1:05 PM |
| VB 2002 -> VB 2008 conversion | pal | Visual Basic .NET | 1 | Sep 15th, 2007 3:43 AM |
| Trying to acces SQL and put content in dv tag | Epoch_Apex | PHP | 14 | Oct 26th, 2005 9:47 AM |
Threaded Mode