August 30, 2008 02:20am pdt

1. capricorn1 2,357,876
2. DatabaseMX 1,578,962
3. LSMCons... 738,913
4. boag2000 655,583
5. peter57r 538,288
6. GRayL 451,989
7. harfang 437,453
8. jimhorn 322,342
9. cactus_d... 299,026
10. matthews... 256,874
11. TextReport 236,057
12. hnasr 232,150
13. ee_rlee 173,155
14. angelIII 163,304
15. puppydog... 149,767
16. jimpen 149,684
17. mbizup 147,354
18. jefftwilley 140,435
19. LPurvis 139,254
20. JezWalters 138,435
21. omgang 130,049
22. Rick_Ric... 126,252
23. koutny 122,251
24. tbsgadi 120,968
25. MikeToole 118,626

1. capricorn1 10,014,914
2. nico5038 5,704,781
3. rockiroads 5,409,687
4. peter57r 3,982,783
5. LSMCons... 3,475,503
6. DatabaseMX 3,462,423
7. LPurvis 3,398,221
8. shanesue... 3,288,317
9. harfang 3,054,286
10. stevbe 2,857,111
11. jimhorn 2,741,934
12. GRayL 2,611,833
13. flavo 2,111,583
14. mbizup 2,033,944
15. jadedata 1,964,977
16. jefftwilley 1,799,875
17. thenelson 1,697,869
18. matthews... 1,594,087
19. eghtebas 1,487,093
20. boag2000 1,338,327
21. puppydog... 1,329,230
22. Arthur_... 1,285,298
23. cactus_d... 1,271,815
24. jjafferr 1,265,357
25. dannywar... 1,260,596

07.15.2008 at 08:53AM PDT, ID: 23566556

	[x] Attachment Details

dcount sytax error

Asked by fh_freese in Microsoft Access Database

Tags: Microsoft, Access, 2003

I am having a problem with the criteria part of my dcount. What I want to do is to see if KanBan fro mmy tblPartNumber has already been used from Me.KanBan. If so I will inform the user this number already exists.

If DCount("[KanBan]", "tblPartNumber", "[Kanban] = " "& Me.KanBan &") > 0 Then
.
.
End IfStart Free Trial

Keywords: dcount sytax error

	Title
1	dCOUNT IN GROUP FOOTER
2	Date criteria in dcount
3	DCount Type Missmatch
4	DCount
5	DCount Function.
6	DCount criteria problem

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

dcount sytax error

Asked by fh_freese in Microsoft Access Database

Tags: Microsoft, Access, 2003

About this solution