Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

Are these bugs in access 2003 forms?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Howard - 14 Oct 2005 22:31 GMT
Hi, I have two reproducible errors in access 2003 forms.

1) I have a form with a sub form set to be datasheet view. In design view I
set the background colour of a text box on this subform to blue and it goes
blue. However when the form is displayed, the textbox is still white. I'm
sure this procedure worked fine in access 2000.
The only way I could get round this was to set the text box with conditional
formatting with a condition that would always be met. (The default
conditional format colour was ignored as well)

2) Frequently, in access 2000, when designing the control source query of a
form (embeded, not as a stand alone query) I would run the query to check
that it returned the correct data. Doing this in access 2003 causes the
machine to freeze, and then after about 20s to report a fatal error and shut
down access. Happens every time.

Are these new features in 2003?
Howard
Allen Browne - 15 Oct 2005 04:36 GMT
#1. AFAIK, the backcolor has never worked in datasheet view.
Perhaps you were using Continous view before?

#2. Access 2000 and 2003 use the same data engine (JET 4), so this could
indicate a problem with the database. Try this:

1. Uncheck the boxes under:
   Tools | Options | General | Name AutoCorrect
Explanation of why:
   http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
   Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
   "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
       "c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi, I have two reproducible errors in access 2003 forms.
>
[quoted text clipped - 14 lines]
> Are these new features in 2003?
> Howard
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.