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

  • Thread starter Thread starter Rob - IT Data Services
  • Start date Start date
R

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.
 
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.
Click to expand...
Check the references, sounds like they are not the same under RT.



mfG
--> stefan <--
 
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]...
 
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.

Stefan Hoffmann said:
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.
Click to expand...
Check the references, sounds like they are not the same under RT.



mfG
--> stefan <--
Click to expand...
 
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.

Allen Browne said:
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.
Click to expand...
Click to expand...
 
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.

Allen Browne said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top