Kamis, 31 Oktober 2019

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (184)

Please zip all files prior to uploading to Files section.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Rabu, 30 Oktober 2019

Re: [AccessDevelopers] Looking for experienced Access programmer

 

Agree!!



 
Linda Day Harrison
(Linda@ManagerLabs.com)

technology for (visionary) property and facility people.
Chicago - Las Vegas Twitter Facebook
o.312.725.0060  m.312.671-2400  f.312.380.0383
skype me @ linda.day.harrison

 


On Tue, Oct 29, 2019 at 5:24 PM Duane Hookom duanehookom@hotmail.com [AccessDevelopers] <AccessDevelopers@yahoogroups.com> wrote:
 

I believe there is or at least was an Access LinkedIn group. There are various other forums. Personally I appreciate the informal emailing and having file storage afforded here but I don't think participate in the effort of creating a new forum. I monitor and answer questions in a couple other groups.

Duane
From: AccessDevelopers@yahoogroups.com <AccessDevelopers@yahoogroups.com> on behalf of Linda Day Harrison linda@managerlabs.com [AccessDevelopers] <AccessDevelopers@yahoogroups.com>
Sent: Tuesday, October 29, 2019 9:57 AM
To: AccessDevelopers@yahoogroups.com <AccessDevelopers@yahoogroups.com>
Subject: Re: [AccessDevelopers] Looking for experienced Access programmer
 
 

I think this group should just move to Linkedin if possible just in case we need something or to find each other. Do we have a Linkedin group?

Thanks,
Linda

 
Linda Day Harrison
(Linda@ManagerLabs.com)

technology for (visionary) property and facility people.
Chicago - Las Vegas Twitter Facebook
o.312.725.0060  m.312.671-2400  f.312.380.0383
skype me @ linda.day.harrison

 


On Thu, Oct 17, 2019 at 7:07 PM 'Joseph F. Gangi, Esq.' jgangiesq@optonline.net [AccessDevelopers] <AccessDevelopers@yahoogroups.com> wrote:
 


I have benefited from this group over the years and want to say thank you to all.

Right now, I am currently looking for an Access developer in NY (Long Island) to take an existing split database, clean it up, maximize performance, and possibly migrate to SQL. If anyone knows someone please email me back. Thank you.

__._,_.___
Posted by: Linda Day Harrison <Linda@managerlabs.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)

Please zip all files prior to uploading to Files section.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Selasa, 29 Oktober 2019

Re: [MS_AccessPros] Re: Need information

 

Khalid,
You stated "secured FE to my client in which he may not be able to view or modify code, forms queries modules and others" which is to provide the front-end as an accde file.

Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, October 29, 2019 1:38 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Re: Need information
 


Duane,
Thanks for replying, yes my application is for only one client at different location. My question would be the same which i just now asked to Bill. Up to now i was not giving to my client BE if required and demanded changes by the client, i take from him his BE then make changes also in FE. Make copy of modified BE and keep with me both BE and FE and give to my client modified BE and .accde.

My main concern to start this thread was to give secured FE to my client in which he may not be able to view or modify code, forms queries modules and others.

I would like to know more from you.

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Hi Khalid,
Changes to a back-end should be rare compared with the front-end. If you have deployed your application to a single location at your client's then it may be possible to get enough off line time from them to make changes to a back-end and return to them. I have used code in the past that would:
1) on opening of the front-end, check the version of the back-end (value in a back-end table)
2) if the back-end doesn't include specific tables/fields, then use DAO or transferDatabase to update the back-end
3) update the back-end version

I could add fields, tables, indexes etc with code in the front-end. This required exclusive use of the database temporarily but had very little impact on the users. They might need to allow only a few minutes for the upgrade.

For updating the front-end I provided the MDE (this was a long time ago) which the client was responsible for distributing. Often I would help with creating a VBS script file.

Regards,
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Sunday, October 27, 2019 8:29 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Re: Need information
 


Hi all & respected MVP's,

After more than a year I'm back, the reason is that I'm sick and on bed due to problem with my legs & feet, moreover my laptop was destroyed.

Anyways struggling and now ambitious to start working, during my this period of illness I think over what I have been doing and was forced and stop me on one main point which, I was doing wrong from the very beginning which I ignored and now realized that is a must. It was giving to my client .be + .accde instead of giving .fe + .accde.

But I've some concerns in this regard for which I'm not clear, I need & request complete guidance step by step, I remember John helped and posted in perhaps last quarter of 2013 how to secure FE and I put one module about shift bypass key in my database.

Now in a week or so I have to make many changes in my application on the request and demand of my client, so that is why I need help and guidance from the group.

Very first thing is that I've always given BE and .ACCDE to my client, I mean to say whenever the changes or updating was demanded by him, I took his BE make necessary work, copy his BE on my laptop and pass him his BE and latest .ACCDE.

Now for the first time I will give him secured FE + .ACCDE, should I ask him to delete his BE or it may remain on his system.

Secondly, what is the procedure of giving FE to client, would I have to make separate copy of secured FE for my client and protected copy of FE for me to make future updating and changes.

Need help please.

Regards

Khalid 

 

 



---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

You can ask questions here. The site is active.

Regards,
Bill Mosca

------ Original message------
From: khalidtanweerburrah@... [MS_Access_Professionals]
Date: Sat, Oct 26, 2019 2:23 PM
Cc:
Subject:Re: [MS_AccessPros] Re: Need information

 

Couldn't understand please write simple.

Regards,
Khalid





__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (14)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [AccessDevelopers] Thank You All

 

You can check out Professional Microsoft Access Developers' Network (PMADN) in LinkedIn.

Duane

Get Outlook for iOS
From: AccessDevelopers@yahoogroups.com <AccessDevelopers@yahoogroups.com> on behalf of Linda Day Harrison linda@managerlabs.com [AccessDevelopers] <AccessDevelopers@yahoogroups.com>
Sent: Tuesday, October 29, 2019 9:59:15 AM
To: AccessDevelopers@yahoogroups.com <AccessDevelopers@yahoogroups.com>
Subject: Re: [AccessDevelopers] Thank You All
 
 

I cannot tell you how many relationships/friendships I formed as a result of this group and how many amazing databases were built or helped as a result. I thank the moderators and the leaders of this group so very much. I am so super grateful and do miss the old MS Access days.
Hopefully we can migrate to Linkedin, if we have not already done so.

Thanks,
Linda


 
Linda Day Harrison
(Linda@ManagerLabs.com)

technology for (visionary) property and facility people.
Chicago - Las Vegas Twitter Facebook
o.312.725.0060  m.312.671-2400  f.312.380.0383
skype me @ linda.day.harrison

 


On Thu, Oct 17, 2019 at 12:51 PM luvmymelody@yahoo.com [AccessDevelopers] <AccessDevelopers@yahoogroups.com> wrote:
 

Hello All,


I have been a member since 2004 and I have been a moderator for quite awhile. I do not know why activity has dwindled but the success of the group is evidenced by those that participated and were able to make Microsoft Access do things beyond our wildest dreams. I know that moving forward, there will always be voices on the internet on various platforms that will continue to provide assistance to amazing software that adds critical business support to casual personal data reporting.


Good luck to all and may we all find the support we need in whatever we want to do.


Jim Wagner

__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)

Please zip all files prior to uploading to Files section.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [AccessDevelopers] Looking for experienced Access programmer

 

I believe there is or at least was an Access LinkedIn group. There are various other forums. Personally I appreciate the informal emailing and having file storage afforded here but I don't think participate in the effort of creating a new forum. I monitor and answer questions in a couple other groups.

Duane
From: AccessDevelopers@yahoogroups.com <AccessDevelopers@yahoogroups.com> on behalf of Linda Day Harrison linda@managerlabs.com [AccessDevelopers] <AccessDevelopers@yahoogroups.com>
Sent: Tuesday, October 29, 2019 9:57 AM
To: AccessDevelopers@yahoogroups.com <AccessDevelopers@yahoogroups.com>
Subject: Re: [AccessDevelopers] Looking for experienced Access programmer
 
 

I think this group should just move to Linkedin if possible just in case we need something or to find each other. Do we have a Linkedin group?

Thanks,
Linda

 
Linda Day Harrison
(Linda@ManagerLabs.com)

technology for (visionary) property and facility people.
Chicago - Las Vegas Twitter Facebook
o.312.725.0060  m.312.671-2400  f.312.380.0383
skype me @ linda.day.harrison

 


On Thu, Oct 17, 2019 at 7:07 PM 'Joseph F. Gangi, Esq.' jgangiesq@optonline.net [AccessDevelopers] <AccessDevelopers@yahoogroups.com> wrote:
 


I have benefited from this group over the years and want to say thank you to all.

Right now, I am currently looking for an Access developer in NY (Long Island) to take an existing split database, clean it up, maximize performance, and possibly migrate to SQL. If anyone knows someone please email me back. Thank you.

__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)

Please zip all files prior to uploading to Files section.

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Securing FE

 

Crystal,

Thanks a lot. You provided lot of information for my future development work.

Thanks again.
Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

hi Khalid,

definitely, you always want to keep your source code before you deploy a FE so you can change it and make it again!

The FEs you deploy will need to have its tables hooked up again to where ever their back-end is. If you don't have code to do this, they'll need to use the Linked Table Manager.

> "should I ask him to delete his BE "

absolutely not!! Your BE doesn't have the latest data. If anything, you should connect or visit and back up their BE for them. Show them how to do it though. And after it is backed up, it should have Compact/Repair done.

----- steps to open database for development -----

1. Close Access if it is open
2. Open Windows Explorer to your working directory
2. Back up database
2A. In Windows Explorer, right-click on current database filename. From the shortcut menu, choose:
??Send To > Compressed (zipped) folder
??to create a ZIP file
2B. After creating ZIP file, drag it to a backup folder to get it out of the working folder
3. rename database file to keep better track of changes
3A. Rename the file to include:?????????????????????? yymmdd_time
??WHERE
??'yymmdd' is year-month-day, two digits for each
??'time' is a time code like 1400 or 8a or 2p or whatever you want to know the current time

4. open the database in Access
5. compact/repair the database
6. do the development you have in mind

~~~

best wishes for better health

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 10/27/2019 8:48 PM, khalidtanweerburrah@... [MS_Access_Professionals] wrote:

Hi all & respected MVP???s,

After more than a year I???m back, the reason is that I???m sick and on bed due to problem with my legs & feet, moreover my laptop was destroyed.

Anyways struggling and now ambitious to start working, during my this period of illness I think over what I have been doing and was forced and stop me on one main point which, I was doing wrong from the very beginning which I ignored and now realized that is a must. It was giving to my client .be + .accde instead of giving .fe + .accde.

But I???ve some concerns in this regard for which I???m not clear, I need & request complete guidance step by step, I remember John helped and posted in perhaps last quarter of 2013 how to secure FE and I put one module about shift bypass key in my database.

Now in a week or so I have to make many changes in my application on the request and demand of my client, so that is why I need help and guidance from the group.

Very first thing is that I???ve always given BE and .ACCDE to my client, I mean to say whenever the changes or updating was demanded by him, I took his BE make necessary work, copy his BE on my laptop and pass him his BE and latest .ACCDE.

Now for the first time I will give him secured FE + .ACCDE, should I ask him to delete his BE or it may remain on his system.

Secondly, what is the procedure of giving FE to client, would I have to make separate copy of secured FE for my client and protected copy of FE for me to make future updating and changes.

Need help please.

Regards

Khalid??

__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (8)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: Securing FE

 

Doyce,


Yes, exactly the same what you wrote i'm being doing for many years. This makes me clear what i'm doing up to now is correct. I need not to bother more upon it and keep doing my work as before.

I use the option in my FE, Database Tools------>Make ACCDE in the right corner, not Save as which you mentioned.
Please tell am i on the right path?

You relieved me off from big headache.
Thanks for your reply and help 


---In MS_Access_Professionals@yahoogroups.com, <winberry.doyce@...> wrote :

Khalid,


Your customer's data is in the BE. This is where the tables reside. He must have that. If he deletes it, he has lost all data. The FE is the interface that the customer uses. You should give it to them secured in an ACCDE file. This protects your code and your work. It sounds to me like you are a bit confused with what an ACCDE file is. I build the user interface in an ACCDB then when I'm ready for the user to have it, I save a copy of the ACCDB as an ACCDE using SAVE AS. I keep the ACCDB for further development. The customer (user) gets the ACCDE file. I hope this answers your question.


Doyce



---In MS_Access_Professionals@yahoogroups.com, <khalidtanweerburrah@...> wrote :

Hi all & respected MVP's,

After more than a year I'm back, the reason is that I'm sick and on bed due to problem with my legs & feet, moreover my laptop was destroyed.

Anyways struggling and now ambitious to start working, during my this period of illness I think over what I have been doing and was forced and stop me on one main point which, I was doing wrong from the very beginning which I ignored and now realized that is a must. It was giving to my client .be + .accde instead of giving .fe + .accde.

But I've some concerns in this regard for which I'm not clear, I need & request complete guidance step by step, I remember John helped and posted in perhaps last quarter of 2013 how to secure FE and I put one module about shift bypass key in my database.

Now in a week or so I have to make many changes in my application on the request and demand of my client, so that is why I need help and guidance from the group.

Very first thing is that I've always given BE and .ACCDE to my client, I mean to say whenever the changes or updating was demanded by him, I took his BE make necessary work, copy his BE on my laptop and pass him his BE and latest .ACCDE.

Now for the first time I will give him secured FE + .ACCDE, should I ask him to delete his BE or it may remain on his system.

Secondly, what is the procedure of giving FE to client, would I have to make separate copy of secured FE for my client and protected copy of FE for me to make future updating and changes.

Need help please.

Regards

Khalid 

__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Re: Need information

 

Duane,

Thanks for replying, yes my application is for only one client at different location. My question would be the same which i just now asked to Bill. Up to now i was not giving to my client BE if required and demanded changes by the client, i take from him his BE then make changes also in FE. Make copy of modified BE and keep with me both BE and FE and give to my client modified BE and .accde.

My main concern to start this thread was to give secured FE to my client in which he may not be able to view or modify code, forms queries modules and others.

I would like to know more from you.

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Hi Khalid,
Changes to a back-end should be rare compared with the front-end. If you have deployed your application to a single location at your client's then it may be possible to get enough off line time from them to make changes to a back-end and return to them. I have used code in the past that would:
1) on opening of the front-end, check the version of the back-end (value in a back-end table)
2) if the back-end doesn't include specific tables/fields, then use DAO or transferDatabase to update the back-end
3) update the back-end version

I could add fields, tables, indexes etc with code in the front-end. This required exclusive use of the database temporarily but had very little impact on the users. They might need to allow only a few minutes for the upgrade.

For updating the front-end I provided the MDE (this was a long time ago) which the client was responsible for distributing. Often I would help with creating a VBS script file.

Regards,
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Sunday, October 27, 2019 8:29 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Re: Need information
 


Hi all & respected MVP's,

After more than a year I'm back, the reason is that I'm sick and on bed due to problem with my legs & feet, moreover my laptop was destroyed.

Anyways struggling and now ambitious to start working, during my this period of illness I think over what I have been doing and was forced and stop me on one main point which, I was doing wrong from the very beginning which I ignored and now realized that is a must. It was giving to my client .be + .accde instead of giving .fe + .accde.

But I've some concerns in this regard for which I'm not clear, I need & request complete guidance step by step, I remember John helped and posted in perhaps last quarter of 2013 how to secure FE and I put one module about shift bypass key in my database.

Now in a week or so I have to make many changes in my application on the request and demand of my client, so that is why I need help and guidance from the group.

Very first thing is that I've always given BE and .ACCDE to my client, I mean to say whenever the changes or updating was demanded by him, I took his BE make necessary work, copy his BE on my laptop and pass him his BE and latest .ACCDE.

Now for the first time I will give him secured FE + .ACCDE, should I ask him to delete his BE or it may remain on his system.

Secondly, what is the procedure of giving FE to client, would I have to make separate copy of secured FE for my client and protected copy of FE for me to make future updating and changes.

Need help please.

Regards

Khalid 

 

 



---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

You can ask questions here. The site is active.

Regards,
Bill Mosca

------ Original message------
From: khalidtanweerburrah@... [MS_Access_Professionals]
Date: Sat, Oct 26, 2019 2:23 PM
Cc:
Subject:Re: [MS_AccessPros] Re: Need information

 

Couldn't understand please write simple.

Regards,
Khalid



__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (11)

.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Re: Need information

 

Bill,

Thanks for your reply. Yet there are many questions. I would simply start one by one and make myself clear.

1. Which files do you give to your client:
BE, FE and .accde

Regards,
Khalid

(Will this site be running in future or we still need to have some free forum to shift)


---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Khalid -  my typical systems are set up with a accdb for developing and making changes. Then I export the changed objects to my production copy of the FE. I create a new FE that is the clIent's accde.

I would make a copy of the client's BE and make changes in it. Then use it as the new BE and relink your tables.

Regards,
Bill Mosca

------ Original message------
From: khalidtanweerburrah@... [MS_Access_Professionals]
Date: Mon, Oct 28, 2019 10:10 AM
Cc:
Subject:Re: [MS_AccessPros] Re: Need information

 

Hi all & respected MVP's,

After more than a year I'm back, the reason is that I'm sick and on bed due to problem with my legs & feet, moreover my laptop was destroyed.

Anyways struggling and now ambitious to start working, during my this period of illness I think over what I have been doing and was forced and stop me on one main point which, I was doing wrong from the very beginning which I ignored and now realized that is a must. It was giving to my client .be + .accde instead of giving .fe + .accde.

But I've some concerns in this regard for which I'm not clear, I need & request complete guidance step by step, I remember John helped and posted in perhaps last quarter of 2013 how to secure FE and I put one module about shift bypass key in my database.

Now in a week or so I have to make many changes in my application on the request and demand of my client, so that is why I need help and guidance from the group.

Very first thing is that I've always given BE and .ACCDE to my client, I mean to say whenever the changes or updating was demanded by him, I took his BE make necessary work, copy his BE on my laptop and pass him his BE and latest .ACCDE.

Now for the first time I will give him secured FE + .ACCDE, should I ask him to delete his BE or it may remain on his system.

Secondly, what is the procedure of giving FE to client, would I have to make separate copy of secured FE for my client and protected copy of FE for me to make future updating and changes.

Need help please.

Regards

Khalid  

 

 

__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (13)

.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)