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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy