Citrix, mde file and active X control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an MS Access 2000 app running in Access XP which has an active X control (the calendar - MSCAL.ocx). The calendar resides in a subform which is launched when the user clicks on the subform. The subform has additional code so the date that is selected in the subform calendar is set in a field in the parent form. I had to make a minor code change to get this to work via Citrix. It works exactly as expected when the application is a mdb file launched via Citrix. This is the wierd part, when I convert the application to a mde file I get the following message when trying to launch the calendar.

the error msg: " the expression on click you entered as the event property setting produced the following error:the open form action was cancelled. The expression may not result in the name of a macro, user defined function or event procedure. OR there maybe an error in evaluating the function, event or macro.

One time I was able to get the subsequent mde file to work, but I can't seem to repeat the process. Yes, I could leave it as as mdb file, but everyone knows the risk that can incur. Tried converting the mdb to XP then to mde. Doesn't work

Its frustrating cause I can't walk the code in an mde file to determine exactly what is doesn't like, yet there is no sign of any problems when walking the code in the mdb file

any thoughts on what to try next would be appreciated

lind

In addition, I saw the thread on every user having their own copy of the interface file, no 2 users in at the same time if using Citrix. The people that are going to be using my app can't have that configuration because of a Congress(yes, the US Congress) directive that is being implemented. I hope I don't see the timeout issues........
 
linda said:
I have an MS Access 2000 app running in Access XP which has an active X control (the calendar - MSCAL.ocx).

One solution is to ditch the ocx and use a form or an API call.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL. There are
links to several downloadable calendar forms at my website. As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.
the error msg: " the expression on click you entered as the event property setting produced the following error:the open form action was cancelled. The expression may not result in the name of a macro, user defined function or event procedure. OR there maybe an error in evaluating the function, event or macro."

IIRC this is a references problem but use a form or API call. Safer
in the long run.
In addition, I saw the thread on every user having their own copy of the interface file, no 2 users in at the same time if using Citrix. The people that are going to be using my app can't have that configuration because of a Congress(yes, the US Congress) directive that is being implemented. I hope I don't see the timeout issues........

By interface file you mean the front end (FE) MDB/MDE containing
queries, forms, reports, macros (if any) and modules. Yes, you
really, really do want to give each user their own copy.

Then the US Congress should be disregarded for this situation. Our
collective experience and judgement overrides thief idiocy.

I also strongly suspect some idiot bureaucrat and/or fascist IT
department has made a decree and is utterly unwilling to listen to
reasonable objections.

Time to look for a new job.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top