19f5c Open Report Design View As Hidden
Sign Up |  Live StatsLive Stats    Articles 37,332| Comments 177,279| Members 19,416, Newest Kaylee| Online 560
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Click Here to Register/Sign Up Daily Hukamnama Member Blogs Downloads Website Navigation Help Fonts Tags

Open Report Design View As Hidden

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 500 USD, Received: 115 USD (23%)
Please Donate...
     
Related Topics...
Thread Thread Starter Forum Replies Last Post
changes in Table Design don't take in Form View Rich D Information Technology 4 28-Jul-2006 08:35 AM
Color in Design View Tables JDJones Information Technology 0 28-Jul-2006 08:28 AM
Too many fields error in design view Justin Information Technology 4 28-Jul-2006 08:14 AM
Opening Subforms in Design View David Information Technology 2 19-Nov-2005 22:00 PM
Dynamically change design view from within VB code Jack Information Technology 2 05-Nov-2005 12:48 PM


Tags
open, report, design, view, hidden
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 02-Nov-2005, 11:47 AM
James's Avatar James
Guest
 
Posts: n/a
   
   
Open Report Design View As Hidden

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
Is their a way to open a report in design view as hidden?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6386-open-report-design-view-as-hidden.html

*







Got anything to share on This Topic? Why not share your immediate thoughts/reaction with us! Login Now! or Sign Up Today! to share your views... Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-Nov-2005, 11:47 AM
Ofer's Avatar Ofer
Guest
 
Posts: n/a
   
   
RE: Open Report Design View As Hidden

Try this code

DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386

Good luck



"James" wrote:

> Is their a way to open a report in design view as hidden?

Reply With Quote
  #3 (permalink)  
Old 02-Nov-2005, 11:47 AM
Dirk Goldgar's Avatar Dirk Goldgar
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

"James" wrote in message
news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
> Is their a way to open a report in design view as hidden?


Sure:

DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Reply With Quote
  #4 (permalink)  
Old 02-Nov-2005, 11:47 AM
Ofer's Avatar Ofer
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

Are you sure about this option?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
I didnt get any acHidden option on the OpenReport command line.
On the form Yes, but not in the report


"Dirk Goldgar" wrote:

> "James" wrote in message
> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
> > Is their a way to open a report in design view as hidden?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
>
> Sure:
>
> DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
>
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

Reply With Quote
  #5 (permalink)  
Old 02-Nov-2005, 11:47 AM
James's Avatar James
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

the acHidden is not available for the OpenReport, only the OpenForm

"Dirk Goldgar" wrote:

> "James" wrote in message
> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> > Is their a way to open a report in design view as hidden?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
>
> Sure:
>
> DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
>
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

Reply With Quote
  #6 (permalink)  
Old 02-Nov-2005, 11:47 AM
Ofer's Avatar Ofer
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

Did you have any problem using my suggestion?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
Good luck



"James" wrote:

> the acHidden is not available for the OpenReport, only the OpenForm
>
> "Dirk Goldgar" wrote:
>
> > "James" wrote in message
> > news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> > > Is their a way to open a report in design view as hidden?

> >
> > Sure:
> >
> > DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
> >
> >
> > --
> > Dirk Goldgar, MS Access MVP
> > www.datagnostics.com
> >
> > (please reply to the newsgroup)
> >
> >
> >

Reply With Quote
  #7 (permalink)  
Old 02-Nov-2005, 11:47 AM
Brendan Reynolds's Avatar Brendan Reynolds
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

It works for me, in Access 2003. Perhaps it did not in earlier versions - I
don't have an earlier version installed on this PC, so can't test that right
now.

If it isn't supported in your version of Access, try Ofer's suggestion of
setting the Visible property - it should work too.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386

--
Brendan Reynolds

"James" wrote in message
news:E7D0A2CE-9F12-43BC-AF48-D4D25E21BF30@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> the acHidden is not available for the OpenReport, only the OpenForm
>
> "Dirk Goldgar" wrote:
>
>> "James" wrote in message
>> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
>> > Is their a way to open a report in design view as hidden?

>>
>> Sure:
>>
>> DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
>>
>>
>> --
>> Dirk Goldgar, MS Access MVP
>> www.datagnostics.com
>>
>> (please reply to the newsgroup)
>>
>>
>>



Reply With Quote
  #8 (permalink)  
Old 02-Nov-2005, 11:47 AM
Dirk Goldgar's Avatar Dirk Goldgar
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

"James" wrote in message
news:E7D0A2CE-9F12-43BC-AF48-D4D25E21BF30@microsoft.com
> the acHidden is not available for the OpenReport, only the OpenForm

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386

What version of Access are you using? It's there in Access 2002.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386

(please reply to the newsgroup)


Reply With Quote
  #9 (permalink)  
Old 02-Nov-2005, 11:47 AM
Dirk Goldgar's Avatar Dirk Goldgar
Guest
 
Posts: n/a
   
   
Re: Open Report Design View As Hidden

  Donate Today!  
"Ofer" wrote in message
news:B7919A35-FFE3-4A52-A6D0-8E0732EB5311@microsoft.com
> Are you sure about this option?
> I didnt get any acHidden option on the OpenReport command line.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> On the form Yes, but not in the report


It's most definitely there in Access 2002, as I tested it before
posting.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
How does Sikhi help you...
Today 00:52 AM
31 Replies, 966 Views
Transgenderism ... Right...
By Kaylee
Today 00:33 AM
25 Replies, 1,237 Views
Losing My Religion: Why...
Today 00:00 AM
14 Replies, 364 Views
Occultism - Rejection in...
Yesterday 23:57 PM
61 Replies, 2,612 Views
Woolwich Killing: The...
Yesterday 22:09 PM
1 Replies, 36 Views
Kirtan
Yesterday 21:24 PM
0 Replies, 28 Views
Panjabi
Yesterday 21:22 PM
15 Replies, 299 Views
Keeping Amrit Vela
Yesterday 16:49 PM
12 Replies, 933 Views
Do you believe in...
Yesterday 15:08 PM
196 Replies, 4,105 Views
Black Sikhs?
Yesterday 06:33 AM
20 Replies, 5,864 Views
Man Driving Without...
Yesterday 05:06 AM
5 Replies, 146 Views
Request for assistance...
Yesterday 04:24 AM
8 Replies, 97 Views
Health Exercise And...
Yesterday 02:10 AM
1 Replies, 95 Views
Sikh Spokesman (ਪੰਜਾਬੀ...
Yesterday 02:10 AM
176 Replies, 4,522 Views
How Religions Change...
Yesterday 02:07 AM
1 Replies, 112 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +6.5. The time now is 02:18 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.44906 seconds with 32 queries
0