Using the Docmd to set another forms detail.visible

cannen

I am wanting to use Docmd to open another form and set the newly opened
forms detail.visible = false to true.

stDocName = "frmVacRequest"
DoCmd.OpenForm stDocName, acNormal 'This opens my form with out problem
but I am unable to set that forms detail property to become visible. I
have reasons that I don't want it visible but I prefer not to go into
those at this time. Any help would be welcomed truely.

Nov 13 '05 #1

Subscribe Reply

3401

Rog

Forms!frmVacRequest.Visible = true

Nov 13 '05 #2

fredg

On 12 Apr 2005 07:51:14 -0700, cannen wrote:

I am wanting to use Docmd to open another form and set the newly opened
forms detail.visible = false to true.

stDocName = "frmVacRequest"
DoCmd.OpenForm stDocName, acNormal 'This opens my form with out problem
but I am unable to set that forms detail property to become visible. I
have reasons that I don't want it visible but I prefer not to go into
those at this time. Any help would be welcomed truely.

1) DoCmd.OpenForm "FormName"
forms!FormName.Section(0).Visible = True

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #3

Similar topics

1968

UI question: using AutoComplete in a broader sense?

by: Pete | last post by:

I'm currently doing a database that uses comboboxes to look up records in other tables, whether they be lookup tables or otherwise. When a user needs to add an item to one of these tables, the...

Microsoft Access / VBA

4268

DoCmd.RunSQL() not reading variable from combo box

by: Richard Hollenbeck | last post by:

Help! I don't know why this isn't working: Private Sub Combo9_Change() Dim UsersCourseSelection As String UsersCourseSelection = Me("Combo9").Value Combo13.Visible = True 'the following...

Microsoft Access / VBA

7540

Export Access table to Excel and format wksht using macro

by: bwhite | last post by:

I have a temp table with one row of data that I need to export into Excel. I created the export to create the xls file as follows ... Dim FileName FileName = !! DoCmd.SetWarnings False...

Microsoft Access / VBA

4898

Using BinaryWrite to output PDF to IE

by: Alec MacLean | last post by:

Hi, I've created a small application for our company extranet (staff bulletins) that outputs a list of links to PDF's that are stored in a SQL table. The user clicks a link and the PDF is...

ASP.NET

21533

forcing a page break in a report using code?

by: Rico | last post by:

Hello, I'm looking for a way to force a pagebreak in code. I'm having a tough time, the first page formats properly until the condition is met and then forces a new page. The problem is, every...

Microsoft Access / VBA

8663

How to run a module using a menu bar

by: jpr | last post by:

Hello, I have created menu bars for my access application and now would like to transfer many pieces of code in modules so that they can run using macros. I beleive this is the only way I can...

Microsoft Access / VBA

2424

Need help with using popup for filtering main form

by: Thelma Roslyn Lubkin | last post by:

I am still having trouble trying to use a popup form to allow user to set filters for the main form. The main form is based on a single table. The popup contains 5 listboxes, so the user can...

Microsoft Access / VBA

6568

Using DoCmd.FindRecord

by: Ben Lahoy | last post by:

Hi! My problem is basically in a search modal window, where the user is allowed to make a selection on which option to take. After selecting an option and then giving the data to search, the...

Microsoft Access / VBA

9060

Error in Access07 when running DoCmd.RunMacro "MyMacro.MacroSub" , 1

by: surferj | last post by:

Hello, I am trying to run a macro in that was created in an earlier version of access but getting an error message when i try to run it in 2007. The error occurs on the DoCmd.RunMacro...

Microsoft Access / VBA

7198

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,...

General

7271

Problem With Comparison Operator <=> in G++

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,...

C / C++

7319

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

6979

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

4998

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...

Microsoft Access / VBA

4666

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...

C# / C Sharp

3160

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

1498

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 ...

C# / C Sharp

730

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP