Forums
This topic is locked
Recordset problem
08 Feb 2003 19:56:22 Brian S posted:
I have created a recordset and when I test is everything is fine except 1 of the fields which is a number field comes back as 0 on all records. Not sure if it's something wrong with access or my code.Thanks in advance
Brian
Replies
Replied 08 Feb 2003 19:59:41
08 Feb 2003 19:59:41 asp asp replied:
Is this the ID field? if so change it to "Increment". Autonumber
Replied 08 Feb 2003 20:01:08
08 Feb 2003 20:01:08 Brian S replied:
Not ID field and I changed it to a text field and came up with the same result, all zeros
Replied 08 Feb 2003 20:53:37
08 Feb 2003 20:53:37 asp asp replied:
Make sure in Access that there is NO DEFAULT VALUE, maybe its set to 0
Replied 08 Feb 2003 20:55:37
08 Feb 2003 20:55:37 Brian S replied:
It was set to 0, but changed that to no default value and still same thing
Replied 08 Feb 2003 21:04:59
08 Feb 2003 21:04:59 Brian S replied:
The thing I don't get is when I change it to a text field with no default value, delete all entries in the field, it still comes up as all zeros
Replied 08 Feb 2003 21:53:37
08 Feb 2003 21:53:37 asp asp replied:
ok, i suggest deleteting the table and create a new one with the same name! you might have set something somewere and this could be the problem!
Replied 08 Feb 2003 21:58:57
08 Feb 2003 21:58:57 Brian S replied:
You read my mind and it's working right now.
Replied 08 Feb 2003 22:18:56
08 Feb 2003 22:18:56 asp asp replied:
great