Search results

You got all the code - look yourself

no you cannot, But for this type of selectrion oe mechanism is to have 2 listboxes: one showing what is available and one showing what is selected. Each time you click in the available-listbox, the item is removed from there and added to the "selected listbox", and vice versa. Google access...

Datasheet view makes it all quite simple:

Using subforms just to select records is massive overkill and it also makes Access complain about mutiple access paths to the same table, as you've experienced. Use listboxes.

If you are using datasheet view, you can right-click on a column header and select Hide Fields or Unhide Fields.

Idiocy requires the occasional kick in the teeth. Otherwise the idiots occupy space and roam entirely scott-free.

" Having trouble" is BS. Say what you want and show what you did, in code. And where.

You really are just a contrarian twat

oMail.Subject = "Missing documents for the client: " & Me.client_name & (", ID code: " + Me.ID_code)

So you are not sure? Does it or does it not then? what the heck does this mean? Honestly, you can do much better. Read my signature. When asking for help be specific, and do not assume that we read minds. You have a problem, obviously. To define it so others can understand it you need to...

Not stories but code: show how you requery

Besides, use Now() to get the time, - insert debug.print now() here and there, and see where the largest time difference is.

You still haven't shown everything: what is qryEmailRecipients

Keeping with the spirit of the site (something sound) and this forum (something not pertaining to Access), lets take Mens Sana in Corpore Sano to a new level, especially the last bit. I've discovered intermittent fasting. Have been following it in the 16/8 version (fast 16 hours, feed 8 hours)...

You should work on you googling skills. Googling is often as worthwhile as coding. This error is one of the most common with plenty of cases and advice out there. Use AWF for stuff you cannot google yourself. You search for Access error XXXX and see what comes up. Do that next time. AN example...

A textbox in a report has a property to set it to running sum

You have not added any new information, so I point at #6 again.

Errr so what? Did you read #6? Each shipment line does not belong to multiple order lines. It's like parent and children - one parent many children. You don't have a many-to-many for that.

No its normally not slow. You have not shown the entire code so not possible to say what brakes there might have been built. Show all related code and queries, not just snippets.

Junction table? What for? One shipment line cannot belong to multiple orders, can it? If not then logging each order line with all related shipment lines is enough.