Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Pikwa
  • Order by date
  1. Pikwa

    Write Conflict

    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...
  2. Pikwa

    Write Conflict

    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...
  3. Pikwa

    Write Conflict

    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...
  4. Pikwa

    Write Conflict

    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
  5. Pikwa

    Write Conflict

    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...
  6. Pikwa

    data export/import utility

    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...

Part and Inventory Search

Back
Top