Search results

I can think of the set of actors that might change for each season.

> Older versions of Access closed the form when you press End. Not necessarily. That may depend on which event the error occurred in (the cancellable Form_Open perhaps?), if there is an error handler in place (your code apparently did not have one), and possibly other factors like if the form...

This is a screenshot from the Northwind 2 Dev Edition, Product form. I don't see the issue you're raising, but because of the tight cropping there is not much difference between a right aligned and a center aligned tab. Post your screenshot, please.

I foresee problems. User1 opens the shared FE and relinks the tables with ODBC13. User2 opens it and relinks with ODBC18. What will happen to User1? Bite the bullet, and give every user their own FE, per best practices. If you look around, there are several tools / scripts available to keep the...

No, it is an RGB value, long integer. There are a few defined constants like vbYellow, but otherwise you need to cobble a color together yourself. There is a color selector for the color properties.

Yes you can, in a Standard Module you can write: Public g_db as dao.database 'g_ prefix for global objects and then set it in your startup code. I do this in my code. For recordsets it can be more tricky because you may sometimes want to keep them open for more than the current procedure, but...

Are you saying ACCDR does not require Trusted Location?

We know nothing about your company (a common line of business, or a unique one?), your hierarchy (e.g. where are you placed in the org chart, and where is the asker?), your equipment (is it connected to your app), the strengths and weaknesses of your app. So giving advice is perilous. In your...

In Access we don't have Float data type, but Double is the equivalent. The VBA.Round function takes any "Numeric expression", per this documentation. That means my "real" data type is supported.

@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.