473,811 Members | 2,745 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Moveable property locked in Access 2007

19 New Member
Hi,
i am trying to make a report which consists of many subreports, and I need to make the subreports moveable and not show when the subreport has no data.

I use an event procedure in the 'On no data' property:
Private Sub Report_NoData(C ancel As Integer)
Cancel = True
End Sub
but when i try to set the 'moveable' property on the subreport, I can select 'yes' but it pops back to 'No' and i cannot change that....

Do you have any explanation, and7or solution to my issue...? or a better solution than the one i am trying to implement.....? ?
Feb 25 '08 #1
4 6523
Stewart Ross
2,545 Recognized Expert Moderator Specialist
...I use an event procedure in the 'On no data' property:
Private Sub Report_NoData(C ancel As Integer)
Cancel = True
End Sub...
Not familiar with the additional properties of A2007 such as the movable property you mention, but I'd suggest that instead of trying to move the subreport you set its visible property to false in the NoData sub:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_NoData(Cancel As Integer) 
  2. Me.Visible = False
  3. End Sub
  4.  
-Stewart
Feb 25 '08 #2
olseni
19 New Member
Not familiar with the additional properties of A2007 such as the movable property you mention, but I'd suggest that instead of trying to move the subreport you set its visible property to false in the NoData sub:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_NoData(Cancel As Integer) 
  2. Me.Visible = False
  3. End Sub
  4.  
-Stewart

Hi Stewart
Thanks a lot for your help and fast reply, that seems to do the same as the Moveable property..... is still strange that I am not alloved to use it when it is there, but then...
Best regards
Ingrid
Feb 26 '08 #3
olseni
19 New Member
This question is now closed
Feb 26 '08 #4
NeoPa
32,579 Recognized Expert Moderator MVP
Thanks for the feedback Ingrid.

Welcome to TheScripts :)
Feb 26 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2593
by: jcazmail-groups | last post by:
The following snippet gives me an error on the line regarding AllowAdditions = False: Private Sub EditLocked() txtDeliveryDate.Locked = True cmdDeliveryDate.Enabled = False cboidCustomers.Locked = True frmOrdersDesignSubForm.Locked = True ' the following line produces the error
7
4452
by: Andrea Moro | last post by:
I'm writing my first windows control library. A simple textbox with some numeric facilities. Well, there is a strange thing that happen. I want to add a locked property. As many other property, because it's a default property, I must shadow it, but unfortunately, despite the other properties shadowed, for instance tabindex, locked continue to stay in design category also if I set it up to behaviour, and doesn't run my own code.
7
8407
by: Ganesh | last post by:
Hi, I would like to know if there is any way I can forcefully delete a file locked by another process on Windows as well as on Linux. On windows DeleteFile returns me error code 32 (Process cannot access the file because it is being used by another process) Thanks in advance.
15
4117
by: chaseexchange | last post by:
First, a brief explanation of why this has happened. I purchased, what I thought, was a fully functional program written in Access last year from a local programmer. This program was to be used as my POS for an online DVD store. It turns out that what the programmer actually gave me was a "license" to use his software. This was not the agreement we made, and he knows this. He took advantage of the fact that I knew very little about...
4
5487
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available in versions 3.0 or later of the class. However, also just found out that the new Rich Text property in Access 2007 ALSO does not support full text justification! This seems incredible, that MS would create a brand new application, and not...
1
4799
by: tricard | last post by:
Good afternoon all, I have recently been trying my hand out at the ADO model as before I have only used DAO (just thought I would expand my knowledge a bit). The problem I am having is that while I am executing and debugging code, my database keeps getting put into a locked state and I cannot seem to get it out of this state without closing MS Access and reopening it (and this doesn't seem to always work either). I used to have this...
6
9173
by: =?Utf-8?B?SmF5IFBvbmR5?= | last post by:
I am trying to access a Public property on a Master Page from a Base Page. On the content pages I have the MasterType Directive set up as follows: <%@ MasterType virtualpath="~/Master.master" %> On the Master Page I have a public property exposed: Public Property ErrorMessage() As String Get Return txtError.InnerText End Get
3
1499
by: timark | last post by:
Hi All I have an interesting problem that has just arrived. I have an MS Access database created in 95 format which until now would load up with Access 2007 and allow me to change the table and/or filenames. Today I load it up, go to DESIGN VIEW and the fieldnames are LOCKED and consequently i cannot change a filename, add a filename or change its general settings. I would appreciate any help or advice on this one. The database is not read...
6
4516
by: ljstern | last post by:
Hello. I am using MS Access 2003 with XP/pro. I have a form that has the following properties set through the property sheet: form: AllowAdditions = False CartridgeID field: Locked = True The AllowAdditions property is set so that the user can navigate through the records but not be able to begin a new record without clicking the New Record button. The ID field is locked so the user cannot change that field, while still being able to...
0
9726
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10384
jinu1996
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...
0
10130
tracyyun
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...
0
9204
agi2029
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...
1
7667
isladogs
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...
0
5553
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...
0
5692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4338
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
3
3017
bsmnconsultancy
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...

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.