I have a form that is based on a parameter query that needs to be opened in
datasheet view. I have set the default view to datasheet and disallowed all
other types of views other than design view. When I open the form directly,
after entering the appropriate parameters, the form opens up in datasheet
view.
However, when I access this form through the Switchboard, it always opens
the form in Form view rather than Datasheet view. How can I set the
Switchboard to open the form in datasheet view?
Thanks in advance for any help provided.
Mike
1  1526 
And five minutes after using Google I found the answer. I needed to change
the code in the Switchboard for opening forms in Edit mode to the following:
Case conCmdOpenFormB rowse
DoCmd.OpenForm rs![Argument], acFormDS
By adding acFormDS to the end, it forces the form to open in datasheet view.
Anyway, as you were people!
Cheers,
Mike
"Big Time" <bi************ @remove-for-spam-hotmail.com> wrote in message
news:ce******** **@lettuce.bcit .ca... I have a form that is based on a parameter query that needs to be opened
in datasheet view. I have set the default view to datasheet and disallowed
all other types of views other than design view. When I open the form
directly, after entering the appropriate parameters, the form opens up in datasheet
view.
However, when I access this form through the Switchboard, it always opens
the form in Form view rather than Datasheet view. How can I set the
Switchboard to open the form in datasheet view?
Thanks in advance for any help provided.
Mike
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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!
|
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
|
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?
|
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
|
by: tdmailbox |
last post by:
I am looking to set up a switchboard that doesnt have new forms open as
pop open in new windows like they do as the default
I am looking to make my own switchboard where I have the list of forms
I can open on the left and a box on the right where they open into.
Basicly I am trying to replicate the code that Peter's software uses to
make this form
http://www.peterssoftware.com/abs.jpg
If I make a unbound form on the right called...
| | |
by: robertmeyer1 |
last post by:
Ok.
I am trying to plan ahead on how to make my DB the most effective. I’ve decided to use a Switchboard for this. So I know the basic principles of them as well as how to make 1. What I need help with is a control on it. My DB deals with clients, which will have to have information entered into forms for each 1. There is going to be something like 20 forms? Maybe a little less. I want to make the switchboard have a little button: Enter...
|
by: dwasbig9 |
last post by:
Hi Group,
I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've...
|
by: cephal0n |
last post by:
I have a main table with a unique id, name tblMain this is where I get my unqID, I also made another table named tblClone using the SELECT Update. I have two forms Form1,Form2, 1 command button and textbox named txtTotal. My Form1 is used as a switchboard for my Form2.
in my Form2 I put my textbox and set Me.txtTotal= DCount("","") and
in my Command1 I put my command1 button and set Me.Visible=False to close my switchboard and ...
|
by: geolemon |
last post by:
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...
|
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: 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: 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...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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.
| |
