After Conditional Formatting shown Error in datasheet formulas (1 Viewer)

S

sandya

Registered User.

Local time

Today, 20:51

Joined

Oct 27, 2013

Messages

82

• Oct 16, 2014

• #1

Hello Friends, Can any one solve my issue

After conditional formatting with every new entry in Datasheet Item Code or Item Description then after row Disc % and Amount default value’s is shown as #Type! And datasheet is very slow with flickering. If it conditional formatting is remove then working as well. I have attached the Screenshots and dB file so can you please help how to solve this problem?

in Form: PurchaseEntry

Thanks,
Sandhya

 

Attachments

• 
  ScreenShot.jpg

  102.5 KB · Views: 92
• 
  Cformatting Screenshot.jpg

  33.1 KB · Views: 117
• M4.zip

  238 KB · Views: 73

M

Mihail

Registered User.

Local time

Today, 18:21

Joined

Jan 22, 2011

Messages

2,373

• Oct 21, 2014

• #2

Unfortunately the DB is in a newer version of Access and I can't open it (I use 2007)

 

S

sandya

Registered User.

Local time

Today, 20:51

Joined

Oct 27, 2013

Messages

82

• Oct 21, 2014

• #3

Thanks for replay...
Yes, am using access 2010 version. So Just now i tried to convert in 2007 version but it is can't converted and shown a msg "You cannot save this database in an earlier version format, because it uses features that require the current file format." so there is any way to solve this problem?

Thanks,
Sandhya

 

M

Mihail

Registered User.

Local time

Today, 18:21

Joined

Jan 22, 2011

Messages

2,373

• Oct 21, 2014

• #4

Can you post one more pic with your form in design view ?

 

S

sandya

Registered User.

Local time

Today, 20:51

Joined

Oct 27, 2013

Messages

82

• Oct 21, 2014

• #5

i have attached the form design view screen shots please find it.


Thanks,
Sandhya.

 

Attachments

• SubformDesignView.zip

  116.9 KB · Views: 65

J

JHB

Have been here a while

Local time

Today, 17:21

Joined

Jun 17, 2012

Messages

7,732

• Oct 22, 2014

• #6

Try to remove both conditional format for "Item Code"!

 

S

sandya

Registered User.

Local time

Today, 20:51

Joined

Oct 27, 2013

Messages

82

• Oct 22, 2014

• #7

Yes, i removed conditional formatting on Item Code. But still no change it is shown a datasheet as slow and formulas shown as #type! for every new entry. Is it any way to solve at least formulas error? #type! :banghead:

 

J

JHB

Have been here a while

Local time

Today, 17:21

Joined

Jun 17, 2012

Messages

7,732

• Oct 22, 2014

• #8

Try the attached database, by me it works, but ...

 

Attachments

• 
  ConF.jpg

  74.9 KB · Views: 230
• M48.zip

  71 KB · Views: 60

S

sandya

Registered User.

Local time

Today, 20:51

Joined

Oct 27, 2013

Messages

82

• Oct 22, 2014

• #9

Sorry, if your trouble facing about my issue

Actually my problem is after conditional formatting in subform datasheet is very slow and formulas sometimes shown error (#Type!) on entering with new items. So both problems are not resolved in your attached db also. So not a major problem with datasheet slow. After mostly i need to resolve formulas error. I have attached the screenshot with explanation. Can you please solve this problem.

This problem effected with conditional formatting only otherwise no problem for both of issues.

 

Attachments

• 
  Error Screenshot.jpg

  56 KB · Views: 68

J

JHB

Have been here a while

Local time

Today, 17:21

Joined

Jun 17, 2012

Messages

7,732

• Oct 22, 2014

• #10

sandya said:

Sorry, if your trouble facing about my issue

Click to expand...

No problem - I haven't any trouble.
As in my attached picture, you see, I haven't the problem with (#Type!).
The speed problem is caused by the Conditional Formatting and ofcause depend of the hardware.

 

S

sandya

Registered User.

Local time

Today, 20:51

Joined

Oct 27, 2013

Messages

82

• Oct 22, 2014

• #11

Hmmm sometimes shown this error (#type!) any way thanks a lot