Like I told in post #3 I did already the basic troubleshooting , and even more like decompiling.
And because, like I also mentioned, I was almost sure it was not in the VBA code since I still had the problem with a reduced basic code in the form_load (and deleted all other methods), I didn't post the VBA code in my question.
I was only looking if someone could give me any direction to look at, because this form has different...
Taaner
Last Activity: Mar 18 '14, 08:10 AM
Joined: Mar 2 '12
Location: Belgium
-
I had to mention I already tried decompiling, compact & repair and re-compile, nothing works. Debuging is not possible since the problem only excists in the .accde but not in the .accdb. Like I mentioned I already reduced the code to only changing a text field on the screen in the form_load but that is not executed (and no error message).
I also searched the internet. Most issues I found were about trusted locations but in my opion...Leave a comment:
-
2007 accde not fully working on 2010
Hey, I have a frontend .accde created from a .accdb with Access 2007.
It works fine on Access 2007, but when I run it with Access 2010 it seems that the form_load function of the second form is not executed. The one of the main screen works fine.
Even when I reduce the code to a minium (changing 1 text field so I see something happens) is not working.
If I make a .accde in Access 2010, it works fine (on 2010 but... -
Hey, can you tell us what your concrete question is?
Is the VBA code not working at all, do you get an error message, are the files not/wrong created?Leave a comment:
-
Thanks for the replies Z. Since we have both version 2003 and 2007 applications the history is part of the story.
And indeed it are the engines that handles this so I have to study how these work.
I already read some topics about the need of migrating .mdb's to .accdb's when every user is moved to Office 2007 or 2010. And it seems this can help for performance but in other cases repsonse times are worse? Do you (or someone...Leave a comment:
-
What goes over the line when running a query?
Hey,
we use a lot of Access VBA applications with backend shared on a network drive and distributed frontend on the PC of the users. And we have some performance issues, mostly when users are not on the HQ LAN but on in a regional office over a WAN or from home by VPN.
I try to optimize the code of this applications (actually the application and the database should be redesigned but that is not an option now) but I don't... -
Technically it depends on how the compiler translates the commands but I guess the VBA compiler translates a SELECT CASE the same as IF-THEN-ELSE
Rabbit is correct that you will see no performance difference if the code is executed once, or even ten or hundred times, but if it is a function or in a loop that is executed a million time, it is another question. That is something you learn when programming for high performance environments,...Leave a comment:
-
At our PC's is McAfee but I think the site was already blocked by the firewall in the datacenter.
Maybe it is a false positive but it is good to inform the webmaster to check his site.Leave a comment:
-
We have a sensitive protection here at the company.
Maybe it is a false alarm but I don't have the tools here to check it out (yep, heavy security but have to use IE9 as browser).Leave a comment:
-
Z,
I get following message when opening your link "A Tutorial for Access":
The page you've been trying to access was blocked.
Reason: Virus Detected! The page or file you requested is infected with the following virus: Trojan.JS.Ifram e.gen.
Transaction ID is 5151B33C3779130 E8495.
So maybe it is better to remove the link...Leave a comment:
-
Thanks for this information Mark. I was always sceptic towards using memo-fields in a database, this article confirms to avoid the use especially in an Access database.
Should the article not been moved to "insights" since it is not a question?Leave a comment:
-
Taaner replied to automation error. Library not registered - Microsoft Access and Visio compatibilityin AccessWe had a simular problem with MS Office 2007 + MS Project 2010 The problem is solved by running MS Office Diagnostics.
I hope this will work for you.Leave a comment:
-
We have no problem with 10+ users on Access applications, but to avoid problems we always copy the FE to local drive of the user. I think this is a must-do in this case.
This week I noticed an application with a BE of +1 GB and it works smoothly over the LAN. But we have performance issues with an application with a BE of only 40 MB. It depends on how the application and data is designed, and how intense the use of the data is.Leave a comment:
-
What do you want to validate?
- the correct syntax of the xml (have all start tags a closing tag, nested correctly, etc...)
- validating against a schema
- the data itself
For the last one, the solution of NeoPa is common practice. Of course you can also consider to read the xml file as a textfile but then you need to interpret the tags yourself.
I have no idea if there are functions for xml syntax validation...Leave a comment:
-
At our company they made a Application menu application in Access. Users have to install this, during installation an entry in the Windows Menu is created.
The applications are in separate networkmaps with separate security groups. When starting the application menu application, the userrights are checked to know what applications this user is allowed to start.
In each application folder there is an .ini-file that contains...Leave a comment:
-
One extra thing on the solution of TheSmileyCoder: if the first record(s) is empty, another empty string will been written to it. If you want to avoid this, fill strText with a default value before the loop.Leave a comment:
No activity results to display
Leave a comment: