Sabtu, 28 Agustus 2021

[MSAccessProfessionals] online Access user group meeting

hello,

You and all your friends are invited to a free online user group meeting about Microsoft Access databases.

The focus will be on Queries and VBA. It's for beginning developers, but it's not going to be basic. If you know a lot, I doubt you'll be bored. There will be side conversations going on in the chat, questions to answer, and other experts will be connected too.

Although it's Part 3 in a series I'm co-presenting with Maria Barnes, with essential information for beginning Access developers, it's okay if you missed the first 2 sessions (they're on YouTube if you want to watch them).

Here is the meeting link. At the bottom, click on "Join Webex Meeting".
https://accessusergroups.org/lunch/event/access-lunchtime-3-2021-08-31/

DATE: Tuesday 31 Aug

TIME: 12 noon Chicago (central) (-5)

other times:
  10 am Seattle (-7)
  11 am Denver (-6)
  1 pm New York (-4)
  6 pm London (+1)
  7 pm Oslo (+2)
  7 pm Frankfurt (+2)
  8 pm Moscow (+3)
  1 am Beijing (+8)
  2 am Tokyo (+9)
  3 am Sydney (+10)

Hope to see you!

kind regards,
crystal

Re: [MSAccessProfessionals] Create a Data Dictionary for your Access database

thank you, Bill! It's my pleasure to share what I write with other
developers, and to be comfortable posting a link  in this forum

kind regards,
crystal

On 8/26/2021 2:24 PM, Bill Mosca wrote:
> Thanks, Crystal! This is such a useful tool, especially when inheriting a database that needs a lot of work to make usable. It's nice to have every detail in an easy-to-read spreadsheet.
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> MS Access MVP 2006-2016
> My Nothing-to-do-with-Access blog
> https://wrmosca.wordpress.com
>
> -----Original Message-----
> From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
> Sent: Wednesday, August 25, 2021 8:16 PM
> To: MSAccessProfessionals@groups.io
> Subject: [MSAccessProfessionals] Create a Data Dictionary for your Access database
>
> hi everyone,
>
> Create a Data Dictionary for your Access database, and write the results to Excel
>
> video:
> Document Access Tables to Excel (10:16)
> https://youtu.be/r6LRurruI44
>
> code:
> VBA > Document > Tables to Excel
> http://msaccessgurus.com/VBA/Code/Document_Tables2Excel.htm
>
> Creates an Excel workbook with the documentation. The first sheet, ListOfTables, gives you the Table name, number of records, number of fields, and also an estimated record width for the standard data types.
>
> The DataDictionary sheet lists Table name, Field number, Field name, Data Type, Size (byte), Description, Format, Caption, Default Value, Expression, Input Mask, Validation Rule, Validation Text, Required, Unicode Compression, and Estimated Width.
>
> kind regards,
> crystal
>
> Remote Training and Programming
> connect to me - let me help your project be a great success
>
>
>
>
>
>
>
>
>
>
>
>


-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116038): https://groups.io/g/MSAccessProfessionals/message/116038
Mute This Topic: https://groups.io/mt/85153347/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-

Kamis, 26 Agustus 2021

Re: [MSAccessProfessionals] Create a Data Dictionary for your Access database

Thanks, Crystal! This is such a useful tool, especially when inheriting a database that needs a lot of work to make usable. It's nice to have every detail in an easy-to-read spreadsheet.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog
https://wrmosca.wordpress.com

-----Original Message-----
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Wednesday, August 25, 2021 8:16 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Create a Data Dictionary for your Access database

hi everyone,

Create a Data Dictionary for your Access database, and write the results to Excel

video:
Document Access Tables to Excel (10:16)
https://youtu.be/r6LRurruI44

code:
VBA > Document > Tables to Excel
http://msaccessgurus.com/VBA/Code/Document_Tables2Excel.htm

Creates an Excel workbook with the documentation. The first sheet, ListOfTables, gives you the Table name, number of records, number of fields, and also an estimated record width for the standard data types.

The DataDictionary sheet lists Table name, Field number, Field name, Data Type, Size (byte), Description, Format, Caption, Default Value, Expression, Input Mask, Validation Rule, Validation Text, Required, Unicode Compression, and Estimated Width.

kind regards,
crystal

Remote Training and Programming
connect to me - let me help your project be a great success









-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116037): https://groups.io/g/MSAccessProfessionals/message/116037
Mute This Topic: https://groups.io/mt/85153347/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-

Rabu, 25 Agustus 2021

[MSAccessProfessionals] Create a Data Dictionary for your Access database

hi everyone,

Create a Data Dictionary for your Access database, and write the results
to Excel

video:
Document Access Tables to Excel (10:16)
https://youtu.be/r6LRurruI44

code:
VBA > Document > Tables to Excel
http://msaccessgurus.com/VBA/Code/Document_Tables2Excel.htm

Creates an Excel workbook with the documentation. The first sheet,
ListOfTables, gives you the Table name, number of records, number of
fields, and also an estimated record width for the standard data types.

The DataDictionary sheet lists Table name, Field number, Field name,
Data Type, Size (byte), Description, Format, Caption, Default Value,
Expression, Input Mask, Validation Rule, Validation Text, Required,
Unicode Compression, and Estimated Width.

kind regards,
crystal

Remote Training and Programming
connect to me - let me help your project be a great success



-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116036): https://groups.io/g/MSAccessProfessionals/message/116036
Mute This Topic: https://groups.io/mt/85153347/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-