I have been having some trouble trying to figure out how to give the
user data retreived from a MySQL database in the form of a
ResultSetTableModel inside a JTable. Once the user sees the data, I
want them to be able to check some check boxes then click next to
continue. The only way I have found to be able to have functioning
check boxes is to use the updateInt() function, then updateRow()
function.
The problem is that this updates the database with the checked values,
and I want the check boxes to always be unchecked when queried. Does
anyone know how to modify a resultSet or tablemodel so that it changes
in the Jtable, but not in the database?
Re: access 2003 ... I removed the parameters from the form query source....boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ... (microsoft.public.access.conversion)
Re: access 2003 ... I removed the parameters from the form query source.... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ... (microsoft.public.access.conversion)
Re: access 2003 ... I would focus on the queries behind the combo boxes.... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ... (microsoft.public.access.conversion)
Re: Creating search form to return results in report ... What is the RecordSource property of your form? ... Are they check boxes?... know my form is bounded to my database and the combo boxes are unbounded too. ... >I am creating a mail parcel database that contains information such as ... (microsoft.public.access.formscoding)
RE: adding record via form ... the new table 'B' already existed in the database.... > the information in the three text boxes and add them to table 'B'. ... >> programmatically creating the table on the SQL server via Access? ... put this VBA code in the form's open event: ... (microsoft.public.access.forms)
