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
Thanks 7 5969
"aaaaaa" <aa**@ntlworld. com> wrote in message
news:ng******** ************@ne wsfep2-win.server.ntli .net... 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
If you go into design view of the switchboard form and take a look
at the code behind it you will see that the forms are opened using
DoCmd.OpenForm with no argument for veiw type. Since there
is no argument supplied, the view defaults to form view. This is true
even if the form is set to datasheet-true and allow form view-false in
it's own property sheet.
You may have to edit the switchboard code if you want a form to
open in datasheet view.
aaaaaa wrote: 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
Thanks
If it a switchboard you created using an unbound form with command
buttons, you must specify Datasheet view in the OpenForm argument:
DoCmd.OpenForm "FormName", acFormDS
If the switchboard is one created using the Access Switchboard wizard,
there is quite a bit more work you must do. Post back if this is the
switchboard used and I'll dig out the information for you.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
"rkc" <rk*@yabba.dabb a.do.rochester. rr.nope> wrote in message news:<A9******* ***********@twi ster.nyroc.rr.c om>... "aaaaaa" <aa**@ntlworld. com> wrote in message news:ng******** ************@ne wsfep2-win.server.ntli .net... 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
If you go into design view of the switchboard form and take a look at the code behind it you will see that the forms are opened using DoCmd.OpenForm with no argument for veiw type. Since there is no argument supplied, the view defaults to form view. This is true even if the form is set to datasheet-true and allow form view-false in it's own property sheet.
You may have to edit the switchboard code if you want a form to open in datasheet view.
I also would like to know the answer to this. How do we go about
'editing the switchboard code' to make it load in datasheet view?
Terry
fredg wrote: aaaaaa wrote:
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
Thanks If it a switchboard you created using an unbound form with command buttons, you must specify Datasheet view in the OpenForm argument: DoCmd.OpenForm "FormName", acFormDS
If the switchboard is one created using the Access Switchboard wizard, there is quite a bit more work you must do. Post back if this is the switchboard used and I'll dig out the information for you.
It's make more sense, if it's added work, to follow your Docmd example by
placing it into a module as a function and call the Form by running code or a
macro,
"rkc" <rk*@yabba.dabb a.do.rochester. rr.nope> wrote in message news:<A9******* ***********@twi ster.nyroc.rr.c om>... "aaaaaa" <aa**@ntlworld. com> wrote in message news:ng******** ************@ne wsfep2-win.server.ntli .net... 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
If you go into design view of the switchboard form and take a look at the code behind it you will see that the forms are opened using DoCmd.OpenForm with no argument for veiw type. Since there is no argument supplied, the view defaults to form view. This is true even if the form is set to datasheet-true and allow form view-false in it's own property sheet.
You may have to edit the switchboard code if you want a form to open in datasheet view.
I've found a solution! Edit the switchboard code as follows:
Open switchboard in Design View, click on Code in the toolbar, scroll
down to 'Open a form, change the code from:
DoCmd.OpenForm rs![Argument]
to:
DoCmd.OpenForm rs![Argument], acFormDS
This works on my 2K Access.
Terry
Terry wrote: I've found a solution! Edit the switchboard code as follows:
Open switchboard in Design View, click on Code in the toolbar, scroll down to 'Open a form, change the code from:
DoCmd.OpenForm rs![Argument] to:
DoCmd.OpenForm rs![Argument], acFormDS
This works on my 2K Access.
Terry
Instead of messing with the switchboard code Much easier to follow and cleaner. Few people need or want to mess
with the generated switchboard code. And if you even need to rebuild it you may forget to add the DS again.
Salad wrote: Terry wrote:
I've found a solution! Edit the switchboard code as follows:
Open switchboard in Design View, click on Code in the toolbar, scroll down to 'Open a form, change the code from:
DoCmd.OpenForm rs![Argument] to:
DoCmd.OpenForm rs![Argument], acFormDS
This works on my 2K Access.
Terry
Instead of messing with the switchboard code Much easier to follow and cleaner. Few people need or want to mess with the generated switchboard code. And if you even need to rebuild it you may forget to add the DS again.
I meant to say use RUN MACRO or RUN CODE in the switchboard. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Big Time |
last post by:
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...
|
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: davegb |
last post by:
I'm creating a simple, or at least it should be simple, database to
track the employees in our group. I've created a switchboard form, and
want to put a button on it to open the form in which we can add new
employees. It's a simple form with the employee's name (first and
last), phone number, cubicle, title, etc. Some of these fields are
drop-down selections, like "cubicle".
When I try to assign this form to the button in the wizard, I get...
|
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: jnice814 |
last post by:
Hello,
I am trying to build a simple database and have the following questions:
I created a switchboard to be used to open a form where data would be entered. I also set the switchboard as a default in hopes that when I open the database, the switchboard would be the first page to appear. However, this is not happening. How do I get the switchboard to be the first item that appears upon opening the database?
I also need to create a...
|
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: Lewe22 |
last post by:
I have designed a database that loads with a main switchboard in Maximised view. This is important, to fit all the relevant information onto the form.
My only problem is that when opening new forms from the switchboard using buttons or hyperlinks they will always appear maximised as well.
I have tried inserting DoCmd.Restore in the new forms which works to a point, but it not only restores the new form it also restores the switchboard...
|
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: 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: 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: 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...
|
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: 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.
| |