Recent content by CJ_London

The margherita pizza was named after an Italian queen and the colours of the ingredients represent the colours of the Italian flag There are more localised versions of Asian food - I believe the Chinese chow mein was invented in San Francisco, the Indian tikka masala in the uk for example

18 posts in and no helpful useful response from the OP to be to enable a possible solution to the extent we are now well off topic

Which? One word answers will not get you very far. Vague to say the least and does not answer the question If you are struggling with English, write your responses in your native language then use an online translation service to translate to English

A 96-year-old woman's note to her bank! Priceless! :geek: The following is an actual letter that was sent to a bank by a 96 year-old woman. The bank manager thought it amusing enough to have it published in the New York Times. ---------------------------- To whom it may concern, I am writing...

I don’t know - I’m asking you If you are saying it is open 24/7 what happens with windows updates which require a reboot of the computer and do you have a UPS for computer and printer

Before suggesting code - is the db opened every day of the year? Including Xmas day? Or is it open 24/7? And is the machine that hosts the FE on all the time and doesn’t go into sleep mode Reason for asking is you need a trigger to start the code which might when the db is opened, or a timer...

Many thanks for the responses. Further research - there are three 'methods' of connecting to Amazon, depending on your type of account - Marketplace (selling), Business (buying) and web services. I need Business and the link I provided was to do with Marketplace so has to be discounted as a...

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