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

Home Posts Topics Members FAQ

Why are my records not displaying in the Switchboard

28 New Member
I've got some Forms and Filters that are opened via a Switchboard when selected. They all work just fine when I open them individually (outside of the Switchboard). The Forms which only have links to reports, open their respective Reports and display the data without issue.

BUT the Forms and Filters which display live data (and allow for the adding/deleting of records) from the Queries show NO data at all WHEN BEING OPENED FROM INSIDE THE SWITCHBOARD. Is there a setting I am forgetting to turn on or alter?

Thanks,
Kris.
Apr 6 '11 #1
6 4198
Rabbit
12,516 Recognized Expert Moderator MVP
There are multiple ways you can open a form. As read only, add new data only, etc. When you set up the switch board, there was an option on how it opens up the form.
Apr 6 '11 #2
FaurKris
28 New Member
I understand that. And as stated, the forms all open just fine. However, the forms which need to show live data (not just a printed report so-to-speak) do not show anything at all when loaded FROM the switchboard. Outside the switchboard, everything works wonderfully.
Apr 6 '11 #3
Rabbit
12,516 Recognized Expert Moderator MVP
I know. And in the switchboard, it is likely using a different open state. When you open a form manually, it opens in full edit by default. In a switchboard, that state is not always the default. You need to change the open state in the switchboard item for that form.
Apr 6 '11 #4
FaurKris
28 New Member
I'm not sure how to change that... All the forms open in Form View.

Shall I post the code for the button clicks?
Apr 6 '11 #5
Rabbit
12,516 Recognized Expert Moderator MVP
There are different states for form views. In the switchboard manager, you can select what state to open the form view in. If you are not using the switchboard manager, then you need to post your code.
Apr 6 '11 #6
FaurKris
28 New Member
Ah-Hah!!
I had everything in Add Mode. Thanks a lot, it works now...
Apr 6 '11 #7

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

Similar topics

1
7244
by: ogilby1 | last post by:
Does Access allow a query to be listed on the switchboard? Does Access allow a table to be opened in datasheet view from the switchboard? I have an application where users enter new data, print reports, (based on a parameter query), and edit previously entered data in form view.
9
3341
by: Baz'noid | last post by:
Hi all, My computer has suddenly decided that it doesn't like the switchboard - it's quite happy to open up on other machines, meaning the database itself isn't at fault, it must be something wrong on my machine. It just doesn't open anymore. Can't figure out why, but i have found a different database gives me this error in a window titled Microsoft Visual Basic instead of a switchboard (an earlier version of the same database), and...
3
3851
by: Cagey | last post by:
What I'm trying for: If this selection or if click on selection (highlighted line choice/ which ever selection change) w/in query's combo dropdown list box (on Switchboard), then Open in Datasheet View, the specific underlying record's Row... showing all columns Or selected columns. For a specific row's record ONLY, Or for all Xs (same type), or for the whole data sheet (all records... includes all types then), but focus still opens...
2
2511
by: asma410 | last post by:
Is it possible to display the file created & file modified information on a switchboard? I have designed the database so that when the user clicks on an icon on the switchboard, a form (linked to a table) with records will be displayed. Whenever the user modifies any record in the form, I want the date & time to be captured & stored on the switchboard. I don't care about the date & time when each record was modified (I have already implemented...
1
1993
by: Lumpy | last post by:
Hi all, I have have been lucky to get some good advice in regards to some access questions I have had so far. The good news is I am almost done with this project but I seem to have hit another bump in the road. I have all my tables designed, I have all my forms made and working, and then I added in a switchboard as a central point of navigation using the default switchboard tool in access. When I open a form up through the switch board, I...
6
8810
by: emrodge | last post by:
I'm using Access 2007 on Windows Vista and am having some problems trying to configure a simple button. There are two tables called Clients and Contacts which are linked on clients.id and contacts.client_id. There are two forms associated with each table and I am trying to create a button to navigate from the Clients form to the Contacts form (which is a split form) but only to display the contacts where the current clients.id =...
0
1706
by: asifu9 | last post by:
Hello all, I am new to MS Access VBA 2007, i need help on how to open a chart form in switchboard. SwitchBoard having options to open a form in Add mode and edit mode, in both of them chart is not displaying. instead its showing text box to enter data on the form. I had attached a image file, please have a look at that. image name 1.jpg--> its showing data when i open this chart form using SwitchBoard Image name 2.jpg-->...
1
1796
by: Kelly Warden | last post by:
I created a dynamic search form and had records displaying to a list box. However I decided to create a Subdata form instead w/ varying tabs. I can't seem to get it to work. In the VBA Code, lstresult used to be the name of the listbox in the form. Now there is a sub data form and I tried just renaming it but it doesn't seem to work. PLEASE HELP! I have attached my database with no records so you can see the code and form as well as...
1
2818
by: Nick H | last post by:
I am having problems accessing full records, (displaying parent and child information) if the child record is empty. I have managed to fix this when showing records in datasheets using queries, using the Left Join, rather than inner join. But... I have a candidate table and a qualification table. Each candidate can have more than one qualification, but can also have no qualifications. I have a Tab control (form) showing candidate...
1
10584
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
10248
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9367
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...
1
7782
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6976
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();...
0
5815
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4446
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
4006
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3108
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.