Recent content by jeffj803

Problem solved, I had the controls on the form bound to the table. I removed the bindings and everything is working as expected.

Paul, Im running into a minor issue with the multi-select problem you helped me with previously. The problem I have is that when records are added, it always adds a record with a blank WST_ID field that was not selected as the first record and then adds records as expected. Here is the code...

That's exactly what it was Paul, here I was trying to create some fancy select statement. Thanks again for the excellent advice. Jeff

I was trying to stay within the confines of the example database you linked to so we are speaking the same language. What I am really dealing with is Flight Simulators that do relocate from time to time so I am primarily concerned with their location changing and that impacting previous...

Paul, That solution definitely does what I want it to do, now I have one more question. Suppose I want to select the last name from the tblEmployees as depicted but I want to write EmpID, EmpFName, EmpLName, DateOfBirth, and OtherInfo to the tblOtherTable? Yes this definitely defeats the...

I will download the sample db and look at the implementation and report back on how well it works. Thank you for the advice, Jeff

pbaldy, If I am understanding the link you sent me correctly you would use a ctrl or shift click to select applicable items? I cant download the sample database because of firewall restrictions at my office but will have a look at it when I get on a .com network...that is definitely a workable...

I've been scouring through the forums looking for a way of implementing a solution but have yet to find a good avenue of pursuit. Here is some background on what I am trying to accomplish, hopefully that will lead to a workable solution. Currently we track areas of non-conformance for a...

Re: Increment variable length alpha numeric field by 1 Got it figured out, here is what I did: QACPlength = Len([Combo116]) Pre = Left([Combo116], [QACPlength] - 4) Post = Right([Combo116], 4) + 1 Me.QACPctrl.Value = Pre & Post Got the length of the string using the length command Saved the...

Increment variable length alpha numeric field by 1 I have a database that is used for tracking changes to numerous courses. Part of this database create a unique tracking number for each course problem developed. Currently I have the form do a comparison using the highest most number to compare...