Search results

Open Access on a end user machine. Goto file¬Options There is a a section called Trust Center. Click on the Trust Center Settings... option Within that is Trusted Locations: Make sure you tick the Allow trusted locations on my network box, and add the path of the BE file.

Is the backend file in a trusted location for all the clients? I've seen that cause poor performance. Are you on a gigabit network? 100Mb will be surprisingly slower.

As CJ pointed out, You can store the backend in Azure SQL which is Microsoft's cloud SQL Server database. If it's small system and well designed, it will probably transfer relatively painlessly.

A database file 1.6Gb in size will start to behave badly once you start running queries on the largest tables, as it will be attempting to create temporary objects during that query process that will make it approach the 2Gb file size limit. You used a group by in your delete query, that won't...

I think the challenge is the use of the words curable and disease. It's all perspective and subjective. I also think you are conflating the ability and necessity to reproduce, against someone's (somethings) innate behaviour. One does not exclude the other, and never has done. Remember that...

Crossposted here: https://www.accessforums.net/showthread.php?t=90577

You appear to be describing Homosexuality as a curable disease, which by all measures I have been made aware if it is not. That leads to a very dark place. Edit: The doc man beat me to it.

From all the reading I have ever encountered, Homosexuality has been around for longer than the current version of Homo-sapiens. I also understand it's not restricted just to Humans, but is more obvious with our species especially when "on display". I would counter that it's not an abnormal...

The latest version of the snipping tool has boxes and circles: I can't take a screen shot of the controls 'cause catch 22.... :)

Nope, and the coffee has gone cold now!

Close - Skrol https://www.skrol29.com/us/vtools.php

I would say this will almost certainly cause issues, as it will be trying to sync the local access file to the cloud. Move the FE to a dedicated C:\ folder that isn't covered with the company policy of helpfully keeping everything copied to the cloud. I know I have had to do this in a couple...

This is the second or third time you have asked this: https://www.access-programmers.co.uk/forums/threads/darshan-hiranandani-how-to-open-outlook-in-html-format-instead-of-plain-text-via-vba-in-access.332869/#post-1944205 This thread answers you question...

Welcome to AWF. Definitely read up on normalisation. You probably need a different type of set up to what you are describing, and to think through what you are actually trying to keep track of. Just as an example - If you have a fixed set of Kegs and just need to track their locations you...

Have you tried =DSum("BasicPay + PensionPay + OtherP1 + Other P2","tblPayslip","[payslipDate]>=Forms!FrmPayslip![FYFrom] And [payslipDate]<= Forms!FrmPayslip!PayslipDate") I haven't but it would only take 2 minutes. If you have any null values it probably won't work.

Good question, and probably beyond my Excel expertise I'm afraid. It would be simple in Access as you could join the new data to the look up data and query it with a not equal join, and simply refresh after each entry. I do vaguely remember working something out like this in Excel before, and...

@MajP I would agree with you but surely I would get the type mismatch error when it returned a number? Apparently not - Access is happy to automatically convert "48" to 48 I am utterly convinced I have used this type of construct dozens of time before and not had this error raised until...

Did you pick the Sales item from the drop down then press the button? It works fine when there is any value in the table.

I'll try and describe this as simply as possible. Take a multi-column combo box where one of the columns is a Decimal/Number field sourced directly from a table. The data type is a number type - Currency / Integer makes no odds, but it does allow nulls. In VBA you assign that value to a...

In Excel : I'm not sure you can other than by making your lookup list dynamic to not include any existing entries?