Auto FE Updater in Run Time

[Chip]

Hey Everyone,

I have a problem and am hoping someone else has had it too.. In my
applicaiton, I have implemented the Albert Kallal Super Easy Mail
Merge and its been working beutifully now for about a year. Recently,
I implemented the Auto FE Updater function.

Since doing this, my super easy mail merge functions have stopped
functioning properly. Now when my user clicks on the button to run
the mail merge, the report thats generated retains the old values. It
shows the values from the last time the code was run. So my user,
clicked once, sent out the information and everything was fine. She
switched records to go to another task and clicked the same button and
the report that was generated retained the 1st reports values.

The form, where the report gets its information is updated and showing
the correct information. I thought perhaps it might have somethign to
do wtih teh fact that my distributed FE is in RunTime. I removed that
and it didnt help. It works fine on my desktop. I am able to get teh
right informatino out without issue. But its when I distribute the
Front End that I run into problems.

chip

 

[Tony Toews [MVP]]

I have a problem and am hoping someone else has had it too.. In my
applicaiton, I have implemented the Albert Kallal Super Easy Mail
Merge and its been working beutifully now for about a year. Recently,
I implemented the Auto FE Updater function.

We've been exchanging emails too. I suspect the problem is that
Albert's Mail Merge defaults to using sub folders. Which the Auto FE
Updater does not currently support. It will in a month or so but not
yet.

He's going to try putting them in the same folder on the server and
see what happens.

Hmm, now if Chip is using the %appdata% in the Target folder on the
client system he's going to have to use the API code to retrieve that
Turns out he was using an environment variable so the environ function
will work just fine.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Mark Andrews]

I use this code with the runtime and it works just fine. I actually use
three sub folders for three
different types of mail merges so not sure switching Albert's code to not
use folders is the correct solution.
You should probably make a little change so Alberts code looks for doc and
docx files (now that word 2007) is around.

I don't use the Auto FE Updater.

I'll let you guys solve the problem,
Mark