msAccess column update

wee wullie · Post by **wee wullie** » Sat Oct 24, 2009 12:57 am

I have an app that connects to a access db via vbscript, i can add and update records in the db, but only if all columns have data,
i.e. i get an error message if any of the columns are empty,
but if they all contain data the db updates or adds a new row,

the db table has the following eleven columns:
ID, First Name, Last Name, date1 - date8 ,

Some records have all fields filled in and some dont and the ones that dont wont update or add to the db,

my app uses custom props to store the various vbscripts and that is called via button scripts,

Anyone know of a way round this?

Janschenkel · Post by **Janschenkel** » Sun Oct 25, 2009 12:17 pm

It's a little difficult to say without the esource code or the database structure. So I'll start with the obvious question: are those columns marked as NULL allowed or not?

Jan Schenkel.

wee wullie · Post by **wee wullie** » Sun Oct 25, 2009 4:37 pm

Hi Jan, thanks for the reply, I didnt think it was updating but it is, its just that when i update it displays the updated data in a new list field and not the field that contains all the other data so it looked like it wasnt updating correctly, however when i use the find all records button the newly updated data is there, what was causing confusion was that i have a fixed column header above the list field which simply makes the list field look more like a datagrid so even though it displays the new data it looks like its wrong because the fixed col header remains there regardless of the new data attributes, so i think i've got it, i'll just have to make a col header for each truck type and use show/hide type commands depemnding on what update button is pressed.

So thanks Jan