[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]
-=-=-=-=-=-=-=-=-=-=-=-

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]
-=-=-=-=-=-=-=-=-=-=-=-

[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]
-=-=-=-=-=-=-=-=-=-=-=-

Re: [MSAccessProfessionals] Access 2007 issue

Thank you for all the suggestions.  I did the  check references steps and came up with "MISSING utility.mda".  Well that was interesting. Now what?

 

I am just a 78 yo lady working on personal databases, nothing fancy.  I have not used Visual Basic programming for many years, and SQL is also a thing of the past.  Anyway, I do not have any user designed functions.   If I look at the inventory file, there is nothing listed as a missing utility.mda.

 

So, after about an hour of looking, checking, thinking, and more, I decided what happens if I just create a blank database  -- that was step one.  Step two was to import all info from the patterns file!!  Then I went into that new file and tried to add a new field – dateenterd – as a date/time field.  Then on down and set default value to DATE().      WORKS LIKE A CHARM!!!!!!!!!!!!.   Back to the basic sometimes works best. 

 

THANK YOU!!!  I APPRECIATE YOUR SUGGESTIONS AND DID LEARN A NEW BIT OF ACCESS 7.

 

Carol

 

Sent from Mail for Windows 10

 

From: Duane Hookom
Sent: Saturday, July 31, 2021 6:22 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Access 2007 issue

 

I agree with Giorgio about attempting to compile your code and check references.  I would also search your code for any user-defined function with the name Date() for instance:

 

Public Function Date() as Date

 

You might also want to make sure there are no modules that have the same name as a function or sub.

 

Maybe try create a new, blank Access file with a table containing a date field with a default of:

Default Value: Date()

 

Does this work?

 

Regards,

Duane

 

From: Giorgio Rovelli

 

Open a code window (Alt+F11) and check Tools > References. Are any missing?

On 07/31/2021 4:25 AM cash.ghwa@gmail.com wrote:

 

 

I am having a hard time adding a new field – "Date Input" to an existing file "Patterns".

 

I have successfully created this field in another database "Inventory" years ago, and it works great!  So I thought I would add that type field to "Patterns".  But all I get is an error .  I create the new field as a Date/Time field with these specs and get the message shown when trying to save the change to the database. 

 

It is driving me crazy.

 

 

I have tried using several Date functions – each comes back with the same Unknown function 'Date' error.

 

Can you help, please.  THANK YOU SO MUCH. 

 

Carol Higbee

 

Re: [MSAccessProfessionals] Access 2007 issue

I agree with Giorgio about attempting to compile your code and check references.  I would also search your code for any user-defined function with the name Date() for instance:

Public Function Date() as Date

You might also want to make sure there are no modules that have the same name as a function or sub.

Maybe try create a new, blank Access file with a table containing a date field with a default of:

Default Value: Date()

Does this work?

Regards,

Duane

---

From: Giorgio Rovelli

 

Open a code window (Alt+F11) and check Tools > References. Are any missing?

On 07/31/2021 4:25 AM cash.ghwa@gmail.com wrote:

I am having a hard time adding a new field – "Date Input" to an existing file "Patterns".

I have successfully created this field in another database "Inventory" years ago, and it works great!  So I thought I would add that type field to "Patterns".  But all I get is an error .  I create the new field as a Date/Time field with these specs and get the message shown when trying to save the change to the database. 

It is driving me crazy.

I have tried using several Date functions – each comes back with the same Unknown function 'Date' error.

Can you help, please.  THANK YOU SO MUCH. 

Carol Higbee

Re: [MSAccessProfessionals] Access 2007 issue

For default value, you can trt:

Date()

or

=Date()

On Sat, Jul 31, 2021, 12:31 PM <cash.ghwa@gmail.com> wrote:

I can add the field, but I want it to automatically update to the date the record was appended to the file.  No data entry in that field.

 

Carol

 

Sent from Mail for Windows 10

 

From: Duane Hookom
Sent: Friday, July 30, 2021 7:35 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Access 2007 issue

 

Did you try without setting the default value?

 

Duane

Sent from my mobile

On Jul 30, 2021, at 9:29 PM, cash.ghwa@gmail.com wrote:



I am having a hard time adding a new field – "Date Input" to an existing file "Patterns".

 

I have successfully created this field in another database "Inventory" years ago, and it works great!  So I thought I would add that type field to "Patterns".  But all I get is an error .  I create the new field as a Date/Time field with these specs and get the message shown when trying to save the change to the database. 

 

It is driving me crazy.

 

<AE9CDBD4A2CF406E97EA45DAE8782856.jpg>

 

I have tried using several Date functions – each comes back with the same Unknown function 'Date' error.

 

Can you help, please.  THANK YOU SO MUCH. 

 

Carol Higbee

 

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116032) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_