We have a database set up to track employees time off that is shared by all and was developed in Access 200 format. I have one person who, when opening it up cannot see the calendar nor a listbox on the form. She had been able to see those until just recently. Everyone else has no problem seeing everything on the form.

Any suggestions as to why and what I need to do so she can?

generally speaking, if it used to work and now it doesn't something had to change in either the DB or on the users computer.

That is what I thought so I tried it myself and had no problem running it.

Any suggestions as to what to check on that computer?

is it a local copy of the front end? if so, the first thing would be to replace the copy.

No, it is the actual database.

you put the actual DB on everyones computer ?

No, it resides on the network where everyone has access to it.

Ok, doing that is a bad idea. Your database should be split into a front end and a back end. Ideally the front end should be on the users hard drive.
We can get to this later as its something that should demand attention.

As for your problem. It should like you are using activeX controls (defo with the calendar, perhaps with the listbox but maybe its not loading because the cal doesn't.....)
Either way those controls have to be installed on the pc in order to use them. If you go through the list of controls available you'll get an idea of what I mean for example I have a control I can add called 'Nv3dVision Control Class', I'm guessing that has something to do with the software involved in my graphics card, if I integrated that into a database and tried to use it you might not have the same graphics card software and then it wouldn't run on your pc.

In point of fact, your current problem could be a direct result of the above. Being in forced retirement, I've been spending 6-8 hours a day, for the past 6 years, cruising half a dozen Access forums and answering questions, and I can tell you that the problems that can arise from this type of configuration are simply unending! The list of those that I've seen posted goes on and on and on! They include timing programs, inability to edit/add Records, inability to open the database itself, and last, but certainly not least, chronic, repetitive data corruption!

The scary thing is that this kind of set up can be used for very extended periods of time, without trouble, but once trouble does appear, it becomes chronic! And the problems, just like your current one, typically do not appear on all machines that are accessing the file. This simply has to be addressed by splitting the database, as indicated above.

Having said that, Access being as perverse as it frequently is, it could be something else altogether! What else resides on the Form besides the vanishing Controls? Is it a Bound Form with data being displayed?

Linq ;0)>

Sorry about no responding soooner, was out for a few days.

The form contains a calendar and a list box that displays the people who have asked for the day off. Everyone has access to it but can only view the information. Only about 5 people have access to add or edit data. Everyone has no problem viewing the database except for one individual. I have checked the options and settings for Access on her machine and cannot see anything out of the ordinary.

Everyone here is running Windows 7 Enterprise and Office 2010.

Any suggestions?

Doesn't really matter if only 2 people actually work with the db, the above still applies. Even if this current problem isn't a result of this setup sooner or later it's going to jump up and bite you in the rump!

When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references. If you haven't checked for this before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Linq ;0)>

I ran the check for references and all the references matched up between mine and the ailing machine. I did discover that when trying to load the form we get an error message "There is no object for this control" and points to the Calendar0.value=Date line.

Below is a copy of the code.

Private Sub Form_Load()
Dim ntsys

ntsys = Environ("UserName")


cmdDateChk.Visible = False
Add.Enabled = False
If (ntsys = "XXXXXXX" Or ntsys = "yyyyyyy" ) Then
Add.Enabled = True
Remove.Enabled = True
End If
Calendar0.Value = Date
Calendar0.Day = Day(Date)
Calendar0.Month = Month(Date)
Calendar0.Year = Year(Date)
List3.Requery
Set ntsys = Nothing
End Sub


Does this help?

Actually, I'm confused by all of this

Calendar0.Value = Date
Calendar0.Day = Day(Date)
Calendar0.Month = Month(Date)
Calendar0.Year = Year(Date)

Value, of course, is a valid Property of a number of Controls, including ActiveX calendars, but Day, Month and Year would also appear to be Properties of the Control named Calendar0, and I am aware of no Properties that go by these names.

But tell me, is this a Bound Form, i.e. does it have a Record Source in the Record Source Property?

Also, are you saying that the Listbox and Calendar are simply not there, which is to say invisible?

Are there other Controls on the Form that are visible?

Linq ;0)>

The Calendar and the ListBox are blank, empty but you see the outline of them. There are other controls visible on the form. the listbox is a bound control to a table and is controlled by the date selected in the calendar. The calendar is an ActiveX control item.

I had the affected person create a new database with a new form and tried to add the Calendar form to it by clicking on Design and the ActiveX Control list. When we went there there was no Calendar Control listed there. I checked my pc and I do have that ActiveX Calendar control showing. That appears to be the problem.

My question now is how do I add that back to her computer and any others that it may occur in the future?

This really does sound like a reference problem. When you say you checked the references explain the process you went through so we can make sure you did it right

I ran the link that was posted above and the references on the affected machine matched mine.

Any suggestions on how to reinstall the missing Calendar control object?

We have it fixed.

What we ended up doing is re-installing Office 2003 and then intalling Office 2010. The activex controls that were missing under Access 2010 originally are now back on that machine. If it happens again, we know what to do.