Search results

I posted on Wednesday but apparently it did not save my post - or at least I can't find it. I thought I had this working but realized the form was staying on the current record so if I changed the employee name it simply replaced the info for that record. I need this to go to a new record but...

Every control on the form is bound and at this point I have to leave it that way. Undo doesn't work.

I get an error message stating I can't assign a value to this object.

Yes daefault values is working per Gasman's instructions (thank you - I am poking at it and am getting close to what I need.) But as I said I can't get the Employee Name combo box to clear to show no name. Can some one tell me what I would use to do this? DefaultValue = "" is not working nor...

It appears that I did understand and have been able to make this work!!!! YAY but now I need to clear the Employee Name (a combo box) but when I tried DefaultValue = 0 for that it did not clear the field. Any thoughts on how to clear this one field?

Again thank you - I think I am able to make Gasman's suggestion work so don't put any extra time in on this at this point

I looked at your database - thank you. Not sure I understand. But using your comments I was trying to set up an append query to append the record to the table instead of adding a new record using the Do.Cmd control (which clears the form) Instead of opening a separate form, I was trying to...

Trying to understand this as it does look like the easiest way to go. I looked at the allenbrowne site but can't see this. (not sure what to lookfor there is a lot there!) Do I understand it correctly that the line Me![Date_ID].DefaultValue = """" & Me![Date_ID].Value & """"...

I don't think default value sounds correct unless it can be set in code and then cleared when the user clicks another button that will move to a new cleared record. I am not clear about the 2nd description - I am thinking the OldValue from above might be the solution but will try to figure it...

This sounds like what I need to do - I will look over the link this evening and check it out. Thanks

I have a form that has the following controls: SOPNumber EmployeeName DateCompleted TimeCompleted The form is bound to a table. When a record is saved to a table normally the form is cleared. If the training session was completed by more than one employee it would be best to return to the...

Super big thanks to everyone Especially gasman for the explanation of how to set up strings with the correct notation (not sure of the correct wording) After what I call "poking it with a stick" I was able to find the correct sql stateiment. And also to theDBguy for our email exchanges...

to theDBguy - I just sent you an email Please reply that if you did not get it - or let me know it did not come through to you. THANKS!

I am back to my original issues of data mismatch and I know it is because I have the strWhere statement incorrect but I don't know how to correct it. I am away until Monday and will be back at this again then. Have a great weekend everyone

Yes possibly on Monday? I am away til then.

Figures I would need to do something "unheard" of - thanks anyway - anyone else got any idea

This is the select query SELECT [Forms]![Add by SOP FRM]![ComboSOPNo] AS SOPNumber, [Forms]![Add by SOP FRM]![SOPVersion] AS SOPVersion, [Forms]![Add by SOP FRM]![ComboEmpName] AS EmployeeNumber, [Forms]![Add by SOP FRM]![DateCompleted] AS DateCompleted, [Forms]![Add by SOP FRM]![TimeCompleted]...

The only thing I can see that is different for these 2 fields is that the information is not saved in the database. The other fields are based on existing information in the tables. The 2 fields I am trying to access are only entered information that is not saved elsewhere. (hope that makes...

I am creating an append query based on a form. I have all of the info entered correctly but for some reason 2 of the fields will not show any value in the query results. The fields are a date field and a number field. Please I want to keep this as simple as possible without getting into a...

I have looked at this and what you have here is to the best of my understanding exactly what my set up is, I do have 3 tables as you described. My equivalent of your Employees_TrainingCourses though only keeps the most current training within. I think that is what has to change I need to...