Search results

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

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.