Recent content by IvanM

Hi, thanks for the prompt reply. My original solution was to import to a temp table in Access and then run an append query, but it's unbelievably slow, as in hours to append from the Access temp table to the Azure SQL table, there's around 300,000 records in the file I'm testing. That was...

Hi all, After a lot of searching, testing and hitting way too many brick walls, I thought I'd see if anyone is able to help - Originally the below was an Access 2016 Front End and and Access 2016 Data Back End setup. Current Setup Access 2016 DB Front End (main tables linked to Azure SQL...

Hi Colin, yes, you're right, the video shows a method of creating the kind of drop-down multi-select I want to create, however, that relies on a destination table that has a lookup with multi-value drop down field though and my source is from a query... I'll take another look however and see if...

Correct Frothing, screen real-estate is an issue too... Ridders, apologies for the confusion, I AM using the union query as the source. The table comment was because as far as I've seen that's the way to create a field which when dropped onto a form will give the drop-down multivalue select...

Hi, thanks for that, I apologise for neglecting to mention that this control would be unbound and uses a union query to populate, so isn't based on a table field that I can set as multivalue. It's being used to filter records on the form...

Hi, I would like to add a multi-select drop-down to a form that would basically allow me to select the drop-down revealing a populated list (this part isn't the problem) and select checkboxes next to the items in the list that are relevant to me. Basically I'm after something like the Access...

Thanks Minty, that reply was pretty much instant! I had genuinely thought about doing it that way, but it always irritates me to use 2 queries when only 1 is needed and hoped there might be a better solution... Thanks again!

I have a table with data which looks like this - <<Hist_Date>> <Area> <Jobs> 11/10/16 15:53.... AA....... 12 11/10/16 15:53.... AB....... 15 11/10/16 15:53.... AC....... 20 12/10/16 11:22.... AA....... 10 12/10/16 11:22.... AB....... 12 12/10/16 11:22.... AC....... 14 12/10/16 14:32...

Hi Minty, I'm replacing the spreadsheet with the DB. The data is currently copied and pasted into the spreadsheet from another system. It's not just about the data itself, there are 2 separate snapshot images that are pasted into the email (and it needs to continue this way). There's also...

1. How is the excel image generated ? A. Simply copied (the relevant area is selected) from the spreadsheet and pasted into the body of the email. 2. I'm guessing it would be stored differently on each users PC. You will have to code it to check that the images are stored and named in...

Hi Minty, the email currently contains 2 images copied from an excel sheet (and no, not exported from my DB), I'm building the DB to automate this and many other things, so the email I'll be creating will be from the 2 subforms. The easiest route would have been a PDF attachment but I've been...

Thanks Ranman and Minty. Yes Minty, that is what I want to achieve. Currently the email has text top and bottom and 2 excel tables pasted in as images so that recipients can't alter them and some are able to copy and paste from the email for other reports... I've sorted the TO...

Hi, I would like to be able to send an email using the SendObject method from a form that has 2 sub-forms. Ideally, I want to be able to copy the 2 subforms and embed them in the message body as, say, an image, with text before and after the inserted images. Also, what would be the...

Hi MarkK, you've hit the nail on the head here. This is basically what I was trying to achieve, plus as you say, I was sure it would be possible in some way. After moving Frothingslosh's solution into the OnLoad event, I discovered it won't work there, then read the comment about this after...

Hi Frothingslosh, that works when I do exactly what you've done, so excellent! Nice one!! I knew there had to be a way of retrieving the parent control name somehow. Genuinely appreciate this, I spent a couple of hours on this yesterday searching and testing. :)