473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Path Not Found .\VB9.tmp

Hello,
I'm dynamicaly adding controls to report. It's working fine but in one computer it throws "path not found .\ VB.temp" error. The VB.temp name is changing to VBA.temp, VBC.temp.....
Configuration of that computer is the same like the others.
Any idea?
Thank you very much
Nov 18 '07 #1
18 6662
ADezii
8,834 Expert 8TB
Hello,
I'm dynamicaly adding controls to report. It's working fine but in one computer it throws "path not found .\ VB.temp" error. The VB.temp name is changing to VBA.temp, VBC.temp.....
Configuration of that computer is the same like the others.
Any idea?
Thank you very much
This is a new one for me, sorry but I've never heard of anything remotely similar to this. I can't see how the process of dynamically adding Controls to a Report could generate a Path Access Error unless it relates to a problem with an Access related Library. Check your References for any ones that are MISSING or BROKEN.
Nov 19 '07 #2
NeoPa
32,556 Expert Mod 16PB
...
Configuration of that computer is the same like the others.
...
I doubt that very much. PCs VERY rarely are configured the same as any other PC. Even rarer is to find two PCs with the same setup after any time has elapsed.
How did you decide they were the same?

I don't ask this simply to be argumentative. I suspect that your problem is to do with a difference on the individual PC. It's not possible for me to guess where without access to the PCs themselves, but this is certainly down to a difference between this PC and the others.
Nov 19 '07 #3
I doubt that very much. PCs VERY rarely are configured the same as any other PC. Even rarer is to find two PCs with the same setup after any time has elapsed.
How did you decide they were the same?

I don't ask this simply to be argumentative. I suspect that your problem is to do with a difference on the individual PC. It's not possible for me to guess where without access to the PCs themselves, but this is certainly down to a difference between this PC and the others.
Sure. I mean op. system, the version of Access and The registered references. OK I was hopping, it's some kind of common problem. I try to check the other things, but there's no clue.
Thank you much
Nov 20 '07 #4
NeoPa
32,556 Expert Mod 16PB
I'm sorry I couldn't be more help, but I'm sure it's in the PC rather than in the code. It may be in the setup & configuration of Access though. I'd look there first.
Nov 20 '07 #5
I'm sorry I couldn't be more help, but I'm sure it's in the PC rather than in the code. It may be in the setup & configuration of Access though. I'd look there first.
I found out, that the problem pops up in DoCmd.CopyObject procedure. I have template report, then a make a copy -> open the copy, create some controls and export to PDF.

In the step of copiing object it throws Path no found .\VB9.tmp

Thank you very much
Nov 22 '07 #6
NeoPa
32,556 Expert Mod 16PB
In that case I'm afraid you're out of luck :(
This sounds very similar to a problem I'm having with (only) one of my PCs at work where an Excel procedure fails (on a sheet copy) with a very similar message. I've searched the web exhaustively, but if it's out there - my searching skills must be duff, as I couldn't find anything helpful (and nor could a colleague whose searching skills I've always found to be very good).
Anyway, I will be monitoring this thread very carefully in case someone does come up with something helpful. Please post back if you find anything elsewhere. This one I'm really interested in. Sorry I couldn't be more help.

I will however, direct some more experts to have a look in case any one of them has anything to add.

BTW I also edited the title so that searches for this issue will catch this. What you had looked similar but the space and the "temp" would have thrown off any matching search.
Nov 22 '07 #7
MMcCarthy
14,534 Expert Mod 8TB
I found out, that the problem pops up in DoCmd.CopyObject procedure. I have template report, then a make a copy -> open the copy, create some controls and export to PDF.

In the step of copiing object it throws Path no found .\VB9.tmp

Thank you very much
Can you post the actual code of this procedure you are using. Also are you working with one database or copying the object across from another or to another database?
Nov 22 '07 #8
Can you post the actual code of this procedure you are using. Also are you working with one database or copying the object across from another or to another database?
Sure I can, but there nothing strange in this procedure
Expand|Select|Wrap|Line Numbers
  1. [   ...
  2. stDocName = "offer"
  3.  
  4.     tempStDocName = "offerTemp"
  5.     DoCmd.CopyObject , tempStDocName, acReport, stDocName
  6.  
  7.     DoCmd.openReport tempStDocName, acViewDesign
  8.  
  9.     Set rep = Reports(tempStDocName)
  10.     Set conn = CurrentProject.Connection
  11.     Set rs = New ADODB.Recordset
  12. ....]
its inside one database.
Before this code are only declarations of variables.
It stops on bolded line.

*Edit* #5
Nov 22 '07 #9
MMcCarthy
14,534 Expert Mod 8TB
Does it make any difference if you do this ...

Expand|Select|Wrap|Line Numbers
  1. stDocName = "offer"
  2. tempStDocName = "offerTemp"
  3.  
  4. DoCmd.CopyObject CurrentDb.Name, tempStDocName, acReport, stDocName
  5.  
  6. DoCmd.openReport tempStDocName, acViewDesign   
  7.  
Nov 22 '07 #10
missinglinq
3,532 Expert 2GB
Can you post the actual code of this procedure you are using...
Sure I can, but there nothing strange in this procedure... Before this code are only declarations of variables.
When asked to post code, you really need to post the entire sub or function, rather than just the portion that you feel is pertinent. This is, after all, the place you've declared as being the source of the trouble! Things as seemingly innocuous as variable declarations can and do cause otherwise valid code to blow up, and VB/VBA is notorious for not actually hiliting the exact line that causes an error! We don't even know what event this code appears in, which can also make a difference in whether or not a particular piece of code works!

Welcome to TheScripts!

Linq ;0)>
Nov 23 '07 #11
FishVal
2,653 Expert 2GB
Hi, freeheel.

Nothing particular. Just thoughts.
  • did you try to run DoCmd.CopyObject on different objects in the problematic db?
  • does it fail with objects other than the report?
  • check whether the user has write permissions to the folder where temp file is created or whether drive mentioned has enough space
Nov 23 '07 #12
NeoPa
32,556 Expert Mod 16PB
Thank you all for your efforts.

I can't speak for the OP, but certainly in my case the situation only occurred on a single PC. This would indicate that the PC (or user) is somehow different. My guess is that FishVal's last point is closest to the nub. However, in my situation certainly, I did test these issues out and couldn't find anything wrong or different with the setup. Obviously we all miss things sometimes and I wouldn't be at all surprised if I have here too.

Clearly the code may give clues, but bear in mind that in both cases (OP's & mine) the code is working perfectly on most PCs.
Nov 23 '07 #13
missinglinq
3,532 Expert 2GB
For the reasons mentioned having the complete code may not shed more light on this situation, but the complete code should always be given, as a general policy, for the reasons I gave.

I tend to agree with you, Ade, in that it certainly sounds like something is amiss with individual PCs in both of your cases. I'm not certain that both of your problems will be resolved in the same way, but I tend to think this is something that's ultimately going to have to be solved "on-site" as it were!

Linq ;0)>
Nov 23 '07 #14
NeoPa
32,556 Expert Mod 16PB
You're probably right Linq.
I'm hoping that someone will recognise the error message though, and point out something they've already stumbled across though. Like "Oh, the temp files folder needs to be set up differently for the user and the OS. Duh, you didn't even know that." Or some such obvious solution.

PS. I've done a lot of very thourough testing and experimenting on this user's PC and can't find anything that will get around this problem.
Nov 26 '07 #15
Denburt
1,356 Expert 1GB
Have you used the CopyObject in other procedures or as Fishval suggested on other objects? If so and the same error arises then how about trying a different or new database.

Is there an actual error number or just the message? I like to think I am pretty savvy at finding result in searches yet I am not finding much on this one. At least nothing that would appear to help.

Last but not least if it only hits this snag once in a while, try trapping the error then use that to rerun CopyObject.
Nov 26 '07 #16
NeoPa
32,556 Expert Mod 16PB
I'll try to put something together from my problem Den and PM you the details (if you don't mind looking for me). I've tried but got nowhere. I'm sure it's the same issue - but it's in Excel rather than Access. It's a fundamental Office way of handling its temp files that's at work here but what? I don't know.
Nov 27 '07 #17
MMcCarthy
14,534 Expert Mod 8TB
I'll try to put something together from my problem Den and PM you the details (if you don't mind looking for me). I've tried but got nowhere. I'm sure it's the same issue - but it's in Excel rather than Access. It's a fundamental Office way of handling its temp files that's at work here but what? I don't know.
Have you tried comparing the environment variable values for the temp files on the various computers?
Nov 27 '07 #18
Denburt
1,356 Expert 1GB
I'll try to put something together from my problem Den and PM you the details (if you don't mind looking for me). I've tried but got nowhere. I'm sure it's the same issue - but it's in Excel rather than Access. It's a fundamental Office way of handling its temp files that's at work here but what? I don't know.
Sure post away Neo, I would be happy to take a look and see if I can replicate/resolve the issue.
Nov 27 '07 #19

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

Similar topics

4
by: Hal Vaughan | last post by:
I want to have a config file for my program, which means I need to know where the config file is. If I type: java myclass and it runs myclass.class, is there any way to obtain the location of...
70
by: Michael Hoffman | last post by:
Many of you are familiar with Jason Orendorff's path module <http://www.jorendorff.com/articles/python/path/>, which is frequently recommended here on c.l.p. I submitted an RFE to add it to the...
20
by: Webdad | last post by:
Hi! I running my first year as industrial engineer (informatics) We have an assignment to do : .... create a playfield (matrix). Some places in that field are blocked, so you can't pass them....
15
by: (Pete Cresswell) | last post by:
I've got a .BAT file that I use for executing various MS Access apps that I wrote way back in the days of 2.0. It's evolved over time, but it still contains a number of possible paths to...
6
VB9
by: guy | last post by:
given that VB9 is already being discussed what is the expected lifespan of VB2005? guy
35
by: Justin Weinberg | last post by:
My thoughts on this.... http://msdn.microsoft.com/vbasic/Future/default.aspx?pull=/library/en-us/dnvs05/html/vb9overview.asp My thoughts: 1. Regarding Implicit types, I don't use type...
1
by: guy | last post by:
further to the comments raised by Justins VB9 post a few days ago - to which i have never seen such agreement! - is there a site we can contact with our opinions on the proposed changes? --guy--
3
by: =?Utf-8?B?U2llZ2ZyaWVkIEhlaW50emU=?= | last post by:
I'm feeling fustrated with my efforts so far. http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=whatsnewvb&ReleaseId=123 is a little overwhelming and I cannot get some...
14
by: Just_a_fan | last post by:
In VB6, I could easily take the value from a combo box and make a command with it, this: baudrate = cboBaud(listindex). With the new dotted stuff in VB9, I can't seem to do that. Here's an...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.