Jumat, 08 September 2017

Re: [MS_AccessPros] run time version of access

 

you're welcome, Liz ~ happy to help

have an awesome day,
crystal

On 9/8/17 10:00 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Thanks Crystal.  I'll notify the developer.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 7, 2017 4:33 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] run time version of access

 



hi Liz,

no ... for instance:

   'late-binding for deployment -- and Word Library is NOT referenced under Tools,References, and values of constants are used in code
'   Dim oWrd As Object _
      , oDoc As Object _
      , oTable As Object _
      , oRng As Object _
      , oRng2 As Object

   'early-binding for development
   Dim oWrd As Word.Application _
      , oDoc As Word.Document _
      , oTable As Word.Table _
      , oRng As Word.Range _
      , oRng2 As Word.Range


have an awesome day,
crystal

On 9/7/17 3:45 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Thanks Crystal.  What do you mean by late binding?  Like assign recordsources after the form is open?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 7, 2017 12:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] run time version of access

 



hi Liz,

the basics are the same, but sometime things don't work in Runtime like they do on the desktop -- each time I have had issues, I have found other ways to do what is needed ... well except for things that should have been in administrator database and so now they are ;)  Ironically, however, now that Office 365 is so prevalent ... users that thought they didn't have access to Access oftentimes actually do ~

to investigate, you need the accdb. Before distributing, it needs to be compiled and saves. It is best to use LATE binding for objects so those with other versions (and therefore, other versions of the reference libraries) can run without problems.

have an awesome day,
crystal

On 9/7/17 12:29 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Pros, is there a significant loss of functionality with using the free run time version of access?

 

I need to do more investigation as I am looking at a database someone else built and they tried to run a copy using the free version and the subform with conditional formatting didn't display, as well as the defaults being set on that form.

 

Do you have recommendations or where I can turn to investigate this?



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.








This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.







This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar