ACCESS FEED

Selasa, 10 Februari 2026

Re: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

Look at the column in datasheet view. If it is left-aligned, the values are being treated as text. If right-aligned, then numeric. You could try wrap your expression in a function that would convert the value to numeric like:

ConvertedValue: Val(IIf(Nz([txtNums],'')<>'' And IsNumeric([txtNums]),CLng([txtNums]),Null))

Duane

From: J. Stribling via groups.io <Jms4th=gmail.com@groups.io>
Sent: Monday, February 9, 2026 9:46 PM

It counts text as alphabetized text. When numbers are stored as text

Use a query against this table and *coerce* the text values to actual number like this:

ConvertedValue: IIf(Nz([txtNums],'')<>'' And IsNumeric([txtNums]),CLng([txtNums]),Null)

I hope this helps,

John Stribling

On Mon, Feb 9, 2026 at 1:52 PM Paul Baldy via groups.io <Pbaldy=gmail.com@groups.io> wrote:

What is the data type of the field? It sounds like it's text instead of a numeric type. You're getting an alphabetical sort.

Paul

Sent via mobile device

From: Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io>
Sent: Monday, February 9, 2026 10:43:17 AM

Happy New Year!

I trust all have been resigned to the OFFICE price hike...?

I have a database of books and their locations. 1 table merely numbers positions 1-343.

Everything counts/works as I was taught, in the last century [OUCH!] except... for example, 01 - 10... but after 10 comes 100. After 109 is 11. After 169 is 17. After 279 is 28. The "20s" are most screwed-up. I assumed it was a matter of "places" 028 but nope.

Obviously...

Thanks for all help & guidance. Crying towels available FREE.

Phil

Senin, 09 Februari 2026

Re: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

It counts text as alphabetized text. When numbers are stored as text

Use a query against this table and *coerce* the text values to actual number like this:

ConvertedValue: IIf(Nz([txtNums],'')<>'' And IsNumeric([txtNums]),CLng([txtNums]),Null)

I hope this helps,

John Stribling

On Mon, Feb 9, 2026 at 1:52 PM Paul Baldy via groups.io <Pbaldy=gmail.com@groups.io> wrote:

What is the data type of the field? It sounds like it's text instead of a numeric type. You're getting an alphabetical sort.

Paul

Sent via mobile device

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io>
Sent: Monday, February 9, 2026 10:43:17 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

Happy New Year!

I trust all have been resigned to the OFFICE price hike...?

I have a database of books and their locations. 1 table merely numbers positions 1-343.

Everything counts/works as I was taught, in the last century [OUCH!] except... for example, 01 - 10... but after 10 comes 100. After 109 is 11. After 169 is 17. After 279 is 28. The "20s" are most screwed-up. I assumed it was a matter of "places" 028 but nope.

Obviously...

Thanks for all help & guidance. Crying towels available FREE.

Phil

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

What is the data type of the field? It sounds like it's text instead of a numeric type. You're getting an alphabetical sort.

Paul

Sent via mobile device

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io>
Sent: Monday, February 9, 2026 10:43:17 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] HOW DOES ACCESS COUNT?

Happy New Year!

I trust all have been resigned to the OFFICE price hike...?

I have a database of books and their locations. 1 table merely numbers positions 1-343.

Everything counts/works as I was taught, in the last century [OUCH!] except... for example, 01 - 10... but after 10 comes 100. After 109 is 11. After 169 is 17. After 279 is 28. The "20s" are most screwed-up. I assumed it was a matter of "places" 028 but nope.

Obviously...

Thanks for all help & guidance. Crying towels available FREE.

Phil

[MSAccessProfessionals] HOW DOES ACCESS COUNT?

Happy New Year!

I trust all have been resigned to the OFFICE price hike...?

I have a database of books and their locations. 1 table merely numbers positions 1-343.

Obviously...

Thanks for all help & guidance. Crying towels available FREE.

Phil

Jumat, 06 Februari 2026

Re: [MSAccessProfessionals] forms not opening in Windows Home

Thank you. This is great information.

Dean J. Waring

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io>
Sent: Friday, February 6, 2026 1:43 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home

[Edited Message Follows]

ps, Peter's free API Viewer tool lets you look up APIs by Declares, Constants, and Types. He got the original list from Microsoft and has spent a lot of time expanding and correcting it, which he actively continues to do. It's a stand-alone tool you can launch and use to look stuff up. He named it win32apiviewer.accdb in the last download I got, which is enough for me! That has all the basics plus a lot more. If API calls aren't in there, they are probably obscure.

VBA7 was introduced with Access 2010. VBA7 declares etc will work in 32 or 64-bit.

When I have a 32-bit database (VBA6) that needs to be made to also run in 64-bit, if it will take a lot of hours, I ask for Peter's help. He spent a few years writing his tool to convert to VBA7 (which many refer to as 32 to 64) and is still expanding it. So with a database, he can convert it quick. When he gets a database with an API call he can't convert, it will usually be because there is no VBA7 equivalent – and often those calls aren't needed anyway. He's also fixed the errors in the original source he got from Microsoft. … and he's a super nice guy. He's in the UK and, in my opinion, the world expert on 32-64.

Kind regards,
crystal

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Friday, February 6, 2026 9:53 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home

Hi Dean,

Peter Cole has a tool to automatically make the conversions and if you have many of them or get confused, you should email him and ask for his help.

support@thememydatabase.co.uk

Peter also has a page with a couple free tools that you can download:

https://www.thememydatabase.co.uk/access32to64.html

When you click the blue Download button, you'll be taken to a Gumroad page to add item to shopping cart. It's free so don't worry about getting it that way.

I have his API Viewer pinned to my taskbar

Kind regards,
crystal

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom via groups.io
Sent: Friday, February 6, 2026 12:07 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home

Hi Dean,

Can you describe what you mean by "won't work"? Do you have 32-bit API calls? If so, these need a slight modification in the code. Collin has some great information at 32 to 64-bit Conversion.

Duane Hookom

From: Dean Waring via groups.io <deanjw2006=msn.com@groups.io>
Sent: Thursday, February 5, 2026 9:03 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] forms not opening in Windows Home

I have a multi-user Access database that our group has been using for over 10 years. The company is upgrading individual computers to the 64 bit version of Access. My 32 bit Access program won't work in this environment. Does anyone know if there is a way to make a 32 bit program run in a 64 bit environment, or if there is a way to convert the DB to 64 bit?

Dean J. Waring

Re: [MSAccessProfessionals] 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)

This is some of the previous thread contents related to this topic:

ps, Peter’s free API Viewer tool lets you look up APIs by Declares, Constants, and Types. He got the original list from Microsoft and spent a lot of time expanding and correcting it, which he actively continues to do. The API Viewer is a stand-alone tool (Access ACCDB database) you can use to look stuff up. He named it win32apiviewer.accdb in the last download I got, which is enough for me! That has all the basics plus a lot more. If API calls aren't in there, they are probably obscure.

VBA7 was introduced with Access 2010. VBA7 declares etc will work in 32 or 64-bit.

When I have a VBA6 project (32-bit database) that needs to be made to also run in VBA7 (32 and 64-bit), if it will take a lot of hours, I ask for Peter’s help. He spent a few years writing his tool to convert to VBA7 (which many refer to as 32 to 64) and is still expanding it. So if you send him your database, he can convert it quick. When he gets a database with an API call he can’t convert, it will usually be because there is no VBA7 equivalent – and often those calls aren’t needed anyway. If that’s not the case, he gets excited to find out why. He’s also fixed the errors in the original source information that he got from Microsoft (which is all many others who haven’t done the testing that he has have). … and he’s a super nice guy. He’s in the UK and, in my opinion, the world expert on 32-64.

Kind regards,
crystal

Hi Dean,

Peter Cole has a tool to automatically make the conversions and if you have many of them or get confused, you should email him and ask for his help.

support@thememydatabase.co.uk

Peter also has a page with a couple free tools that you can download:

https://www.thememydatabase.co.uk/access32to64.html

When you click the blue Download button, you’ll be taken to a Gumroad page to add item to shopping cart. It’s free so don’t worry about getting it that way.

I have his API Viewer pinned to my taskbar

Kind regards,
crystal

Hi Dean,

Can you describe what you mean by "won't work"? Do you have 32-bit API calls? If so, these need a slight modification in the code. Collin has some great information at 32 to 64-bit Conversion.

Duane Hookom

Dean J. Waring

~~~~

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Friday, February 6, 2026 12:56 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)

changed subject FROM forms not opening in Windows Home TO 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)

~~~

Dean, when you post a new message that isn't related to the thread, change the Subject. Best is to make a new message to the group.

~~~

Re: [MSAccessProfessionals] 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)

[Edited Message Follows]

changed subject FROM forms not opening in Windows Home TO 32-bit database (VBA6) that needs to be made to also run in 64-bit (VBA7)

~~~

Dean, when you post a new message that isn't related to the thread, change the Subject. Best is to make a new message to the group.

~~~

EDIT to show history of messages

[Edited Message Follows]

ps, Peter’s free API Viewer tool lets you look up APIs by Declares, Constants, and Types. He got the original list from Microsoft and has spent a lot of time expanding and correcting it, which he actively continues to do. It’s a stand-alone tool you can launch and use to look stuff up. He named it win32apiviewer.accdb in the last download I got, which is enough for me! That has all the basics plus a lot more. If API calls aren't in there, they are probably obscure.

VBA7 was introduced with Access 2010. VBA7 declares etc will work in 32 or 64-bit.

When I have a 32-bit database (VBA6) that needs to be made to also run in 64-bit, if it will take a lot of hours, I ask for Peter’s help. He spent a few years writing his tool to convert to VBA7 (which many refer to as 32 to 64) and is still expanding it. So with a database, he can convert it quick. When he gets a database with an API call he can’t convert, it will usually be because there is no VBA7 equivalent – and often those calls aren’t needed anyway. He’s also fixed the errors in the original source he got from Microsoft. … and he’s a super nice guy. He’s in the UK and, in my opinion, the world expert on 32-64.

Kind regards,
crystal

Hi Dean,

Peter Cole has a tool to automatically make the conversions and if you have many of them or get confused, you should email him and ask for his help.

support@thememydatabase.co.uk

Peter also has a page with a couple free tools that you can download:

https://www.thememydatabase.co.uk/access32to64.html

When you click the blue Download button, you’ll be taken to a Gumroad page to add item to shopping cart. It’s free so don’t worry about getting it that way.

I have his API Viewer pinned to my taskbar

Kind regards,
crystal

Hi Dean,

Can you describe what you mean by "won't work"? Do you have 32-bit API calls? If so, these need a slight modification in the code. Collin has some great information at 32 to 64-bit Conversion.

Duane Hookom

Dean J. Waring

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_