472,950 Members | 2,395 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,950 software developers and data experts.

Trying to figure why my . are turning into a #

489 256MB
I'm trying to create a .txt file so that I can merge it with a word document
Expand|Select|Wrap|Line Numbers
  1.     vtable = "mailinglabels"
  2.     apppath = "C:\filmsextract"
  3.     appathx = ("" & apppath & "" + "\" + "mailinglabels.txt")
  4.     DoCmd.TransferText acExportMerge, , vtable, appathx, True
when the program get to the acExportMerge I get this error "The Microsoft Office Access database engine could not find the object 'mailinglabels#txt'. Make sure the object exists and that you spell its name and the path name correctly." can any one give me any clues and to what's going on.
Jan 19 '21 #1
3 2018
32,546 Expert Mod 16PB
My guess is that you only half consider what it is you're doing. You have an idea of the eventual results required but are then confusing it with the first step.

Are you trying to merge into a Word document (as implied by acExportMerge) or are you trying to create a Text file that you may later want to merge with the Word doc?

Documentation on the acExportMerge option is sparse but I'm guessing it is expecting a Word file address as its FileName parameter. It's also expecting this file to exist already, for your data to be merged into it. I doubt either of these is true.

I know that doesn't explain why the '.' is shown in the error message as a '#'. That looks like it's expecting a FileName plus a point within the file - say a bookmark - so it may be treating your "mailinglabels.txt" as File=mailinglabels with a Bookmark specification of "txt". In which case it's going to be mightily confused.

Maybe if the documentation were clearer this could all have been avoided simply.
Jan 20 '21 #2
CD Tom
489 256MB
Yes, I did notice that the table name "mailinglabels" and the .txt file has the same name. When I changed the .txt name to mailing.txt I didn't get the error. Thanks for you insight into this.
Jan 20 '21 #3
32,546 Expert Mod 16PB
Hi Tom.

I'm glad I could help, though I have to admit that wasn't my thinking. If that triggered something in you to check that though - all to the good.

BTW. I assume you set your response as Best Answer by accident, it was certainly not correct to do so, so I've reset it for you. I did consider setting mine but frankly it doesn't qualify either. It only triggered something. It doesn't take a new reader directly to the answer.
Jan 20 '21 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Brian Kazian | last post by:
Here's my problem, and hopefully someone can help me figure out if there is a good way to do this. I am writing a program that allows the user to enter an equation in a text field using...
by: Greg Raven | last post by:
I styled my links just the way I want them using CSS, but now my linked images have picked up these same styles. I've tried turning the styles off for the images with: a img { text-decoration:...
by: Todd Cary | last post by:
I inherited an application where the Flyout works in Firefox but not in IE. My JavaScript background is sparse, so I am not sure how to approach the problem. Any suggestions are welcomed! The...
by: Lee | last post by:
Hello All, First of all I would like to say thank you for all of the help I have received here. I have been teaching myself Access for about 4 years now and I've always been able to find a...
by: melanieab | last post by:
Hi, I'm trying to figure out how to take the string entered into a textbox, and if I don't just accept the number entered, if +, -, *, / were entered, to convert that into the correct number to be...
by: rk325 | last post by:
I have a question about cookies & browser permissions and turning off cookies when creating a web site (cookieless mode in web.config). I have a web site that of course uses Session variables....
by: UJ | last post by:
How do you turn on and turn off the debugging information on the end of a web page? Someone else set up a dev web site and a test web site and the dev has it turned on, the test turned off. I'm...
by: Siew-Ming | last post by:
Hi, Try to figure a way to turn off a folder Read-only property for a specific folder (Windows 2003) at multi sites. When we do our application upgrade/patch, we manually turn off the...
by: Rain | last post by:
Hi, I noticed the other day when I was trying to optimise the traffic on a particular web page that it had significant viewstate even though I had turned it off for most of the controls. So in...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.