Search results

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?

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? ;)