Search results for query: *

zionman4: Not so easy to post because the code is on an isolated network at work. But, here is the deal: - I have a table with distribution lists and members, with one person a possible member of many DLs. joesmith@comcast.net might be in 30 DLs. - I'm viewing one DL with Joe Smith in it and...

IrishJoe: It seems like you are tabbing to a different view of the same record, and changing it as you leave one tab to the next so the next form takes the record for writing as the first one tries to write it. Have you tried a SaveRecord? Maybe leave the record with a prev/next record then go...

I discovered my problem. I was in a subform record where the field value could repeat for many parent records. When I changed the field I did an after update sql to update the entire table, including the record on the form. The form was trying to write the updated record and so was the sql...

hecash, Yes, I saw that. I'm not dealing with mySQL, so it is not the answer. I think the stored procedure is the answer, but I have to wait until tomorrow to try it out. If nothing else, close the current form, update the table(s), then reopen the form. Chris

I, too, have had this problem. It is consistent, and less complex the IrishJoe's. Here it is. I have a form with a subform. The subform gets its data from 2 tables. TableX is the main table with groups and members of those groups. The other table is an Action table related to TableX and shows...

I just used mysqldump. Seems to work great, though I have not tried the restore. We would rather use select * into outfile....... as the companion to load data local infile. However, while the load data local infile.... works great, there is not a 'local' option for select * into outfile...