473,809 Members | 2,809 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Switchboard stops my forms' VBA code from working?

geolemon
39 New Member
I have several forms that I've built...
Most of them have some sort of VBA code built in somewhere, like:
  • Select a record with the key-value control, and the rest of the controls position to that record
  • "OnChange event: Set <that> bound control equal to the value of <this> unbound control"
  • ...etc.
Straightforward stuff. The record positioning code was created by Access's wizard for creating a combobox, for example.

These forms work perfectly when I launch them from the Database window.

However, I just created a switchboard, and when I launch them from the switchboard, the forms no longer work properly -for example, if I select a key value, the remaining controls remain blank.

Is there a simple reason?
I hate being new to this... I just must be missing something simple and obvious, because a switchboard is designed to launch these things (and reports, etc), correct?
Sep 9 '08 #1
1 1500
missinglinq
3,532 Recognized Expert Specialist
For starters, when you say you "created a switchboard" arer you taliking about one made with the Switchboard Manager or a regular form you've created to act as a switchboard?

Welcome to Bytes!

Linq ;0)>
Sep 9 '08 #2

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

Similar topics

13
5835
by: Mark | last post by:
I am looking for a switchboard creator alternative for my MDB. Can anyone help me? Thanks for your help, Mark
2
6585
by: Dejan M. | last post by:
Can you help me? I have 9 forms in the base. 2 forms are opening as single and 7 as datasheet. Thats OK, but when I used Switchboard manager, with him all of my forms are opened as single. How can I solve this problem. Thanks!
7
5969
by: aaaaaa | last post by:
Hi, I created some forms and during the wizard I chose the Datasheet View, and when I open the forms from the main objects window they open up in datasheet view. But when I created a switchboard which opens the same form it doesnt load them in datasheet, it loads them in other, columnar (me thinks), view. Is there a way to make the switchboard load these forms in a simple datasheet view
2
2174
by: Terry | last post by:
I have created a switchboard, created using Access 2000. If I put the mouse anywhere on the form, outside of the checkboxes and scroll the wheel backwards, I get the following error. Run-Time Error '-2147217900(8004e14)': Syntax Error (missing operator) in query expression in '>0 and =' I know that the Switchboard probably doesn't cater for this event but sometimes you can't help twiddling the wheel can you?
1
4529
by: jimwlee | last post by:
Hi all, I mistakenly deleted my switchboard on the Object Forms view. I recreated it again with the database utility, but the switchboard isn't showing up in the forms view. Any ideas? Thanks in advance. Jim Lee
2
13981
by: tdmailbox | last post by:
I am in the process of finishing up moderate sized access database application. I am in the process now of building a switchboard to house all the forms and reports. I decided the in built in switchboard manager will not do what I want so I was thinking of just buiding my own form. However, I was wondering is there any prebuilt switchboards or switchboard templates out there? I found one that I like
8
5622
by: Ray Greene | last post by:
I was working in Access and everything disappeared from the screen. When I closed and reopened the file there was no switchboard. I can open tables and forms etc if I select a category from the View > Database Objects menu, and use the up/down keys and the Enter key, but I can't see what it is I am about to open. I was able to replicate this with another database by moving the switchboard up past the top of the screen and scrolling up to...
1
2687
by: mplus_2000 | last post by:
I have recently inherited a database. The switchboard (and other forms) displays the name of the database on it (top, center). Currently the name that appears is Reviews. There are plans to roll out the application (i.e. making copies of the database) to other locations (Reviews-NY, Review-Dallas etc). If was mentioned today in passing by the original developer that there is a way to change the title that appears on the switchboard without...
7
4787
by: Mattic | last post by:
Hi guys, I'm fairly new to access, with the help of this site and google I've managed to find my way around (even dabbling with some VB too) but there's something that's got me stuck. I've got my DB working great, it's got the standard switchboard generated via the switchboard manager. I've got a load of forms and reports on there so I'd like to use a combo box to open up my forms rather than the buttons. For example I've got five forms I'd...
0
9721
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9602
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,...
0
10639
Oralloy
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...
0
10376
jinu1996
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...
1
10383
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,...
0
9200
agi2029
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...
0
6881
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();...
1
4332
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
2
3861
muto222
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.