Hi All,
Thanks for your effort, I did submit this question in MSDN forum, and I got the answer.
http://social.msdn.microsoft.com/For...5-1c6daacecfbd
Thanks for all of you.
Ahmed Eissa...
Ahmed Eissa
Last Activity: Nov 22 '10, 12:31 PM
Joined: Nov 9 '10
Location: London, UK
-
Leave a comment:
-
Hi NeoPa,
Sorry for not reading your previous reply compleatley.
Yes, I can confirm that the SQL query you provide is giving the same result I provide.
Basicly, I am using MS Access 2003, with VBA code, and as I said, the value of N in the design time (if we run the code in "Immediate" window) will be 4, but during the execution of the code (Run time) it's return 6. In other words, if I run a...Leave a comment:
-
Hi NeoPa,
Thanks for trying helping me, the code is:
...Code:Dim Cn As New Adodb.Connection Dim Rs As New Adodb.Recordset Dim SQL As String, LNo as Long, N as Integer With Cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = Application.CurrentProject.FullName .Open End With SQL = "Select * from Bords"
Leave a comment:
-
Hi All,
It back again... I don't know why!
It back giving me 6 rather than 4.
I think it's a bug in MS Office Access 2003.
Thanks.
AhmedLeave a comment:
-
Hi ADezii,
I tried it, but it still gives 6. Both are Integers.
Thanks.
AhmedLeave a comment:
-
Hi NeoPa,
Thnaks for your solution, it works, but why it was not working before? I mean if I write the same code, which was cosing the problem in the "Immediate" box in VBA editor, it gives 4 which is currect, rather than 6 which is wrong, but only in the run-time it return 6 rather than 4. Can you explaine to me what the reson?
Sorry for putting this question in an existing thread.
Also, many...Leave a comment:
-
DCount() Confusion
I am having the same problem... I am using Access 2003 SP3 and in the table, the records are:
...Code:no BordIndex name signoff comments ------------------------------------------------------ 1 71 Prod1 0 - 2 71 Prod2 1 Bad 3 71 Prod3 0 - 4 71 Prod4 1 Expired 5 71
Last edited by NeoPa; Nov 9 '10, 04:51 PM. Reason: reformatting + Split and added link to original thread
No activity results to display
Leave a comment: