Search results

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

@DickyP I'd like to see the figures on gun crime in the UK you are basing that sweeping statement on. Daily Mail? The attached would seem to completely disagree. 9000 offences across all categories last year, as opposed to 24000 20 years ago. More interesting stats here...

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.

There is no "middle" of a table in Access. The data tables have no intrinsic sort order they are just displayed in whichever order Access decides to show you. A table is a unsorted bucket of data. In Access you should use a form to display and edit data and you can use the control wizards to...

We have done this for a very large set of applications for a client, migrated it to Azure SQL and re-written the front end to use a modern version and look of Access. It was not a quick process, although no individual part of it was difficult, just quite laborious and required a lot of testing...

I don't think it's available. If you use MZ tools to insert a generic error handler it puts the name of the sub in, but I don't know where it gets it from?

We don't do Thanksgiving this side of the pond, but I have plenty of friends Stateside, so Happy Thanksgiving to all our American members.

Just to expand on Gasman's answer from the above; i = 1 as a date = 31/Dec/1899 i = 2 as a date = 01/Jan/1900 i = 3 as a date = 02/Jan/1900 See why it doesn't work? And why this does:

This is exactly the same question as this thread: https://www.access-programmers.co.uk/forums/threads/how-to-get-access-to-open-outlook-in-html-instead-of-plain-text.332822/ Which seems a weird coincidence?

Your string shouldn't have any quotes around it, they are included by default in the variable. It should be Num = 4. So your DLookup should be DLookup("Mth","tblMonths","Num = 4") The double quotes will cause a issue. You can type that expression directly into the Immediate window to prove a...

It allows you to write a formatted SQL query directly, with autocomplete, and insert comments (at the beginning). If you are used to doing this (e.g. with SSMS for SQL server) it is much preferred than using the query by example grid, or the unformatted normal SQL query Editor.