 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / April 2008Command problem with Access XP on a machine with Office 2007
My oldest computer finally died. On it, I'd used Office XP, while I have 2007 on the new computer. All I need from the old one is Access XP, and I only have Office 2007 Standard, so i installed Access only from the CD. After it installed, Word, pp and Excel all started w/o problems. Outlook had an error, so I ran repair and it seems fine. The only problem is w/Access XP. It starts fine and I can see the tables, forms, etc. The problem is that VB doesn't seem to be working properly, I got an error when OnCurrent" ran that DoCmd.GoToControl "Title" wasn't good because ""The expression On Current you entered as the event property setting produced the following error: Object or Class does not support the set of event" This is a command that has run for years, even before XP. It's not the command . In fact, I commented it and the next command gave me the same error. What conflicts do you see between VB XP and an install of 2007 that doesn't include Access? Check your sandbox mode. It should be set on 2 to allow Access VBA code to work with unsafe expressions. Check this registry key: \\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode Chris Microsoft MVP >My oldest computer finally died. On it, I'd used Office XP, while I have >2007 on the new computer. All I need from the old one is Access XP, and I [quoted text clipped - 14 lines] >What conflicts do you see between VB XP and an install of 2007 that doesn't >include Access? It is already set to 2. > Check your sandbox mode. It should be set on 2 to allow Access VBA code to > work with unsafe expressions. Check this registry key: [quoted text clipped - 22 lines] > >What conflicts do you see between VB XP and an install of 2007 that doesn't > >include Access? Check your library references. Are any of them missing? Reset them if they're missing. Is your code not disambiguated, so that it depends on the libraries being in a certain order of precedence? A common problem is to use objects that occur in both the DAO and ADO libraries, forget to disambiguate the code, and just move one library above the other in the references for a quick fix. That isn't a permanent fix. Chris Microsoft MVP >It is already set to 2. > [quoted text clipped - 3 lines] >> >What conflicts do you see between VB XP and an install of 2007 that doesn't >> >include Access? That one lost me. I've never customized any libraries. All I did was, years ago, go to code builder and do very simple commands. There's nothing fancy, they're just very simple data entry forms. Do you have a reference to any sources that tell me what libraries should be linked and where I check their status? Hopefully ones that will describe what the DAO and ADO libraries are... thanx, David > Check your library references. Are any of them missing? Reset them if > they're missing. [quoted text clipped - 15 lines] > >> >What conflicts do you see between VB XP and an install of 2007 that doesn't > >> >include Access? > That one lost me. I've never customized any libraries. All I did was, > years ago, go to code builder and do very simple commands. There's [quoted text clipped - 3 lines] > should be linked and where I check their status? Hopefully ones that > will describe what the DAO and ADO libraries are... The standard thing to do is open Access and create a new blank file and then look at its references. Those will be the defaults with which I have never encountered any problems (either machine to machine or version to version). Some have reported issues with different versions or patch levels in these, but I have personally never encountered that. Compare that list with the references in the file you have problems with. Any more? Any less? If any more you should see if the extras can be removed and still allow the entire project to compile without errors. If it can then you didn't need that reference. Any missing from the default should probably be added. The exceptions to this are the DAO and ADO object libraries. Depending on which version of Access you use to create the new blank file some will have DAO, but not ADO, others ADO, but not DAO, and one version might even include both(?). Not sure about that last. The point being that the developer of a file will normally use one of these two, but not the other so in certain versions that means deviating from the default references. Other than the DAO/ADO issue you mostly want to stick to the default references particularly if you will be sharing the application with other users on other PCs.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I'm sorry, but that added nothing. As I said, i'm looking for references to urls that explain references, DAO and ADO, not a repeat of what Chris was kind enough to say. David > > That one lost me. I've never customized any libraries. All I did was, > > years ago, go to code builder and do very simple commands. There's [quoted text clipped - 26 lines] > references particularly if you will be sharing the application with other > users on other PCs. > I'm sorry, but that added nothing. As I said, i'm looking for > references to urls that explain references, DAO and ADO, not a repeat > of what Chris was kind enough to say. Well, I just looked at what Chris posted and nothing was said about which references you should have. My post does say that (the defaults and nothing else). If you would prefer to see that same information at some web site rather than where you asked the question then I suppose Google is your best option. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Now, you see, on plenty of other support groups, people have pointed me towards the right resources. Why? 1) They know how hard it is to search the knowledgebase 2) They know how difficult internet searches are on basic words such as "word" or "access" 3) They're skilled at their jobs and really do know answers and places where they are answers. They don't think a title proves anything, they use knowledge. You might wish to take some pointers from them. > > I'm sorry, but that added nothing. As I said, i'm looking for > > references to urls that explain references, DAO and ADO, not a repeat [quoted text clipped - 5 lines] > rather than where you asked the question then I suppose Google is your best > option. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.