473,473 Members | 2,174 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Switching between Continuous and Single Forms



Hi,

I've got a subform which has its default view set to "Continuous Forms".
What I want to be able to do is switch programatically between
"Continuous" and "Single".

I note that most View methods/properties seem to be focused on
Design/Form/Datasheet rather than Single/Continuous/Datasheet. Is it
even possible to switch at runtime?

Thanks in advance for any advice,

regards,
Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
1 3498
jv
Hi Dave,
Set the focus to the subform and then use
DoCmd.RunCommand acCmdSubformDatasheet
or
DoCmd.RunCommand acCmdSubformFormView

Nov 13 '05 #2
Create Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics
2
Changing the current record when using continuous forms
by: aaj | last post by:
Hi all I have a small but rather annoying problem with continuos forms, and am wondering if anyone can suggest a method of getting over it. The front end is Access 2002 with the BE being SQL...
Latest Bytes
2
Singling out fields on Continuous Forms
by: Cro | last post by:
Dear Access Developers, I am developing a form with 'default view' set to "continuous forms". I am suffering with a problem I can't yet see a solution too. Each record has many fields. Two...
Latest Bytes
3
Can I display all the records of a DAO.Recordset in continuous forms textboxes?
by: Richard Hollenbeck | last post by:
I have the following query in my form's code: Private Function Get_Data(fieldNum As Integer) Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset strSQL = "SELECT & "", "" & ...
Latest Bytes
20
Unbound Nested Subform Simulating Continuous Form
by: Robert | last post by:
Need some help to stop me going around in circles on this one.... Have a nested subform (subform2) which simulates a continuous form for the record on the parent subform. Subform2 has rows of...
Latest Bytes
1
Set focus to particular record using Continuous Forms
by: kaeldowdy | last post by:
This one is stumping me! I have a Form/Subform arrangement. The main form is set as a Single Form and the sub form is set as Continuous Forms. On the Form_AfterUpdate event of the subform, I...
Latest Bytes
6
Running Sum In Continuous Form In Ms Access 2003
by: balancetotal | last post by:
Creating a running sum in continuous form in Access 2003 -------------------------------------------------------------------------------- Hello: I have three forms on my user-interface. ...
Latest Bytes
5
Selecting row in continuous form (A2003)
by: Lyn | last post by:
I thought that in an earlier project I was able to click or double-click in the detail section of a row in a continuous form and use the event to open a detail form for that row. However, now a...
Latest Bytes
6
Cascade comboxes in a continuous form won't work
by: yltang | last post by:
I am working on an order system. The following are the tables and forms. (A) Tables: tblOrder: OrderID (PK), CustomerID tblOrderDetail: OrderID (PK), ProductID tblProduct: ProductID (PK),...
Latest Bytes
5
Continuous forms problem
by: grahamib | last post by:
I have a form running in access 2003. The forms property is set to continuous forms so that all records from an underlying query can be diaplayed. On the form are 12 sets of fields from...
Latest Bytes
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Latest Bytes
0
marktang
What is ONU?
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,...
Latest Bytes
0
Changing the language in Windows 10
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...
Latest Bytes
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
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...
Latest Bytes
0
agi2029
AI Job Threat for Devs
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,...
Latest Bytes
1
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
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...
Latest Bytes
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
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...
Latest Bytes
0
transfer the data from one system to another through ip address
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 ...
Latest Bytes
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
Latest Bytes

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us