Search results

Does anyone know if it is possible to download purchase invoices from Amazon to be stored in a windows folder? I found this link https://developer-docs.amazon.com/sp-api/reference/getinvoicesdocument so looks like it is possible - a two stage process to get the document ID's (for a given...

Use a filter on the company table in the query you use to populate the form Edit - to create the field, you go into table design

re quickbooks, a simple google found this link https://docs.devart.com/odbc/quickbooks/access.htm no idea if it will work, you would have to try it

You can use Citrix or terminal server for any device that supports terminal server - windows, iOS and Linux that I know of. I’ve used my iPhone in the past. Comes with a cost but useable from anywhere which has WiFi. But then anything requiring that level of connectivity comes with a cost

In a normalised structure you could have a default field or a sort order field in the company table

As you can see from my examples from the immediate window, it provides the required results. If you are getting 0 then something is different However you have a working solution so little point in you trying to adopt a different one

was done freehand on my phone - so don't know what you actually tried - but was missing an end bracket which would have generated an error message. Also because on the phone, there were smart quotes which need to be changed to regular quotes. Once those corrections are in place, 3 won't without...

You could always use a union query to normalise the data - but every time you add a new company, you’ll need to modify the query, as you would using a function Better to normalise from the get go as already suggested

Since these are all numbers, you can use the val function Val(transfer) returns 349 Val(mid(transfer, instr(transfer,”/“)+1) returns 2016 Val(mid(transfer, instr(transfer,” “)+1) returns 79 Val(mid(transfer, instrrev(transfer,”/“)+1) returns 2019

nobody appears to be mentioning chr(11) which is a horizontal tab before the space (chr(32)- that also needs to be removed Are you really using copy/paste to populate your table?

To be clear you have a single text field per row with values separated by a single space? Your example data seems too simplistic. What identifies the pair? Customer? Order? Item? A combination of 2 or more? Can you only have one row?

What happens if a file is deleted? why not use a datetime value suffix? Myfile_250615_112435

You can still use a dlookup - just modify the where parameter along the lines of my example - having first added and populated your min/max char fields. You mentioned 3 chars but your example was for two

If you are currently basing on the first character what is stopping you basing on the first two characters? If this is an exception just for those companies start with A that would be AA-AM then AN-AZ. Companies starting with B would be BA-BZ, etc You would need a range comparison e.g. Where...

Don’t think you need quotes around the 2nd parameter

This thread is about printers - suspect you are responding to a different thread

Agreed - but my point is we don’t know how the OP has determined these values, so they could have introduced a null value Either way, it appears the problem has been resolved

The ‘Boolean’ value in the query may produce a null - all depends how it is determined. For example Istrue: iif(a=b, true) Will return a null if false

Are all your update queries mutually exclusive? I.e. a specific record can only appear in one update and cannot be updated by a later update? And have you opened the query to verify all your calculated booleans are populated and correct- logic being if the sql is valid then the issue will be...

Perhaps rs1.FindFirst "family like '" & Left(str, nLen) & "*'"