Recent content by perldiver

Joe, I'm getting the feeling this can't be done and that I'm wasting your time like my own trying. Here is the new problem with this list box approach. When the data entry person selects the record for the child requiring some updates, they are presented with a central form that contains five...

Joe, I'm headed to the office now to try the code changes..... yes "extended" would be a better choice. Oversight on my part..... Thanks again Tom

Thanks for the reply Joe? staff_id as it relates to tbincident is an (int). What is populating the list box is a simple query "select staff.* from staff;" the output in the unbound list box should be , Two columns staff_id and staff_name. Staff_id in this cause is an integer, and staff_name...

HTH, Tried the code on the command button .... made a few name changes to match tables renames so here's how it reads...... Private Sub Command2_Click() 'code in your command button Dim strSQL As String Dim strIN As String Dim i As Integer 'create a SQL syntax, watch for word wrap 'word of...

HTH, In looking over this it dawned on me that I mentioned the Staff field in the incident_log shouldn't be there. I don't want to give you the impression that I wanted to insert the selections from the listbox into the staff field of the incident_log as a comma delimited string. I'd rather...

HTH, Thanks for the rapid response. I have a couple of questions. The reference to the staff field was a mistake, in that it is text vise var. Your comment about "not a good table design", what's so obviously wrong to warrant the comment ? As for the VB, why are we filling in a textbox with...

MySQL uses Foreign Keys to establish relationships between tables. Do you us any admin tools/interface like Navicat? Tom

A little background info, I am creating a Incident Log for an organization that deals with troubled child. This log is a continuation of work already in place that tracks numerous aspects of the childs treatment. All database tables are stored on Server2003, MySQL then linked to the Access...