Search results

This is the query I did: I'd be really grateful for help...

To post a screenshot I need 10 posts, that's why I split my text, sorry for that. In effect, such a query, if working, would fuse my duplicate records (hence the title) after I delete the empty ones (another query is ready for that)

I tried several functions, First, DFirst, DLookup, but I'm having difficulties to specify the criteria part of my DLookUp function (indicated by ??? in the screenshot), mostly my tries lead to type conversion failures.

I began by designing a Find duplicates query with the wizard, which returned records with same [ES Detail] and [ES category] in table ES_Detail. I then added [ES ID] from table ES and converted it into an update query. [ES ID] in the ES table has to be updated to the corresponding [ES ID]...

Hello, I'm having some trouble with the following: I need to update a field to the value of the same field in another linked table in duplicate records.

Thanks a lot, that really helped, and I get the logic now.

Hi guys, I'm sorry I could not find the solution to my problem on this forum, though I searched, so I post here. But it should be pretty obvious, because what I'm trying to do sounds basic... I have a table, named "ES_Detail", in which I want to update its field [Date created] (if empty) with...

No, just a Name. In the end, I found the solution to be [Name]=[Screen].[ActiveControl] simply.

Thank you for your information. I had only 1 parent field to link with one child field, so this is free of errors. However, in the meantime, I just remade all the forms and subforms (and I can tell you the result is the same) and the error messages don't appear anymore. I've had this a number...

I have a form, containing 3 tab controls, 2 have a subform, which is itself containing a subform. I had it perfectly working, but since I inserted the subforms in tab controls, I get the error message 2335 4 times (4 subforms in all) every time the form is opened: I definitely have the same...

Good morning, I have a students table with its report and its form. In the report, I created a macro called on double-clicking the student's name control. The aim is to open the form corresponding to the clicked student. I have a simple OpenForm command which works fine, and this is the code in...