|
|
 |
|
|
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 |
|
|
Oct 22nd, 2007, 10:36 AM
|
#2 |
|
Resident Grouch
 
Join Date: Jun 2005
Posts: 6,453
Rep Power: 10
|
Re: Acces using VB
Duplicate question. Thread Closed.
__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers |
|
|
|
| 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 |
Hybrid Mode
