Re: [MSAccessProfessionals] Lockdown

Paul,

Good tip, if I can't find it.

Thanks,

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Friday, September 24, 2021 2:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

The workaround/hack solution if you can't find where it's called is to comment out all the ChangeProperty lines.  The sub will still be called but it won't do anything.

 

Paul

 

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

From: "Bill Singer" <Bill.Singer@at-group.net>

To: MSAccessProfessionals@groups.io

Sent: 9/24/2021 11:58:10 AM

Subject: Re: [MSAccessProfessionals] Lockdown

 

Duane,

I still can't find it.

 

This is what is disabling the toolbars. (I believe).  I just can't figure out where is it being called from.  It has to be something on the main start up but it does not seem to be in the start up form, unless I am looking in the wrong place.

 

Sub disableStartupProperties()

ChangeProperty "StartupShowDBWindow", dbBoolean, False

ChangeProperty "StartupShowStatusBar", dbBoolean, False

ChangeProperty "AllowBuiltinToolbars", dbBoolean, False

ChangeProperty "AllowFullMenus", dbBoolean, False

ChangeProperty "AllowBreadinCode", dbBoolean, False

ChangeProperty "AllowSpecialKeys", dbBoolean, False

ChangeProperty "AllowBypassKeys", dbBoolean, False

ChangeProperty "AllowShortcutMenus", dbBoolean, False

End Sub

 

 

I have a On Key Down event that turns everything back on.  

If KeyCode = 191 And Shift = 1 Then

    EnableStartupProperties

    MsgBox "Security Disabled", vbInformation

 

 

Now that everything is turned back on it works fine on start-up,  but I sure wish I could find  Sub disableStartupProperties()

 

I am not sure how to do a search.

 

 

 

Bill

 

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 2:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

 

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

Re: [MSAccessProfessionals] Lockdown

The only other thing that it might be is a separate database file referenced into the project. I have a few systems where i have a shared code repository db that i reference into other projects to keep code maintenance to a minimum. You wont find the code using a search, at least i dont think you will. 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

Re: [MSAccessProfessionals] Lockdown

Bill – Go to the code window and do a Find on the entire project. That should find the Sub. Also ChangeProperties is either a sub or a function. That's the one doing the work.

 

Regards,

Bill Mosca

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, September 24, 2021 11:58 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

Duane,

I still can't find it.

 

This is what is disabling the toolbars. (I believe).  I just can't figure out where is it being called from.  It has to be something on the main start up but it does not seem to be in the start up form, unless I am looking in the wrong place.

 

Sub disableStartupProperties()

ChangeProperty "StartupShowDBWindow", dbBoolean, False

ChangeProperty "StartupShowStatusBar", dbBoolean, False

ChangeProperty "AllowBuiltinToolbars", dbBoolean, False

ChangeProperty "AllowFullMenus", dbBoolean, False

ChangeProperty "AllowBreadinCode", dbBoolean, False

ChangeProperty "AllowSpecialKeys", dbBoolean, False

ChangeProperty "AllowBypassKeys", dbBoolean, False

ChangeProperty "AllowShortcutMenus", dbBoolean, False

End Sub

 

 

I have a On Key Down event that turns everything back on.  

If KeyCode = 191 And Shift = 1 Then

    EnableStartupProperties

    MsgBox "Security Disabled", vbInformation

 

 

Now that everything is turned back on it works fine on start-up,  but I sure wish I could find  Sub disableStartupProperties()

 

I am not sure how to do a search.

 

 

 

Bill

 

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 2:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

 

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

Re: [MSAccessProfessionals] Lockdown

The workaround/hack solution if you can't find where it's called is to comment out all the ChangeProperty lines.  The sub will still be called but it won't do anything.

Paul

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

From: "Bill Singer" <Bill.Singer@at-group.net>

To: MSAccessProfessionals@groups.io

Sent: 9/24/2021 11:58:10 AM

Subject: Re: [MSAccessProfessionals] Lockdown

Duane,

I still can't find it.

 

This is what is disabling the toolbars. (I believe).  I just can't figure out where is it being called from.  It has to be something on the main start up but it does not seem to be in the start up form, unless I am looking in the wrong place.

 

Sub disableStartupProperties()

ChangeProperty "StartupShowDBWindow", dbBoolean, False

ChangeProperty "StartupShowStatusBar", dbBoolean, False

ChangeProperty "AllowBuiltinToolbars", dbBoolean, False

ChangeProperty "AllowFullMenus", dbBoolean, False

ChangeProperty "AllowBreadinCode", dbBoolean, False

ChangeProperty "AllowSpecialKeys", dbBoolean, False

ChangeProperty "AllowBypassKeys", dbBoolean, False

ChangeProperty "AllowShortcutMenus", dbBoolean, False

End Sub

 

 

I have a On Key Down event that turns everything back on.  

If KeyCode = 191 And Shift = 1 Then

    EnableStartupProperties

    MsgBox "Security Disabled", vbInformation

 

 

Now that everything is turned back on it works fine on start-up,  but I sure wish I could find  Sub disableStartupProperties()

 

I am not sure how to do a search.

 

 

 

Bill

 

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 2:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

Re: [MSAccessProfessionals] Lockdown

Duane,

I still can't find it.

 

This is what is disabling the toolbars. (I believe).  I just can't figure out where is it being called from.  It has to be something on the main start up but it does not seem to be in the start up form, unless I am looking in the wrong place.

 

Sub disableStartupProperties()

ChangeProperty "StartupShowDBWindow", dbBoolean, False

ChangeProperty "StartupShowStatusBar", dbBoolean, False

ChangeProperty "AllowBuiltinToolbars", dbBoolean, False

ChangeProperty "AllowFullMenus", dbBoolean, False

ChangeProperty "AllowBreadinCode", dbBoolean, False

ChangeProperty "AllowSpecialKeys", dbBoolean, False

ChangeProperty "AllowBypassKeys", dbBoolean, False

ChangeProperty "AllowShortcutMenus", dbBoolean, False

End Sub

 

 

I have a On Key Down event that turns everything back on.  

If KeyCode = 191 And Shift = 1 Then

    EnableStartupProperties

    MsgBox "Security Disabled", vbInformation

 

 

Now that everything is turned back on it works fine on start-up,  but I sure wish I could find  Sub disableStartupProperties()

 

I am not sure how to do a search.

 

 

 

Bill

 

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 2:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

[Special] [MSAccessProfessionals] Links Location

Hi All

It's been quite a while since we mentioned the location of all the links we had in our Yahoo group. You can now find them in the Databases section. Lots of great stuff.

Please be sure to let us know if you find a broken link so we can either fix it or delete it.
--

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.

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

_._,_._,_

Re: [MSAccessProfessionals] indent string to the right by space characters

thank-you for your help

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

Re: [MSAccessProfessionals] indent string to the right by space characters

thanks

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

Re: [MSAccessProfessionals] indent string to the right by space characters

Could you count the periods in the string then add that number of spaces to the string

James Hundley

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of smiley2004_10 <cas23121964@gmail.com>
Sent: Thursday, September 23, 2021 7:42:16 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] indent string to the right by space characters

 

Hi

 

I would like to achieve the following!

Is to move the string value to the right X number of spaces to right based upon a user input criteria.

 

Is there a function or SQL I could use to achieve the following without a case format, as that would be to limiting.

 

"1"                  (being level 0)

  "1.1"    (being Level 1)

     "1.1.1"      (being level 2)

 

Thanks

Re: [MSAccessProfessionals] indent string to the right by space characters

You should consider using the String() function. https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/string-function

Duane

Sent from my mobile

On Sep 23, 2021, at 6:42 PM, smiley2004_10 <cas23121964@gmail.com> wrote:



Hi

 

I would like to achieve the following!

Is to move the string value to the right X number of spaces to right based upon a user input criteria.

 

Is there a function or SQL I could use to achieve the following without a case format, as that would be to limiting.

 

"1"                  (being level 0)

  "1.1"    (being Level 1)

     "1.1.1"      (being level 2)

 

Thanks

[MSAccessProfessionals] indent string to the right by space characters

Hi

 

I would like to achieve the following!

Is to move the string value to the right X number of spaces to right based upon a user input criteria.

 

Is there a function or SQL I could use to achieve the following without a case format, as that would be to limiting.

 

"1"                  (being level 0)

  "1.1"    (being Level 1)

     "1.1.1"      (being level 2)

 

Thanks

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

Re: [MSAccessProfessionals] Lockdown

I have not had a chance to track this down, however I do not have an Auto Exec. 

Thanks for the help.

 

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Thursday, September 23, 2021 1:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

Hi Bill & Duane

 

I put a call to my lockdown stuff in my startup form's Load event. You might want to use my PropertiesSetter utility in our files/0_Utilities%20and%20Add-ins folder. It will let you bypass startup forms, autoexec macros and set the properties you want on the target database so you can get in to poke around to find your module and where it is being called.

 

MZTools for VBA has a feature that will track down all places a function or sub is called. That might be helpful as well. It's not free, but it's well worth the price. You can download it at https://www.mztools.com/v8/download_trial.aspx  By the way, this add-in has been my go-to for 20 years. Too many features to list here.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 12:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

 

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

Re: [MSAccessProfessionals] Lockdown

Hi Bill & Duane

 

I put a call to my lockdown stuff in my startup form's Load event. You might want to use my PropertiesSetter utility in our files/0_Utilities%20and%20Add-ins folder. It will let you bypass startup forms, autoexec macros and set the properties you want on the target database so you can get in to poke around to find your module and where it is being called.

 

MZTools for VBA has a feature that will track down all places a function or sub is called. That might be helpful as well. It's not free, but it's well worth the price. You can download it at https://www.mztools.com/v8/download_trial.aspx  By the way, this add-in has been my go-to for 20 years. Too many features to list here.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 12:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

Re: [MSAccessProfessionals] Lockdown

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

[MSAccessProfessionals] Lockdown

 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10

Re: [MSAccessProfessionals] Do you want a way to see the hidden metadata that files store? Extended File Properties

here's the video link:

Get Extended File Properties from Windows with free Access tools (58:15)
https://www.youtube.com/watch?v=fwQnhKWo1Ks

On 9/14/2021 6:23 PM, crystal (strive4peace) via groups.io wrote:
> hello Access friends,
>
> Do you want a way to see the hidden metadata that files store? This is
> a  great tool:
>
> Wayne Phillips', EverythingAccess.com, Extended File Properties tool -
> File Property Explorer
> https://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System
>
>
> and that's not all!
>
> How would you like to get this information for every picture on your
> computer? Watch the presentation to find out how, and download the
> free tool to make an Excel workbook with all the data!
>
> To scan a whole drive, there's an Easter Egg (the video tells you how
> to find it). It took 39 minutes to do one of my drives and  it
> recorded picture information for more than 40,000 files!
>
> kind regards,
> crystal
>
> 1-on-1 training: great knowledge, low prices
> http://msaccessgurus.com/training.htm
>
>
>
>
>
>
>
>


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

[MSAccessProfessionals] Do you want a way to see the hidden metadata that files store? Extended File Properties

hello Access friends,

Do you want a way to see the hidden metadata that files store? This is
a  great tool:

Wayne Phillips', EverythingAccess.com, Extended File Properties tool -
File Property Explorer
https://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System


and that's not all!

How would you like to get this information for every picture on your
computer? Watch the presentation to find out how, and download the free
tool to make an Excel workbook with all the data!

To scan a whole drive, there's an Easter Egg (the video tells you how to
find it). It took 39 minutes to do one of my drives and  it recorded
picture information for more than 40,000 files!

kind regards,
crystal

1-on-1 training: great knowledge, low prices
http://msaccessgurus.com/training.htm





-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116048): https://groups.io/g/MSAccessProfessionals/message/116048
Mute This Topic: https://groups.io/mt/85615628/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] Locking specified records for editing, deleting etc

Use data macro (beforeUpdate) to cancel editing.

On Sat, Sep 4, 2021, 9:35 PM access_kri via groups.io <access_kri=yahoo.com@groups.io> wrote:

Dear Experts,
                     I want to achieve the following result. Please guide me.  I have a table in which I have a yes/no flag to mark which record cannot be either edited or deleted. If someone tries to edit the record, it will give message "This record is not editable", even if someone tries to edit the recordset directly from table as against from form. Is it possible. 

Regards,
Kumar

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

[MSAccessProfessionals] Locking specified records for editing, deleting etc

Dear Experts,
                     I want to achieve the following result. Please guide me.  I have a table in which I have a yes/no flag to mark which record cannot be either edited or deleted. If someone tries to edit the record, it will give message "This record is not editable", even if someone tries to edit the recordset directly from table as against from form. Is it possible. 

Regards,
Kumar

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

Re: [MSAccessProfessionals] online Access user group meeting

hi Carol,

there is another meeting later on today!

You can get and save extended file property information such as the date a picture was taken and how long a video file is. One of the tools puts that into Excel :)

Click "Join Webex Meeting" at bottom of this link:
https://accessusergroups.org/pacific/event/access-pacific-2021-09-02/

TODAY, Thursday, Sept 2
Time is 6:30 pm Pacific, 1:30 am UTC

Hope to see you, Carol

kind regards,
crystal

On 9/2/2021 11:53 AM, cash.ghwa@gmail.com wrote:

I am so sorry to have missed this group meeting.   Please keep me on your list of "interested parties" for upcoming meetings.  I thought this was a Zoom meeting, but I guess it is not.  Is any software download needed to attend?

 

Thanks,

Carol Higbee

 

cash.ghwa@gmail.com

 

 

 

Sent from Mail for Windows

 

From: crystal (strive4peace) via groups.io
Sent: Saturday, August 28, 2021 9:03 PM
To: MSAccessProfessionals@groups.io
Subject: [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] online Access user group meeting

I am so sorry to have missed this group meeting.   Please keep me on your list of "interested parties" for upcoming meetings.  I thought this was a Zoom meeting, but I guess it is not.  Is any software download needed to attend?

 

Thanks,

Carol Higbee

 

cash.ghwa@gmail.com

 

 

 

Sent from Mail for Windows

 

From: crystal (strive4peace) via groups.io
Sent: Saturday, August 28, 2021 9:03 PM
To: MSAccessProfessionals@groups.io
Subject: [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] user group meeting - Extended File Properties

Aw, I see Pacific is a brand new chapter in the AccessUserGroups constellation :-)

Video list has a

Beginning Access Developer, Part 2–Forms, Reports, Macros, QAT-

wasn't Part 1 recorded?

Ciao

Giorgio

On 09/02/2021 3:46 PM crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

hi Giorgio,

yes, it will be recorded and then posted in a couple weeks here:

https://www.youtube.com/channel/UCa_ke31HE1lg45NFZlK6gSw/videos

there are lots of videos on this list that may interest you ~ and some of those session, I know you attended :)

kind regards,
crystal

On 9/2/2021 8:31 AM, Giorgio Rovelli via groups.io wrote:

3:30am in Italy. Any chance of it been recorded?

Giorgio

On 09/02/2021 12:20 AM crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

hello Access developers,

Have you ever wanted to find out properties about a file, such as the

duration length of an MP3 file, or the date a JPG picture file was taken

on a digital camera?

Windows Explorer shows us this sort of information, so surely we can tap

into this facility to programmatically access these "properties"?

And indeed you can! Come to the Access Pacific online user group

meeting, hosted by George Hepworth, and find out how!

I will demonstrate Wayne Phillips' (EverythingAccess) free too to get

extended file information. He also wrote procedures you can call in your

own VBA programs to get this information.

And a bonus! Colin Riddington (isladogs) also has a free tool to get

extended properties, so that will be shown as well.

Click "Join Webex Meeting" at bottom of this link:

https://lnkd.in/eVAPK7rb

DATE: Thu, 2 Sept / Fri 3 Sept

TIME: 6:30pm Pacific / 2:30 am London

Join us! It's free, fascinating, and fun

kind regards,

crystal

Re: [MSAccessProfessionals] user group meeting - Extended File Properties

hi Giorgio,

yes, it will be recorded and then posted in a couple weeks here:

https://www.youtube.com/channel/UCa_ke31HE1lg45NFZlK6gSw/videos

there are lots of videos on this list that may interest you ~ and some of those session, I know you attended :)

kind regards,
crystal

On 9/2/2021 8:31 AM, Giorgio Rovelli via groups.io wrote:

3:30am in Italy. Any chance of it been recorded?

Giorgio

On 09/02/2021 12:20 AM crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

hello Access developers,

Have you ever wanted to find out properties about a file, such as the

duration length of an MP3 file, or the date a JPG picture file was taken

on a digital camera?

Windows Explorer shows us this sort of information, so surely we can tap

into this facility to programmatically access these "properties"?

And indeed you can! Come to the Access Pacific online user group

meeting, hosted by George Hepworth, and find out how!

I will demonstrate Wayne Phillips' (EverythingAccess) free too to get

extended file information. He also wrote procedures you can call in your

own VBA programs to get this information.

And a bonus! Colin Riddington (isladogs) also has a free tool to get

extended properties, so that will be shown as well.

Click "Join Webex Meeting" at bottom of this link:

https://lnkd.in/eVAPK7rb

DATE: Thu, 2 Sept / Fri 3 Sept

TIME: 6:30pm Pacific / 2:30 am London

Join us! It's free, fascinating, and fun

kind regards,

crystal

Re: [MSAccessProfessionals] user group meeting - Extended File Properties

3:30am in Italy. Any chance of it been recorded?

Giorgio

On 09/02/2021 12:20 AM crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

hello Access developers,

Have you ever wanted to find out properties about a file, such as the

duration length of an MP3 file, or the date a JPG picture file was taken

on a digital camera?

Windows Explorer shows us this sort of information, so surely we can tap

into this facility to programmatically access these "properties"?

And indeed you can! Come to the Access Pacific online user group

meeting, hosted by George Hepworth, and find out how!

I will demonstrate Wayne Phillips' (EverythingAccess) free too to get

extended file information. He also wrote procedures you can call in your

own VBA programs to get this information.

And a bonus! Colin Riddington (isladogs) also has a free tool to get

extended properties, so that will be shown as well.

Click "Join Webex Meeting" at bottom of this link:

https://lnkd.in/eVAPK7rb

DATE: Thu, 2 Sept / Fri 3 Sept

TIME: 6:30pm Pacific / 2:30 am London

Join us! It's free, fascinating, and fun

kind regards,

crystal

[MSAccessProfessionals] user group meeting - Extended File Properties

hello Access developers,

Have you ever wanted to find out properties about a file, such as the
duration length of an MP3 file, or the date a JPG picture file was taken
on a digital camera?

Windows Explorer shows us this sort of information, so surely we can tap
into this facility to programmatically access these "properties"?

And indeed you can! Come to the Access Pacific online user group
meeting, hosted by George Hepworth, and find out how!

I will demonstrate Wayne Phillips' (EverythingAccess) free too to get
extended file information. He also wrote procedures you can call in your
own VBA programs to get this information.

And a bonus! Colin Riddington (isladogs) also has a free tool to get
extended properties, so that will be shown as well.

Click "Join Webex Meeting" at bottom of this link:
https://lnkd.in/eVAPK7rb

DATE: Thu, 2 Sept / Fri 3 Sept
TIME: 6:30pm Pacific / 2:30 am London

Join us! It's free, fascinating, and fun

kind regards,
crystal



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