473,836 Members | 1,364 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

New behavior in Switchboard form

86 New Member
Hi everyone.

I have an access 2002/3 database that I have been using for 4 years with no problem but now, all of a sudden, I get this funny error in the Switchboard that says "error in loading DLL" and it seems to come from the code behind the switchboard form in the FillOptions procedure:

Set con = Application.Cur rentProject.Con nection

I think maybe a recent automatic update to Windows XP might have something to do with this. I googled a bit, and found an article :

http://support.microso ft.com/kb/262847

but this did not help me (even though I am not using office 97 or have never converted anything to anything else!!!

I would be honored if you could help me out, because the database is so huge and the switchboard is quite complicated for me to re-create it from scratch again.

Thank you veryyyyyyyyyyyy y much
Feb 16 '12 #1
6 6447
32,584 Recognized Expert Moderator MVP
No magic wands I'm afraid Ali, but I'd suggest you check on all the references for the Access install before rebuilding the switchboard. As a form, the switchboard is exportable, so exporting, deleting then importing again may be a quicker way than redesigning from scratch.

Good luck with it anyway :-)
Feb 16 '12 #2
86 New Member
Dear NeoPa,

Thank you very much for your reply.

I think I need a little more assistance, if possible, please.

I am still stuck!!!
Feb 17 '12 #3
32,584 Recognized Expert Moderator MVP
I don't think there's much more I can do for you remotely Ali. What did you find when you checked the references? What happened when you tried reimporting the switchboard from the exported files?
Feb 17 '12 #4
86 New Member
I will let you know as soon as possible, because I am out of town now. Thank you very much for your kind attention all the time.
Feb 18 '12 #5
86 New Member
Dear NeoPa,

I checked the references and here is what is checked:

Visual Basic for applications
Microsoft access 11.0 object library
OLE automation
Microsoft DAO 3.6 object library
Microsoft visual basic for applications extensibility 5.3

since I really don't know what these are, I can't say if there is anything wrong with these or not.

I have also tried exporting the switchboard to an empty database, then deleting it, and re-importing it but that was also no good. :(
Feb 19 '12 #6
32,584 Recognized Expert Moderator MVP
If there had been any problems with the references then they would have shown as "Missing". Access flags this up for you. Obviously, you need to check them on the machine where the problems are occurring of course.

I wasn't suggesting exporting the switchboard to another database, but to a file. It may have the same results, but because it has to convert both ways I suspect there is still some point in checking what I suggested. I hope so, as if that doesn't help either, then I don't know what else to suggest for you. You may have to redesign the switchboard again from scratch :-( Not the code though, of course. That can always be copy/pasted across.
Feb 20 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

by: MVM | last post by:
Hi everyone, I am working on an Access project (ADP). I have a switchboard form setup to allow the user to open up another form by entering search criteria in a text box and clicking a command button. Then the form opens using input parameters and grabbing the data in the switchboard text box. My question is this, how do I grab the data from the switchboard form and put a wildcard on both ends of the data when passed to the input...
by: Martin Dennett | last post by:
Hi I'm new to this group so go easy on me! I currently use a database that has had one constant niggle for a while and I was wondering if anybody can help sort it out. From an opening screen there is an option to search for a particular record. The search criteria is entered into a text box. A form is presented over the top of the opening screen with the query results and an option is then given for another search. This results in the...
by: Spook | last post by:
Some of the forms set up within the switchboard do not work if the form isn't maximed, scroll bars don't appear properly. So that the users of the database don't have that problem is there a property setting or macro command that will automatically do it for me. Stephen
by: Sebastian Bargmann | last post by:
Hi, I've run into a weird problem with the form designer. I have three classes: a messagebox class and two forms (Base and Derived which is derived from Base): (note: only relevant code below)
by: amerar | last post by:
Hi All, Here is a weird thing. I was developing a small spplication here in the office. I downloaded an interesting script from here: http://simplythebest.net/scripts/DHTML_scripts/dhtml_script_120.html Basically it gives cool pop-up info messages during a MouseOver event.
by: jmp | last post by:
(I hope this isn't considered too far off-topic.) I work as a developer on a browser product found on handheld devices, and I'm trying to specify behavior for the browser to make it "as compatible as possible" with reference browsers (IE, Firefox, Opera, NS, etc??) when presented with HTML content containing form controls (input, textarea, select/option) in the absence of enclosing form element tags. Obviously in the absence of...
by: joebin | last post by:
I accidentally deleted the switchboard item in form list. Anyone know where I can get my switchboard back? The Switchboard Items in table list is still there. I can also view all the switchboard pages and commands I created in Switchboard manager. But there is no way I can bring the switchboard back. BTW, I am using Access 2003. Anyone got any suggestions? Thanks!
by: Haas C | last post by:
Hey all, Thi question may be simple to most people on this group, but I'm a newbie and can't figure this out. I have created a switchboard form and I've been able to display it on startup of Access. However, I can't get it to start up Maximized. I tried to look through the Form's properties, yet no luck. Any help would be appreciated. Thanks!
by: saurabhpawar | last post by:
Hey guys, I have accidentally deleted the switchboard of the database that I had created. The switchboard form doesn't appear when I click on the Forms section in Access. But heres the deal, when I click the Tools>Database Utilities> Switchboard Manager, the contents of the switch board show up with all the changes . It also allows me to make the changes. I would like to know is there any way to retrieve the switchboard form in the Forms...
by: banderson | last post by:
Hello all, I am hoping that you can help me with a problem that has occurred numerous times on various forms in the two databases that I am working on. When I first add a subform to a form linking child and master fields (primary key and foreign key), the subform will automatically update when the master field on the main form is changed (it is in a combo box). However, when I work more on the form - making it a bit more complicated, adding...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.