Solved

msaccess report hangs when you add several control sources  and delete the text box attached

Posted on 2012-04-10
13
374 Views
Last Modified: 2012-04-10
have a funny problem
have the report set up working fine running off a query, and dispplays ok, then if i add another field from the field list then delete the txt box attached to the field, the report just hangs and does nothing . close it open it do the same again and it hangs again

have rebuilt and also imported the db into a clean data base but makes no difference
any ideas
taserror.png
0
Comment
Question by:sydneyguy
  • 6
  • 5
  • 2
13 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 37827423
why the need to delete the textbox?, if you don't want to see the field as part of the report, size the textbox to a minimum.
run the report..

could it be that the textbox is referenced in any calculation?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37827656
Also it is not clear what your screenshot is supposed to be telling us?
(why the overlapping controls?)

FWIW, anytime I make design changes to an object, I run the compact/repair utility.
0
 

Author Comment

by:sydneyguy
ID: 37827669
the text box is not referneced in any calculation, its the text of the bound field, and you may not always need the text and in this case i do not need them, or i may want to move it , and this has never happened before, normally works fine except for this time.
0
 

Author Comment

by:sydneyguy
ID: 37827683
i have never needed to run the compile any time i have made a change, never needed this before.
the overlaping control is one that i droped on then run it and it displays, then you delete the text associated to the text object and it freezzes never seen this before
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 37827735
could be a corrupted report.. try to make a new report.
0
 

Author Comment

by:sydneyguy
ID: 37827746
i did, 3rd thing that i did, even rebuilt a system using min components and it still happens
have just found out that if i copy the objects to another report it actiually behaves and alows me to delete the text and still works
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 119

Expert Comment

by:Rey Obrero
ID: 37827756
what version of office are you using?
is it updated to the latest SP?
0
 

Author Comment

by:sydneyguy
ID: 37827926
2003,
but dont think this is the problem it wa happening another pc running 2007,
i think i will just rebuild all the reports in question and try and build aroudn the prop and see how that goes, before i strat chasing after updates, just never seen this before
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 37827939
<i have never needed to run the compile any time i have made a change, never needed this before.>
That could be part of the problem.
You should always compile your code after editing sessions.
In addition to cleaning up the modules for faster execution, it will identify some common coding syntax errors.
See # 5 and #6 here:
http://www.everythingaccess.com/tutorials.asp?ID=Preventing-corruption

Not saying that this will fix your issue here, only that you should try all the basic troubleshooting techniques, just to be sure...
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 37827943
ok..
0
 

Author Comment

by:sydneyguy
ID: 37827988
the system probably has some curruption in it, as it is an unstable network and have had to change machines quite oftern under extreme power off situations, so the link page above has been very useful so thanks for that
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 250 total points
ID: 37828010
<as it is an unstable network and have had to change machines quite oftern under extreme power off situations>

this situation will corrupt your application, tables, forms and reports
0
 

Author Closing Comment

by:sydneyguy
ID: 37828030
thanks for the help
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now