May 28, 2008 at 12:32 pm
I have a table defined in my access database where one of my fields is set as a default value. I also setup a form for this table to enter in various sets of records.
My question is this. I have this table linked in another access database and when I want to run a query that updates this table, I always have to type a space, in this field, in order to populate a record into this table. I'm not sure why this is happening, but I want to come up with a fix, so I don't have to type in a space to this field each time I want to add in a record to this table.
Any possible suggestions are welcomed.
June 2, 2008 at 8:44 am
The only thing I can think of is the field does not allow nulls.
Is your data is stored in an mdb?
June 2, 2008 at 9:56 am
I would say no since it only allows to store some type of numeric value into it and yes this table is store in a mdb database. I was able to come up with a solution to append a default record to the table. From there, it touches the field with a default setting and then can re-write over the cell to update a new numeric value.
June 13, 2008 at 4:48 pm
Could it be that the field is set for Required = Yes - ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply