Search results

Do you have the Track name AutoCorrect facility enabled - that has been know to cause corruption during development. I never use it, some users swear by it's usefulness.

Not a problem. This will sound a bit odd, but can you screenshot the backend folder in explorer, it might give us some clues as to where and how it is stored. You can obscure anything that might give away any propriety data, but leave enough for us to see the file icons and as much of the path...

If it's cloud based I'm surprised it works at all to be honest. Access relies on the SMB protocol for file access/sharing, and this isn't normally supported in the cloud environment. If it's a cloud synced local folder then that again is going to be a problem. The cloud synchronisation is...

Good luck with filling a huge tray with water and not having it spill everywhere. Google, Amazon? https://www.amazon.co.uk/s?k=ice+cube+tray&crid=2TJJ3QFPGJ6BZ&sprefix=ice+cube+tray%2Caps%2C94&ref=nb_sb_noss_1

Nope. DoCmd.SendObject has no idea what email client you are using - it just uses the local machines default client. If I get any response from the OP for this reply I would like a chocolate biscuit.

That error isn't being generated in your error handling routine - the text is a generic error message. If it was we would see your msgbox. So we need more accurate information. I would turn off your error handler whilst debugging or return more information, like err.number, and err.description.

You can open the report with it's own filter/where clause: https://learn.microsoft.com/en-us/office/vba/api/Access.DoCmd.OpenReport

Is the network share subject to anti-virus scans? What is the connection speed like to the Network? Is the network share a trusted location? Oh and welcome to AWF!

It's too warm? ;)

I'm genuinely surprised there isn't a noticeable performance difference. Personally, I would still change it as If I need to revisit it in the future I would better understand what was going on.

I think that's a record. 21 year-old thread being replied to... Impressively late to the party ;)

Ah - but you could still use currency format or a fixed decimal format to store the the values assuming you don't need more than 4 decimal places. That would remove or curtail the rounding issues associated with the double and single formats. You can then format the display to remove the...

My wife is on Vodafone for her works phone, and has to switch off the mobile network when she's at home as it drops calls continually. Drives her mad, as she sometimes forgets to turn it back on when she goes out.

I've had it for years, it's almost a mandatory requirement in the house, as the Mobile signal is so flaky. It is carrier specific, as it needs a hook into their phone specific software. Vodafone's version of it was really annoying as if it got the tiniest hint of a mobile signal it would...

But you said in an earlier post they were set to double, that is not the same?

This is one instance where setting the table data type to Decimal fixed (or currency) would probably resolve the issue.

Yes - so you could undo that specific control and set focus to it and cancel.

You don't need to undo it, just cancel the before update and it won't save.

What have you tried and how is your data stored.

@BillDHess - If I did, I afraid can't remember what it was. I have subsequently installed a new hard drive and reinstalled everything, which obviously fixed any issues.