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
18 6662
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.
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.
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
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.
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
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.
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?
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 - [ ...
-
stDocName = "offer"
-
-
tempStDocName = "offerTemp"
-
DoCmd.CopyObject , tempStDocName, acReport, stDocName
-
-
DoCmd.openReport tempStDocName, acViewDesign
-
-
Set rep = Reports(tempStDocName)
-
Set conn = CurrentProject.Connection
-
Set rs = New ADODB.Recordset
-
....]
its inside one database.
Before this code are only declarations of variables.
It stops on bolded line.
*Edit* #5
Does it make any difference if you do this ... -
stDocName = "offer"
-
tempStDocName = "offerTemp"
-
-
DoCmd.CopyObject CurrentDb.Name, tempStDocName, acReport, stDocName
-
-
DoCmd.openReport tempStDocName, acViewDesign
-
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)>
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
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.
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)> 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.
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.
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.
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?
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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....
|
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...
|
by: guy |
last post by:
given that VB9 is already being discussed what is the expected lifespan of
VB2005?
guy
|
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...
|
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--
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
| |