Calendar control conversion issue

Hi all,

I still do most of my development at home using Access97. At work, I convert
the FE to the default 2000 format on a computer running Access 2002(or maybe
it's 2003, I'm not sure which). I can then distribute that converted FE to
either Access 2002/2003 and Access 2007 computers and everything works fine.

Someone showed up with Access 2010 and the Calendar Control that I use
(MSCAL.Calendar.7 on the Access97 computer) produces a "cannot open object"
(or similar) error message when I try to open the form that contains that
control. I've not run into other problems on the 2010 computer (but,
admittedly haven't checked everything out). References appear OK.

Would it make a difference, do you think, if I converted from 97 to
2002/2003, instead of 2000, and then ran the FE under 2010? I haven't had a
chance to try that yet, but thought someone might already know what needs to
be done (other than upgrading my Access at home <g>).

Thanks for any leads.
Mark


0
Mark
6/4/2010 9:29:12 PM
access.modulesdaovba 1670 articles. 0 followers. Follow

3 Replies
1150 Views

Similar Articles

[PageSpeed] 7

The situation you are describing is the exact reason why using calendar 
controls which are dependant on ocx, dll,... are a bad idea as you then are 
faced with versioning issues.

The only way around this is to implement a calendar which does not rely on 
said references...  a calendar such as Allen Browne or Stephen Lebans.  They 
are both easy to implement (1-2 minutes) and very, very reliable!!!  They 
work (in my experience) in Access 2000, 2003, 2007.  For more information see:

http://www.devhut.net/index.php?lang=en&pid=0000000004#datepick
-- 
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Mark" wrote:

> Hi all,
> 
> I still do most of my development at home using Access97. At work, I convert
> the FE to the default 2000 format on a computer running Access 2002(or maybe
> it's 2003, I'm not sure which). I can then distribute that converted FE to
> either Access 2002/2003 and Access 2007 computers and everything works fine.
> 
> Someone showed up with Access 2010 and the Calendar Control that I use
> (MSCAL.Calendar.7 on the Access97 computer) produces a "cannot open object"
> (or similar) error message when I try to open the form that contains that
> control. I've not run into other problems on the 2010 computer (but,
> admittedly haven't checked everything out). References appear OK.
> 
> Would it make a difference, do you think, if I converted from 97 to
> 2002/2003, instead of 2000, and then ran the FE under 2010? I haven't had a
> chance to try that yet, but thought someone might already know what needs to
> be done (other than upgrading my Access at home <g>).
> 
> Thanks for any leads.
> Mark
> 
> 
> .
> 
0
Utf
6/4/2010 10:58:10 PM
Daniel
I was hoping not to have to redesign anything, but guess I don't have a
choice. I have both Allen and Stephen's Calendars for Access97 in my files.
Thanks for the response.
Mark

"Daniel Pineault" <DanielPineault@discussions.microsoft.com> wrote in
message news:B6D26CAA-E2B3-4B10-B6B4-5F921C7A101A@microsoft.com...
> The situation you are describing is the exact reason why using calendar
> controls which are dependant on ocx, dll,... are a bad idea as you then
are
> faced with versioning issues.
>
> The only way around this is to implement a calendar which does not rely on
> said references...  a calendar such as Allen Browne or Stephen Lebans.
They
> are both easy to implement (1-2 minutes) and very, very reliable!!!  They
> work (in my experience) in Access 2000, 2003, 2007.  For more information
see:
>
> http://www.devhut.net/index.php?lang=en&pid=0000000004#datepick
> -- 
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "Mark" wrote:
>
> > Hi all,
> >
> > I still do most of my development at home using Access97. At work, I
convert
> > the FE to the default 2000 format on a computer running Access 2002(or
maybe
> > it's 2003, I'm not sure which). I can then distribute that converted FE
to
> > either Access 2002/2003 and Access 2007 computers and everything works
fine.
> >
> > Someone showed up with Access 2010 and the Calendar Control that I use
> > (MSCAL.Calendar.7 on the Access97 computer) produces a "cannot open
object"
> > (or similar) error message when I try to open the form that contains
that
> > control. I've not run into other problems on the 2010 computer (but,
> > admittedly haven't checked everything out). References appear OK.
> >
> > Would it make a difference, do you think, if I converted from 97 to
> > 2002/2003, instead of 2000, and then ran the FE under 2010? I haven't
had a
> > chance to try that yet, but thought someone might already know what
needs to
> > be done (other than upgrading my Access at home <g>).
> >
> > Thanks for any leads.
> > Mark
> >
> >
> > .
> >


0
Mark
6/5/2010 12:32:11 AM
Daniel,
Follow-up question:
I looked at Allen and Stephen's calendars, but I'm going to really miss the
simplicity of what I have and anticipate many, many hours trying to adapt
one of theirs to look and function like what I already have. I don't need or
want a popup calendar, or one that sets the value of a text box -- just a
calendar that's already open and part of the main form that I open and which
has a number of other controls on it. For example, the type of service that
was provided, the staff person providing that service, etc. Together with
this other information, the user clicks a date on the calendar and then
other command buttons/procedures can refer to the calendar control for the
date value. (Hope this makes sense).

Anyhow, just wondering if there's a reference in Access 2010 that I could
set, or some other techniques, that would allow me to still use what I
already have?

Thanks,
Mark
"Daniel Pineault" <DanielPineault@discussions.microsoft.com> wrote in
message news:B6D26CAA-E2B3-4B10-B6B4-5F921C7A101A@microsoft.com...
> The situation you are describing is the exact reason why using calendar
> controls which are dependant on ocx, dll,... are a bad idea as you then
are
> faced with versioning issues.
>
> The only way around this is to implement a calendar which does not rely on
> said references...  a calendar such as Allen Browne or Stephen Lebans.
They
> are both easy to implement (1-2 minutes) and very, very reliable!!!  They
> work (in my experience) in Access 2000, 2003, 2007.  For more information
see:
>
> http://www.devhut.net/index.php?lang=en&pid=0000000004#datepick
> -- 
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "Mark" wrote:
>
> > Hi all,
> >
> > I still do most of my development at home using Access97. At work, I
convert
> > the FE to the default 2000 format on a computer running Access 2002(or
maybe
> > it's 2003, I'm not sure which). I can then distribute that converted FE
to
> > either Access 2002/2003 and Access 2007 computers and everything works
fine.
> >
> > Someone showed up with Access 2010 and the Calendar Control that I use
> > (MSCAL.Calendar.7 on the Access97 computer) produces a "cannot open
object"
> > (or similar) error message when I try to open the form that contains
that
> > control. I've not run into other problems on the 2010 computer (but,
> > admittedly haven't checked everything out). References appear OK.
> >
> > Would it make a difference, do you think, if I converted from 97 to
> > 2002/2003, instead of 2000, and then ran the FE under 2010? I haven't
had a
> > chance to try that yet, but thought someone might already know what
needs to
> > be done (other than upgrading my Access at home <g>).
> >
> > Thanks for any leads.
> > Mark
> >
> >
> > .
> >


0
Mark
6/5/2010 1:12:25 AM
Reply:

Similar Artilces:

Exchange calendar #4
Hi all Am struggling to solve a straight froward problem. I simply need exchange to notify the users if they book a meeting in the same room at the same time - ie, conflicting appointments?Any ideas how to do this? At the moment getting maoned at as everyone is booking same meeting rooms at the same time - not ideal ! Cheers andyp wrote: > Hi all > Am struggling to solve a straight froward problem. I simply need > exchange to notify the users if they book a meeting in the same room > at the same time - ie, conflicting appointments?Any ideas how to do > this? At the moment g...

Multiple calendars, how to choose which one meetings go into
Hi I have 3 calendars setup in outlook XP , when someone sends me a meeting request how can i change which calendar the meeting goes into, at the moment they all go into what i guess is the default calendar which i want to change to a different one any ideas? thanks Chris You really can't change it. Outlook treats certain folders special. "Chris S" <fred@fred.com> wrote in message news:43cf7167$0$23294$db0fefd9@news.zen.co.uk... > Hi > > I have 3 calendars setup in outlook XP , when someone sends me a meeting > request how can i change which calend...

Can I control linked cell property value in a copied ActiveX contr
I need to copy an ActiveX control approximately 200 times in 1 worksheet (not form). The LinkedCell property value does not change when I copy and paste - so I end up with 200 controls pointing to the same cell. This is a pain to edit. The control is invoked with the following syntax =EMBED("Forms.ScrollBar.1",""). It "smells like I should be able to expose that cell address so a copy might work but I can't find any reference to the EMBED on line or in 6 books. Any help or redirection would be much appreciated. ...

Print tracking tab in the calendar appointment Problem !!
Hi experts, I'm using Outlook 2002 and I couldn't print the tracking tab in the calendar appointment. Is there any way to do that thanks in advance for your help. Rob ...

Upper Case and date format issue
I'm using some code from Chip Pearsons site to convert a range to Upper Case. Sub ConvertToUpperCase() Dim Rng As Range For Each Rng In Selection.Cells If Rng.HasFormula = False Then Rng.Value = UCase(Rng.Value) End If Next Rng End Sub I've noticed that whenever there is a date in the range it "flips" the format. Thus 01/02/2004 is converted to 02/01/2004. Is there a way around this? Many Thanks Andy -- Andy Tallent I'm not seeing that behavior on my XL2000 instance, but if you want to, you can modify Chip's code by changing this line If ...

importing an excel sheet into the calendar
I'm importing a slew of appointments/meetings, actually classes that we have created in an excel sheet. Is there a way to code or map the appointments to have a reminder go off? windows xp office 2003 thanks Meg ...

Linking NumericUpDown control to a combobox
Hi, It there any elegant way of linking a ComboBox with a NumericUpDown so that the combobox.selectedindex is set by the NumericUpDown.value without needing to use code like: Private Sub NumericUpDownCode_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NumericUpDownCode.ValueChanged If Me.NumericUpDownCode.Value < Me.ComboBoxCode.Items.Count Then Me.ComboBoxCode.SelectedIndex = Me.NumericUpDownCode.Value End If End Sub If there any value in: NumericUpDownCode.Maximum = Me.ComboBoxCode.Items....

Repost from Jan 3
I've reposted some tips regarding grouping on the service calendar. Dave's tips below were very useful and I had a question regarding them and figured no one would find it waaay back on Jan 3! Question: Have you found a way to set a particular view as default? E.g., Type = User, View = Users in a Team Also, in case this helps anyone else - I slightly modified Dave's approach below which will hopefully reduce the amount of maintaining 2 team lists as he mentions. What I did was create an attribute (I called it "Team") and added it to the main user form. Then, fo...

julian date conversion
does anyone know the script for converting julian date to a standard date format? preferably dd/mm/yy. thks What's your definition of "Julian Date"? If you're referring to the representation that has year and what day of the year it is (eg.: today's 2004-183), use DateAdd to add the number of days to Dec. 31st of the previous year. You can figure out Dec. 31st of the previous year by using DateSerial(WhatYear-1, 12, 31) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "vic" <anonymous@discussions.microsoft.com> wr...

Outlook Calendar #6
Hi Am using Outlok 2003 in Calendar|Month view. How can I set the view to display the weeks starting day as Sunday and not Monday?? Thanks in advance. Greg Switch to 1 day view and right click in the calendar, select Other Settings and uncheck the box for Compress Weekend Days. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Greg asked: | Hi Am using Outlok 2003 in Calendar|Month view. How...

Loop through textbox controls
Is there a way to loop through all TextBox controls of a FormView and blank them out? Thanks. David David C wrote: > Is there a way to loop through all TextBox controls of a FormView and blank > them out? Thanks. > > David > Yes, you can loop through all the controls on the Web from, check what type of UI control object it is, and address the properties of the UI control object. ctrl.Text = "" if the control has a Text property, as an example. http://dotnetcoderoom.wordpress.com/2009/03/07/traverse-loop-through-all-form-controls-in...

serious OAB issue
Hi, We have two MS Exchange server 2003 (in replica). When we create a user toto (https over rpc) and delete user tata (https over rpc), and after 2 days or more, when we open the address book in Outlook 2003 we see the user toto in the OAB and the GAL, all are OK, but when we download the address book, we see always the user tata in the OAB but we don't see the user toto on the OAB, this is an issue. We tried this action from different machines (Windows XP Pro SP2) and different networks and we experience the same issue. When I check in the server, I see this error occured daily i...

CRM for Outlook Calendar not working
Hi All, I am using Outlook 2003 on my laptop, and the CRM Sales for Outlook is installed and working fine, except for the Calendar. I am unable to create a CRM Appointment and a CRM Contact, but the Tasks, Email, and Promote Email work fine. Any help would be great. As I use a Pocket PC for all of my appointment scheduling. RCWM well, what do you mean its not working?........... -Gary "RCWM" <robmorgan@proactiveit.com.au> wrote in message news:16fae01c44862$fa204430$a101280a@phx.gbl... > Hi All, > > I am using Outlook 2003 on my laptop, and the CRM Sales ...

Reminders remain for an Outlook 2007 calendar that has been deleted
I'm running Outlook 2007 with Windows 7, and I had set up a calendar for my son's school schedule with daily reminders for his classes. I deleted the calendar and foolishly assumed that the reminders would be deleted as well. Is there any way to clear these reminders from my Outlook? Thanks for any help you can offer! EggHeadCafe - Software Developer Portal of Choice Run the command or application in the Security context of specified user http://www.eggheadcafe.com/tutorials/aspnet/1282dcc7-c0a0-4601-87e2-cd97ef257c99/run-the-command-or-applic.aspx Start, Run, outlook /cle...

Printing calendar in Weekly Style, want subject to word wrap.
I'm printing my calendar in weekly style, and if the subject is long enough to reach the end of the box, it just cuts off. How do I set it to wrap instead? "Rypick" <Rypick@discussions.microsoft.com> wrote in message news:AFC41584-C3D8-4666-B17A-07931596AD90@microsoft.com... > I'm printing my calendar in weekly style, and if the subject is long enough > to reach the end of the box, it just cuts off. How do I set it to wrap > instead? Outlook version? -- Brian Tillman [MVP-Outlook] Rypick, this is a common complaint. Two options are: 1)...

Multiple search change calendar view
Hi Here's my problem : I go 2 calendar My view is day/week/month with preview When I do more than one search with the little search (not advanced) box, go to another folder then go back to calendar, view is changed to "active appointements". How can i prevent this ? Thanks Fred ...

Attachment issue
When trying to attach certain files I keep getting this error message: "Can't create file: file.xls. Right-click the folder you want to crate the file in, and then click Properties on the shourtcut menu to check your permissions for the folder." I'm using Outlook 2003 and the File that I'm trying to attach is on my desktop. The file will attach fine if I rename it or use outlook express. Does anyone have any suggestions? ...

CRM Mobile sync issues
Greetings, As of last Thursday, CRM Mobile was successfully syncing on a Dell Axim. For some unknown reason, this week it doesn't sync. I've verified that: - Using Microsoft's Diagnostic tool for CRM Mobile, we can successfully connect to the 3 sites on both the handheld and the server. - The WLAN is disabled. - Nothing has changed on the server side in the last week (certificates did not expire, all CRM services are running). Does anyone have an idea as to why the handheld won't sync anymore? Michael Losapio TwinEngines, Inc ...

Data Conversion Expression returning an #Error
Looking for some guidence on how to get this expression out sick bay! The [Cut_Time] data field comes from a legacy system and may or may not have data in it, may or may not be 0 thru 5 char in length, comes in formatted as text data. The data represents a time stamp of an activity expressed in military time. The goal is to convert it to the DateTime format IF it has any entry at all; IF blank just output a null. CutT_temp: CDate(IIf(IsError(FormatDateTime(IIf(Len([Cut_Time])<1,"",Left([Cut_Time],2)+":"+Right([Cut_Time],2)),0)),"",Fo...

Ungrouping Excel Charts --> EMF/WMF. 2007 can't edit objects as 2003 (freeform big issue). Steve Rindsberg help!
Hi, A "Marimekko/Lasagne chart" is a valuable format that MS does not support. Although several excellent solutions have been developed (S Bullen, etc), they have their flaws. For 2003 I have some great code that disassembles a Stacked Column chart, scales the Category-axis and puts it back together again. This is done in PPT with VBA. There is actually an order for breaking up a chart that I have parsed (in object order: Points, Value axis,Category axis, Point Labels, Value Axis delimiters, Category names and finally the Legend (any comment to this?) 2007 creates problems! (...

Can you import data into an Excel Calendar Template?
Hi, I have downloaded one of the monthly Excel Calendar Templates (http://office.microsoft.com/en-us/templates/TC011646221033.aspx?CategoryID=CT011653371033) .. Instead of adding holidays and birthday data, I would like to populate it with SunRise, SunSet, MoonRise & MoonSet data I have collected in another Excel Spreadsheet. Can you tell me how best to accomplish this task? Thanks in advance for any assistance you can provide. -Greg ...

Removing Weeks at the left in calendar
How can I remove the weeks at the far left when printing a monthly calendar? Having the weeks makes it so that the time of meetings does not show when printing a monthly calendar. Except for the very short abbreviations, there is not enough space to show the time of the meeting. tools, options, calendar options - deselect show week numbers. However, the week numbers will be replaced with week dates (May 16 -22 etc). See http://slipstick.me/calprint for a word template that may meet your needs better. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips...

w32time issue without solution yet
Hi friends, I'm searching on the web about the w32time service issue but until now I haven't found a valid solution, right now I have a lot of Error/Warning on my system log (Event ID 29, Source w32time) mentioning ntpclient with can't obtain the time. Can I disable this service? or where can I review which are the sources of time configured? thanks HB On Tue, 19 Jan 2010 11:21:25 -0800 (PST), herba98 wrote: > Hi friends, I'm searching on the web about the w32time service issue > but until now I haven't found a valid solution, right now I have a lot ...

Create new Sharing Calendar
Hello group, I use MS Outlook with MS Exchange. How create new Calendar (eg. ConferrenceRoomCalendar) and sharing this calendar for selected (all) users? I don't want sharing my Calendar. Thx PawelR Create a new mailbox. See = http://www.slipstick.com/calendar/skedresource.htm=20 --=20 Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for=20 Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "PawelR" <pawelratajczak@poczta.onet.pl> wrote in message = news:d6f7uv$esj$1@nemesis.news.tpi.pl.....

PST File issues
On "old" computer running Outlook 2002. Exported PST file AND made a copy of it with Outlook closed. On "new" computer. Installed Outlook 2002, the ran upgrade to 2003. Tried to do an import from 2002 pst using both the exported one and the copied one, got error " Operation failed. Object could not be found". I noticed the profile created when I did the upgrade made an "old" style pst (ansi). I tried to create a second, unicode pst but the only option I get when I try to create a datafile is to create a "Business Contact Manager...