Hello
I'm working on a database which contains surveys.
Currently I'm having issues with a form that allows users to renumber the survey by dragging questions from one place to another, and also decide weather a question is stand alone or has subquestions. I have actually completed this form and it works perfectly on our database, but a co-worker of mine is working on a different project and said that she would like to use this form and perhaps other people could as well. So I spent today generalizing this form to any database. The design is as follows:
I have a listbox with all the queries and tables in the database, this will be the source
I have a listbox of all fields in the selected source, so that the user will highlight which field will hold the numbering
I have a listbox of all fields in the selected source, so that the user can highlight which fields he/she would like shown in the form next to each number (the update query will also link on the non-memo type fields within these)
and one more listbox for the destination table, the table which has the given numbering field and all of the fields that the user selected for viewing
The program used to work by first loading the source into the listview and after processing it, the program would create a temp table, run an update query on the destination and then delete the temp table. But since I had to generalize, I ran into a problem of linking on memo fields. So it is now changed to where the program first runs a maketable query on the source, then loads listview, then after the manipulation only the numbering field is updated in the temp table (this preserves the fieldtypes), and after than an update query is created and ran such that it only links on nonmemo fields. Long story short, after running the code sometimes it says some fields weren’t updated, and all of them are under key violations. The odd thing is that, the field being updated is never a key field, it has no restrictions of formatting, and it has the same field type as the one I’m updating it with (it must, because of how the program is structured). But if I open the table and change those fields by hand, no error is thrown. I have absolutely no idea what could be causing this
ms access 2003 sp3
Any help would be greatly appreciated.
I'm working on a database which contains surveys.
Currently I'm having issues with a form that allows users to renumber the survey by dragging questions from one place to another, and also decide weather a question is stand alone or has subquestions. I have actually completed this form and it works perfectly on our database, but a co-worker of mine is working on a different project and said that she would like to use this form and perhaps other people could as well. So I spent today generalizing this form to any database. The design is as follows:
I have a listbox with all the queries and tables in the database, this will be the source
I have a listbox of all fields in the selected source, so that the user will highlight which field will hold the numbering
I have a listbox of all fields in the selected source, so that the user can highlight which fields he/she would like shown in the form next to each number (the update query will also link on the non-memo type fields within these)
and one more listbox for the destination table, the table which has the given numbering field and all of the fields that the user selected for viewing
The program used to work by first loading the source into the listview and after processing it, the program would create a temp table, run an update query on the destination and then delete the temp table. But since I had to generalize, I ran into a problem of linking on memo fields. So it is now changed to where the program first runs a maketable query on the source, then loads listview, then after the manipulation only the numbering field is updated in the temp table (this preserves the fieldtypes), and after than an update query is created and ran such that it only links on nonmemo fields. Long story short, after running the code sometimes it says some fields weren’t updated, and all of them are under key violations. The odd thing is that, the field being updated is never a key field, it has no restrictions of formatting, and it has the same field type as the one I’m updating it with (it must, because of how the program is structured). But if I open the table and change those fields by hand, no error is thrown. I have absolutely no idea what could be causing this
ms access 2003 sp3
Any help would be greatly appreciated.