Update records – IT Answershttp://itknowledgeexchange.techtarget.com/itanswers
Thu, 22 Feb 2018 06:01:05 +0000en-UShourly1could not update via DFUhttp://itknowledgeexchange.techtarget.com/itanswers/could-not-update-via-dfu/
http://itknowledgeexchange.techtarget.com/itanswers/could-not-update-via-dfu/#commentsFri, 07 May 2010 02:20:33 +0000I could not update a record via DFU even with proper authority or access rights, what could be the problem and how to resolve?

]]>http://itknowledgeexchange.techtarget.com/itanswers/could-not-update-via-dfu/feed/7Creation of array for input of datahttp://itknowledgeexchange.techtarget.com/itanswers/creation-of-array-for-input-of-data/
http://itknowledgeexchange.techtarget.com/itanswers/creation-of-array-for-input-of-data/#commentsMon, 29 Mar 2010 01:08:18 +0000Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ‘;’. There would be a maximum number of 10 entries...

]]>Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ‘;’. There would be a maximum number of 10 entries in this field. When the user presses submit, the table (tbl.base) would be updated with the entry in the source_code field, with each of the values inserted in the other entry fields. It would then loop until there are no more entries in the source_code field. Therefore in the dataset/table the source_code field would be populated with each different value but the other fields would be populated with the same values. Can anyone help with the required VBA code? Thanks