Search results

Many thanks! This works perfectly!

Hi thanks for this. So I need to amend qryExport_Spec referenced in the module? I had a look in saved exports but couldn't find it. Apologies - I don't have much experience with this kind of export procedure.

Thanks for this, but I'm looking to export into multiple files rather than 1 csv. I'm wondering if the module in the attached database can be modified to include Field 2? Thanks

Hi. Currently they're exporting with V1, V2 in the contents (from Field1). I would like the contents to include Field1 and Field2. Thanks

Hi. Apologies if this is a basic question. I'm trying to export multiple txt files from a query. I found the attached module, which exports and names the files correctly, but I'm trying to get the contents of the text files to include Field1 and Field2. Field2 is a Long Text field. Is this...

Yes, that works great. Many thanks! And apologies for the errors.

Thanks. It's the Order field here in tblFamMem

Neither. It's by an additional field in tblFamMem, which applies a custom sorting to the list

I'm getting ORDER BY conflicts with DISTINCT

Sorry, do you know if it's possible to add ORDER BY to this?

Thanks! This works perfectly!

Hi. Thanks for this. However, it seems it will only list Christina (Associate), Christina (Neighbor), Christina (Partner), rather than nesting them as above. Or am I doing something wrong?

Hi. I'm trying to concatenate records from different fields in a query, and found this old database by Duane Hookom, which I've adapted slightly. However, I'm trying to get it to nest the concatenated results. e.g. in queNames I'm trying to get Christina (Associate, Neighbor, Partner), rather...

Hi. I'm trying to import multilple word documents (which i can convert to html or rtf), including basic formatting, into a rich text formatted long text field in access. Is there any way of doing this without individually opening each file and copying and pasting the text across? Thanks!