Search results

@The_Doc_Man: I like your suggestion of using Format, but I am still puzzled by several aspects already introduced above: * Immediate window result * Round with literal value in query * Not limited to very small numbers.

I doubt that Mark. This is not a passthrough query. Also note that the Nz function does not throw errors, while it does not exist in T-SQL. The BE is SQL Server 2017. That's what the customer is using.

It is not directly related to the value I cited. Another record has a value of 0.675999999046326, and it is not being rounded either.

A365-32 semi-annual, v2408. Using classic SQL editor. Experiment 1: Select CSng(Nz([Ingredients].[MaxQty],[Ingredients].[Qty])) AS IngredientQty From … Experiment 2: Select Round(CSng(Nz([Ingredients].[MaxQty],[Ingredients].[Qty])),3) AS IngredientQty From … Both return the exact same value...

I don't know anything about authentication with Amazon, but I would be very surprised if this would not work: Tim Hall - https://github.com/VBA-tools/VBA-Web The code supports multiple authentication methods.

Looking at your code a bit more: I bet you were getting tired of flawlessly writing the 100 MouseDown events. There is a better way: control subclassing. The modified version is attached.

FYI: One of my replies is in the queue, awaiting moderation.

Nice. For your next version, make sure the code compiles.

"music files" is not specific enough. Each file format has its own capabilities. For example, this blog entry of mine is about WAV files, and shows how to interpret the file metadata. In the case of WAV, there is no loudness attribute.

I would do a double Split on this: first Split on the space, then Split the resulting items on the forward slash. Look up the Split function in Help.

Assuming you are in a network with a Domain, you will have Active Directory, and you can query that using LDAP. There is a starting point for your code in my blog article here.

A quick search on GitHub finds this promising lead: https://github.com/OlgaKuzminichna/excel_templates

Simil is here: https://accessmvp.com/TomVanStiphout/Simil.htm

I asked the maker of the file, and here it is, fully unlocked.

This is a 2-step process: first split the text in paragraphs, then loop over the paragraphs and do two finds. Step 1 can be done with the Split function, splitting on (most likely) vbCrLf, and Step 2 can be done with InStr.

> [Price (AUD)]+Nz(Sum([Amount]),0) AS [Est Cost] In the SumOfAmount expression you're using tblExpenses.Amount; you should do that here too. Being explicit about which table the Amount should be read from is a good idea. Same for [Price (AUD)], which in a previous expression you explicitly...

F11 opens the Navigation Pane (side panel). Yes you CAN access the File menu; I see it in the upper left corner of the app. What you need to tell or show us is exactly what happens when you click it. It is possible you're running this app on the Runtime version of Access. Can you create File >...

The reason for that is that your Fade code only works on objects (forms) with a Window Handle (hWnd). Subforms don't have that. They are painted on the form. Fading is not possible, unless you go to extremes.

You found an imperfection in NW. The control should have BackStyle=Normal, and BackColor=Background 1. I'll add it to the fix list for v2.5 (if ever).