ACCESS FEED: Oktober 2026

Senin, 26 Oktober 2026

Re: [MSAccessProfessionals] Group information addition #file-notice

Hi Jan

Sorry to see you go. You can leave the group by going to our home page.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Group information addition

I have to unsubscribe

On Mon, Oct 26, 2026 at 10:48 AM Bill Mosca via groups.io <wrmosca=myself.com@groups.io> wrote:

Just a reminder to all members...Please read our Group Description on our Home Page There is some important information recently added there.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[Special] [MSAccessProfessionals] Group information addition

Just a reminder to all members...Please read our Group Description on our Home Page There is some important information recently added there.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Senin, 19 Oktober 2026

Re: [MSAccessProfessionals] SQL queries

See if this is what you're after:

http://allenbrowne.com/subquery-01.html#TopN

Paul

------ Original Message ------

From "Gary via groups.io" <glcshadow=hotmail.com@groups.io>

To MSAccessProfessionals@groups.io

Date 10/19/2026 2:38:53 PM

Subject [MSAccessProfessionals] SQL queries

Just curious if in SQL there was an easy way to pull up the latest data from a database for different locations. I have a database that contains inspection results for many different locations. I wanted to pull up the latest inspection for each site and make a report on it. I thought the "TOP" command might work, and it does for just one site. I would think that SQL would be able to handle that easily, but I have not been able to find anything in SQL that will do it. Just was wondering if I have missed something in SQL. I was able to do what I wanted in VBA. Thanks -- Gary

Re: [MSAccessProfessionals] SQL queries

Gary, my favorite source for queries is SQL For Smarties. It's available in PDF at

--https://cdn.bookey.app/files/pdf/book/en/joe-celko's-sql-for-smarties.pdf

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] SQL queries

Just curious if in SQL there was an easy way to pull up the latest data from a database for different locations. I have a database that contains inspection results for many different locations. I wanted to pull up the latest inspection for each site and make a report on it. I thought the "TOP" command might work, and it does for just one site. I would think that SQL would be able to handle that easily, but I have not been able to find anything in SQL that will do it. Just was wondering if I have missed something in SQL. I was able to do what I wanted in VBA. Thanks -- Gary

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] File Section Archive

Many thanks to the organisers & the many contributors for their input & wisdom. This site has got me out of many holes & I'll be really sorry to see it go.

Best regards

Jane

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Minggu, 18 Oktober 2026

Re: [MSAccessProfessionals] File Section Archive

Thanks so much, these are awesome, Crystal is amazing!

Get Outlook for Android

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Mosca via groups.io <wrmosca=myself.com@groups.io>
Sent: Saturday, 17 October 2026 13:29:55
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [Special] [MSAccessProfessionals] File Section Archive

Thanks to the hard work by one of our owners, Crystal, the Files section of our group has been archived at her website

https://msaccessgurus.com/MSAccessProfessionals

Please use that link to peruse/download the files we have gathered over the years. Many thanks to all members who have taken the time to post all the useful material found there.

That site is rich with information about MS Access.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Sabtu, 17 Oktober 2026

Re: [MSAccessProfessionals] File Section Archive

thanks, Bill ! and for your many years of hosting this forum to share Access knowledge.

Please, all of you, check the archive downloads to ensure they can be gotten and used okay.

If there are issues, let us know right away!

kind regards,
crystal

On 10/17/2026 12:29 PM, Bill Mosca via groups.io wrote:

Thanks to the hard work by one of our owners, Crystal, the Files section of our group has been archived at her website

https://msaccessgurus.com/MSAccessProfessionals

Please use that link to peruse/download the files we have gathered over the years. Many thanks to all members who have taken the time to post all the useful material found there.

That site is rich with information about MS Access.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

[MSAccessProfessionals] File Section Archive

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[Special] [MSAccessProfessionals] File Section Archive

Thanks to the hard work by one of our owners, Crystal, the Files section of our group has been archived at her website

https://msaccessgurus.com/MSAccessProfessionals

Please use that link to peruse/download the files we have gathered over the years. Many thanks to all members who have taken the time to post all the useful material found there.

That site is rich with information about MS Access.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Kamis, 15 Oktober 2026

Re: [MSAccessProfessionals] AI integration

Hi Jane,

I am working on just such a project.

Our prompt is more specific: from the uploaded several page PDF document extract the dimensions for the areas in this house floor plan, and return them using the attached sample Json output, along with a confidence level for each area (some are clearly dimensioned; others are not).

The API key is stored in a SQL Server encrypted column, and the ODBC connection to the database is encrypted as well.

This prompt, along with the API key, is sent to the AI, and it sends Json back which we then interpret and show to the user for accept/reject.

The code and form is in the existing app; it all happens with API calls (XMLHTTP library) to the AI’s endpoint.

Best Regards,

-Tom.

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jane via groups.io
Sent: Thursday, October 15, 2026 11:43 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] AI integration

Just wondered if anyone has tried integrating AI output into a database?

One of my clients have a database. They have been manually feeding pdf technical drawings into ChatGPT & it has been outputting all the text on it into a word document, which they then edit to use. They are asking the question if I could somehow automate the process, so it just picks out certain information, which they then check before it's saved to a record.

I must admit it wasn't something I'd even thought to try, but it's nice to try something new!

Thanks

Jane

[MSAccessProfessionals] AI integration

Just wondered if anyone has tried integrating AI output into a database?

I must admit it wasn't something I'd even thought to try, but it's nice to try something new!

Thanks

Jane

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_