Search results

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.

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.

Presumably you know the log in ID of whoever is logged in? You need to use that as criteria for that update statement, otherwise it will simply update everyone (as you have discovered). I suspect you also want to record that same ID in your login sessions table so you know who has logged in...

You'll probably need to create two recordsets, one of the Parent data and one of the child data, and loop around the Parent data, and then pull in the matching child data. If you genuinely only have one child record per Parent record then it may be easier in a single recordset.

Welcome to AWF !

After you have tested it... I suspect you won't get anywhere if your network has any sensible security settings. The only way this might work is if you installed a secure VPN and log into it from the other networks.

I would disagree depending on how you are actually storing the ancillary order information. If you are creating multiple line item invoices, I personally wouldn't want to store the PO, Contact Details, Order delivery instructions et al. on every line? That seems very wasteful on storage (which...