I am using a switchboard to load a form that I would like to display in
datasheet view or table view. But it does not go into that mode when using
the switchboard wizard to launche the form.
is there a way to set this on the form's load property?
Danny 5 7277
On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hot mail.com> wrote: I am using a switchboard to load a form that I would like to display in datasheet view or table view. But it does not go into that mode when using the switchboard wizard to launche the form.
is there a way to set this on the form's load property? Danny
Just have the switchboard call a macro or a VB procedure that opens the form
in Datasheet view. Works like a charm.
Thanks
how can I call the function with a parameter. Also, where do I put this
function?
"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:7h******** *************** *********@4ax.c om... On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hot mail.com> wrote:
I am using a switchboard to load a form that I would like to display in datasheet view or table view. But it does not go into that mode when
usingthe switchboard wizard to launche the form.
is there a way to set this on the form's load property? Danny
Just have the switchboard call a macro or a VB procedure that opens the
form in Datasheet view. Works like a charm.
Just create a function or macro to open the specific form in question, and
call that macro or function. When you need another one, add another one.
On Fri, 16 Jul 2004 17:08:45 GMT, "Danny" <da********@hot mail.com> wrote: Thanks
how can I call the function with a parameter. Also, where do I put this function?
"Steve Jorgensen" <no****@nospam. nospam> wrote in message news:7h******* *************** **********@4ax. com... On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hot mail.com> wrote:
>I am using a switchboard to load a form that I would like to display in >datasheet view or table view. But it does not go into that mode whenusing >the switchboard wizard to launche the form. > >is there a way to set this on the form's load property? >Danny >
Just have the switchboard call a macro or a VB procedure that opens the form in Datasheet view. Works like a charm.
Actually, an easier way might be to set the form's property sheet on
the Format tab to 'Allow Form View' = False, and 'Allow Datasheet
View' = True.
James
Steve Jorgensen <no****@nospam. nospam> wrote in message news:<7h******* *************** **********@4ax. com>... On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hot mail.com> wrote:
I am using a switchboard to load a form that I would like to display in datasheet view or table view. But it does not go into that mode when using the switchboard wizard to launche the form.
is there a way to set this on the form's load property? Danny
Just have the switchboard call a macro or a VB procedure that opens the form in Datasheet view. Works like a charm.
That would be easier, except it doesn't work. The DoCmd.OpenForm (which is
what the Switchboard uses), overrides any and all form settings regarding what
views to show, allow, and disallow. It overrides these things with its
default values if no parameters are specified, so there is simply no way to do
it with Form properties alone.
On 16 Jul 2004 21:39:02 -0700, dr*********@hot mail.com (James) wrote: Actually, an easier way might be to set the form's property sheet on the Format tab to 'Allow Form View' = False, and 'Allow Datasheet View' = True.
James
Steve Jorgensen <no****@nospam. nospam> wrote in message news:<7h******* *************** **********@4ax. com>... On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hot mail.com> wrote:
>I am using a switchboard to load a form that I would like to display in >datasheet view or table view. But it does not go into that mode when using >the switchboard wizard to launche the form. > >is there a way to set this on the form's load property? >Danny >
Just have the switchboard call a macro or a VB procedure that opens the form in Datasheet view. Works like a charm. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Georges Heinesch |
last post by:
Hi:
I have a tables in relationship to each other. When I open the main
table (table 1), I see a "+" at the very left of every record. Clicking
on the "+" expands the data of the linked table (table 2).
Now ... when I create a form from table 1, I didn't manage show these 2
tables the same way (with the "+" at the left side of every record) as
it was shown as table. Access insists of making a regular form out of
table 1, but accepts...
|
by: Simon Pleasants |
last post by:
Am something of a newbie at this, so please bear with any stupid
questions.
I have created a database to track shipments that we import. The
information is stored in a table and I have created a form which
displays the information from the table. The end users have access to
the form only - this is deliberate.
I have created some queries, including parameter queries, to aid them
which are accessible via buttons on the main form. ...
|
by: John |
last post by:
Hi
I have a small pop non-dialog form that I need to appear towards the right
side of the screen. Is there a way to achieve this?
Regards
|
by: David |
last post by:
Hi,
I need a button shown for each record (cont. form) with specific
captions on each.
I have a notes form for each record. When a user presses the button
they can read the notes. I want to display a caption on the button to
state either "Order Notes" or "READ NOTES".
I placed a label over the button, and depending if the notes field is
|
by: MLH |
last post by:
A97
Am having difficulty displaying graph in Form View that I see fine
in graph control on form opened in design view. I know I'm doing
something wrong.
If I open the form in design view - I see the graph in the graph
control. If I dbl-clik the graph control, microsoft graph opens and
displays the graph fine there too.
| |
by: ConfusedMay |
last post by:
I have a form that content all sales. Right now the default view is single form. the problem is that I can't view the form as a datasheet view when I run the form, even I already specified on the views properties allowed as both. but if I'm on the design view, I can change the view from form to datasheet view, not when the form is load as a startup form. Could anybody please help? Thank you.
|
by: jamjar |
last post by:
How do I change the form view using VB after the form is opened?
I am using the Switchboard pretty much as the wizard loads it. I've tweaked the appearance and a couple of lines of code but I don't want to modify it too much.
When I try to load a form with the properties set to load as Datasheet view only, the switchboard's VB code overrides these settings and loads it in Form view.
Can I use VB in the Form_Open or some other event to...
|
by: Doug |
last post by:
I have a form with a clients info. There is a subform with messages
(date field and a textbox). There can be multiple messages per client.
The row height of the message text box in the subform is set to the
height of one line of text. I want it to display two. Changing the
size in messages table properties, form properties, and in subform
properties (from inside the client form) all have no effect when
viewing the message list from the...
|
by: Alan Forsyth |
last post by:
That rather long subject says it.
In Access97 running on XP - I want to display a Maximized size Form01, then
open a Restore size Datasheet View Form02 on top of the first Form.
PopUp won't give me Datasheet view.
Dialog mode won't give me Datasheet view
I could make Form01 Restore size and expand it to fill the Window in
Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't
want this.
|
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: 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: 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: 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: 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...
| |