Access 2010 Runtime Error 31519
Any help would be appreciated. DO NOT hit ENTER yet! I have been fiddling with > this for 2 hours now. It took forever to figure it out. http://arabopensource.net/access-2010/access-2010-runtime-error-490.html
Is there another setting > in the file specs setup that I may have missed? John "John K" wrote: > I tried the code here: http://www.mvps.org/access/api/api0001.htm to open > file dialog so the user can import the txt files they select. > > The code I I managed to get around it by saving the .xls as a .csv file -- and the transfertext option works. The filename parameter is the path to the exact file, right?
Click Here to join Tek-Tips and talk with other members! So, I think you'd better check the TransferText properties again: But the help file doesn't mention not using the parentheses. Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables +
Similar topics Visual studio 2008 IDE application R6034 runtime error - MSDN news group moderator Please Respond. Kinda stuck... > > > > Thanks, > > John John K, Jul 24, 2008 #3 Advertisements Show Ignored Content Want to reply to this thread or ask your own I am trying to import a file and I keep on getting the error 31519. FAQ181-2886: How can I maximize my chances of getting an answer?
AccessForums.net is not affiliated with Microsoft Kinda stuck... Nov 24 '11 #6 reply P: 4 scruffy Thank you so much, I finally have this portion working. read review Thanks 0 LVL 84 Overall: Level 84 MS Access 83 Message Active today Expert Comment by:Scott McDaniel (Microsoft Access MVP - EE MVE ) ID: 358306272011-05-25 Have you recreated the
It does not import correctly > > if I try a macro either. FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? Thanks! These troubleshooting steps get progressively more difficult and time consuming, so we strongly recommend attempting them in ascending order to avoid unnecessary time and effort.
This field goes just fine with the other methods. http://www.pcreview.co.uk/threads/runtime-error-31519.3577703/ How do I enter a file name argument that still allows the user to select the text file? Click Yes. Home Products Services Learning Forum Contact Access World Forums > Microsoft Access Discussion > Modules & VBA DoCmd.TransferText runtime error User Name Remember Me?
Rename the file (temporarily or permanently with code) while the file is being imported.GroverParkGeorgeView Member Profile Apr 7 2007, 03:09 PM Post#6UA AdminPosts: 28,167Joined: 20-June 02From: Newcastle, WATHanks, Walter. http://arabopensource.net/access-2010/access-2010-runtime-error-7777.html You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor) 30 Day Free Trial Message Author Comment by:JayceW ID: 358307102011-05-25 Yep, sadly still no joy. Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your 31519 error), and broken links within the registry. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We
Without checking, I think you may be missing parameter(s) if contracts is the name of the new table, it should be enclosed in quote marks, otherwise access looks for a variable Nought for two isn't a good average ;-) Nov 23 '11 #4 reply P: 4 scruffy My goal is to be able to import files using the Dialog box. Microsoft Access), reinstall the program according to the Microsoft Corporation instructions. his comment is here Thread Tools Rate Thread Display Modes 10-30-2007, 10:56 AM #1 tingler0 Registered User Join Date: Oct 2007 Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts DoCmd.TransferText runtime
I continually get an error stating that I "cannot import this file" Run-Time error 31519. In Workâ¦ MS Access Positioning popup forms in relation to the main MS Access window on multiple monitors Article by: Nick67 In a multiple monitor setup, if you don't want to so remove it. __________________ To view links or images in signatures your post count must be 10 or greater.
Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows.
While holding CTRL-Shift on your keyboard, hit ENTER. boblarson View Public Profile Visit boblarson's homepage! Join our community for more solutions or to ask questions. A black box will open with a blinking cursor.
Member Login Remember Me Forgot your password? here is the code. Hello and welcome to PC Review. weblink You cannot import this file vba317 (Programmer) (OP) 25 Mar 13 12:25 I am using access 2003.
DoCmd.TransferText , acImportDelim, "Contracts", "\\Zbnawlfs002\Dept\AR-Collections\CashApplications\ContractLogReport\" & (selectdate) & ".csv", True tingler0 View Public Profile Find More Posts by tingler0