Search results

Suggest you step through the code to check what actually happens is what you expect to happen Looks to me like you have an exit sub before clearing the controls

You don’t really need an end date - it will be null for the current name and one day less that the next start date for previous names and easily calculated if ever required. End dates are really only required for data that can end - such as a contract

Create an ‘alias’ table as a child to your main table. I have a similar situation where a club member has different member numbers depending on the activities they partake in. This comes from an online booking system over which I have no control

God decides it’s finally time to send Jesus back to Earth. *poof* All of a sudden, Jesus finds himself on the side of a road in the middle of rural America. He sticks out his thumb for a ride and before long a man in a truck stops to give him a lift. Not revealing his true identity, Jesus thanks...

You can step through the code to see if it is actually doing what it should be doing

So far as I can see the OP hasn’t said it’s a requirement, but if it is, you can pass the recordset to ado although you would lose the ability to sort/filter unless you write your own shortcut menus

You can do this with a form -see this link https://www.access-programmers.co.uk/forums/threads/making-a-form-look-like-a-report.326715/ Think it is the third example

Please use the code button - <> - to post your code, this will preserve indentations and make it readable

I think it is just the logo. Reminds me of (I think) Amazon which move one of its letters by a pixel

Another good myth ruined ☹️

It's probably at a different scale to your requirement but a number of years ago I wrote a commission/bonus system for a large company in Access - it paid around 2000 sales, support and line managers and was managed by two full time support staff. New senior management were concerned about the...

When I was a kid, there was a children’s program(me) called Captain Pugwash. I can’t remember all the characters names but the two I do recall were Seaman Staynes and Roger the cabin boy. Didn’t appreciate the double meaning until I was older and I guess the BBC wasn’t so hot on appropriate...

try physically swapping with a ‘good’ computer, if the problem persists it implies a computer problem, if it doesn’t, a network problem Also compare memory usage- perhaps the problem computer has a lot more apps open

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...