anyone else seen problem using LEN() function in Runtime?

[Rob - IT Data Services]

HI.

I have an applicaiton that for one of the combo boxes has a query that uses
the Len() function to shorten the description length for sorting the list.

Eg: Right([Partdescription],(Len([PartDescription])-11))

This was working fine - however having loaded the AccessRT.msp Runtime
pre-release patch from microsoft to fix the SaveAsPDF addin problem the len
function doesnt work.

I have even tried to generate a standalone app that has a Form with a button
and the VB code has a
Msgbox Len([Me]![ErrorBox])
Under the runtime with the pre-release patch the msgbox does not display.
Under Access 2007 (full version) it works fine.

 

[Stefan Hoffmann]

hi,

I have even tried to generate a standalone app that has a Form with a button
and the VB code has a
Msgbox Len([Me]![ErrorBox])
Under the runtime with the pre-release patch the msgbox does not display.
Under Access 2007 (full version) it works fine.

Check the references, sounds like they are not the same under RT.



mfG
--> stefan <--

 

[Allen Browne]

Is the database is a trusted location?

Jeff Conrad answers the question:
Using Access 2007 Runtime, how can I create a
Trusted Location if there's no UI to create it?
here:
http://accessjunkie.com/faq_33.aspx

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[Rob - IT Data Services]

I cant see where you can check the references under runtime - but this was
working until I applied the pre-release ACCESSRT.msp Runtime path which was
supplied by microsoft to fix the SaveAsPDF Addin not working under runtime.

I could roll my laptop back to pre patch as I did take a image before
applying as they said there was no uninstalling it.

hi,

I have even tried to generate a standalone app that has a Form with a button
and the VB code has a
Msgbox Len([Me]![ErrorBox])
Under the runtime with the pre-release patch the msgbox does not display.
Under Access 2007 (full version) it works fine.

Check the references, sounds like they are not the same under RT.



mfG
--> stefan <--

 

[Rob - IT Data Services]

Yes the Database is in a trusted location using a registry patch.
This was working until I applied the ACCESSRT.msp Patch for the SaveAsPDF
addin fix for runtime.

Is the database is a trusted location?

Jeff Conrad answers the question:
Using Access 2007 Runtime, how can I create a
Trusted Location if there's no UI to create it?
here:
http://accessjunkie.com/faq_33.aspx

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message

HI.

I have an applicaiton that for one of the combo boxes has a query that
uses
the Len() function to shorten the description length for sorting the list.

Eg: Right([Partdescription],(Len([PartDescription])-11))

This was working fine - however having loaded the AccessRT.msp Runtime
pre-release patch from microsoft to fix the SaveAsPDF addin problem the
len
function doesnt work.

I have even tried to generate a standalone app that has a Form with a
button
and the VB code has a
Msgbox Len([Me]![ErrorBox])
Under the runtime with the pre-release patch the msgbox does not display.
Under Access 2007 (full version) it works fine.

 

[Allen Browne]

That doesn't sound good, Rob.

Haven't tested that combination, but it does sound as though the patch may
have broken it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message

Yes the Database is in a trusted location using a registry patch.
This was working until I applied the ACCESSRT.msp Patch for the SaveAsPDF
addin fix for runtime.

Is the database is a trusted location?

Jeff Conrad answers the question:
Using Access 2007 Runtime, how can I create a
Trusted Location if there's no UI to create it?
here:
http://accessjunkie.com/faq_33.aspx

"Rob - IT Data Services" <[email protected]>
wrote
in message

HI.

I have an applicaiton that for one of the combo boxes has a query that
uses
the Len() function to shorten the description length for sorting the
list.

Eg: Right([Partdescription],(Len([PartDescription])-11))

This was working fine - however having loaded the AccessRT.msp Runtime
pre-release patch from microsoft to fix the SaveAsPDF addin problem the
len
function doesnt work.

I have even tried to generate a standalone app that has a Form with a
button
and the VB code has a
Msgbox Len([Me]![ErrorBox])
Under the runtime with the pre-release patch the msgbox does not
display.
Under Access 2007 (full version) it works fine.