 | |
Continuous forms colours
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Continuous forms colours -
11-17-2011
, 12:32 PM
|
Ok so as noted my suggestion was based on if the colors can be hard coded and not really be charged by end users. You digging up code to add CF seems like a good idea - I not aware of some vba 3 limit bug but you have to use the newest file formats and not a mdb but acceb Albert k. |
SP1 the program consistantly crashed the seconon time after doing a decompile
and compact as well as just after a compact. I believe there is a fix for
this, but quite frannkly I'm scared to try it again. Phil
#12
| |||
| |||
|
|
Using Access 2010, but without the SP1 applied. Last time I tried that the SP1 the program consistantly crashed the seconon time after doing a decompile and compact as well as just after a compact. I believe there is a fix for this, but quite frannkly I'm scared to try it again. Phil |
issue was that you have to use a accDB in place of mdb.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
#13
| |||
| |||
|
|
Using Access 2010, but without the SP1 applied. |
accDB file?
Most of the new features for 2010 cannot be used in older format mdb files.
I reasonable sure you checked this, but my spider sense says the 3 limit for
CF should only exists in mdb files.
Have you tried manually adding say 5 CF's to a database - does that work?
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
#14
| |||
| |||
|
|
"Albert D. Kallal" wrote in message news:BPlxq.22279$Mg.8638 (AT) newsfe13 (DOT) iad... "Phil" wrote in message news:ja3k02$brd$1 (AT) speranza (DOT) aioe.org... Using Access 2010, but without the SP1 applied. As a follow up - just to be sure, you are using A2010, but you are using a accDB file? Most of the new features for 2010 cannot be used in older format mdb files. I reasonable sure you checked this, but my spider sense says the 3 limit for CF should only exists in mdb files. Have you tried manually adding say 5 CF's to a database - does that work? |
The problem is solved, but just to keep you in the picture
Yes, I am using Access 2010 wit AccDbs.
The line
Set FormatCond = Me!AreaColour.FormatConditions.Add _
(acExpression, (acExpression, , "[AreaColour] = " &
Me.RecordsetClone!AreaColour)
only works up to a limit of 3 times .... unless
If you manually add 4 conditions, then that line works fine up to the limit
of 49 or is it 50. So in the code I posted, that is why I deleted the format
conditions, but left the last 4. I then added about another 10 format
conditions, making 14 in all, then applied the new formats to the 4th
condition onwards up to the 14 condition.
Phil
#15
| |||
| |||
|
|
only works up to a limit of 3 times .... unlessIf you manually add 4 conditions, then that line works fine up to the limit of 49 or is it 50. So in the code I posted, that is why I deleted the format conditions, but left the last 4. I then added about another 10 format conditions, making 14 in all, then applied the new formats to the 4th condition onwards up to the 14 condition. |
Thanks for the follow up.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.