Search results

I would guess the OP is using ADO recordsets. Would have been helpful to know that

would think you would want .Filter = "[Collector] like '*" & sFilter & "*'"

I’ve pointed this out before, please don’t imply your views/knowledge are representative of the uk population

Because access usually trims any spaces at the end of the entry you probably are ending up with a zls. Easy enough to check using the Len function Depends on your code but try using chr(32)

looks to me like the issue is qry1 - it is based on transactions as the 'primary' table to return - no transactions, no records. Not completely clear to me why you need this structure - perhaps change the join between account and transaction around

I would also suggest you do not need year in the combined table since that is a value in your collar table

No idea without knowing your tables and relationships and the form and code you are using for this particular process Best guess would be to create a dummy record which can subsequently be deleted Something like If dcount(*, sometable, accountid=something) =0 then create a record

Assuming it is split (you haven't said) 1. open the FE - hold down the shift key if necessary to stop code from running) 2. if you can see the linked tables then 3. open the msysObjects table (or use a query - SELECT * FROM msysObjects) 4. look in the database column - you should find the...

that's a start, tables - no data yes you can have multiple tables in one query, but at the moment I am unable to determine what you want the query to return to say that in this case it can be done (other than by using a union query) - mock something up in Excel. I presume this is for a report...

Is this a split application? If so you should be able to recover it from the FE

depends on where you are going to use it but I would create for each company a format string to indicate where each part can be found. e.g. XXXYYYYY XXYYYYYYYY YYYXXXXX Providing the first part does not vary in length by insurance company then this function would work. - You'll need to finish...

Provide some example data to illustrate the issue

Suggest try the suggestion in post #2 And as advised in post#2 - you need to use the text property, not the value property

Oh yeah 😁

@Mark_ wrong thread?

With formatting

It probably isn’t possible but thought it was worth floating the question. The sql would still need to be created in vba The reason for wanting to use sql is (for emails in a folder at any rate) significantly faster than the outlook object method

I know how to query outlook using sql to return emails in an outlook folder. One of the fields returned is a boolean to indicate whether the email has attachments. I also know how to get the attachment names (and the files if required) via the outlook object, but wondered if there is a sql way...

how would you do that in Access? and I guess without using vba :)

since it is the only way you can do it and you don’t want to use vba, I guess you are going to be very disappointed Only other ways are to create a linked table to the txt file and change the source manually (without using vba) then run your query Or there’s the transfertext method- but...