473,698 Members | 2,439 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

gray-out and lock one subform record among many in datasheet view... HOW?



Well, I have the lock part figured out.. but how do I gray-out or put
in some type of visual effect that indicated that the row in the
subform is locked?

Thanks.

Si

Nov 14 '05 #1
1 2648
You can kinda fudge it with conditional formatting on each control, setting
its ForeColor or BackColor so it appears greyed out.

As simpler and more efficient visual indicator might be a text box that
shows a little lock symbol to the left of the locked items. For example, if
wanted to lock all records where the DateEntered field is more than 30 days
ago, you would give the text box these properties:
Control Source: =(DateEntered < Date() - 30)
Font Name: Webdings
Then put 3 characters into the Format property:
semicolon (;)
backslash (\)
hold down the Alt key, and type 0207 on numeric keypad.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<sa****@gmail.c om> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.com.. .

Well, I have the lock part figured out.. but how do I gray-out or put
in some type of visual effect that indicated that the row in the
subform is locked?

Nov 14 '05 #2

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

Similar topics

0
3637
by: Akbarr | last post by:
I'm using JAI for reading Tiff images: black and white, 1 bit depth. I want to scale them to reduce their size, but I want to do antialiasing. If I scale them as they are (using the scale operator) the images remain b/w and no antialiasing is done (I'm using bilinear interpolation). So I'm trying to convert the image to gray before scaling. But an exception raises when trying to do the ColorConvert operation, because "the number of...
2
2533
by: Ken North | last post by:
There will be a panel discussion on March 15 that's a special event at Software Development 2004 -- it's free to anyone who pre-registers for an expo pass. "Software Trends: Marrying SQL, XML, Web Services and Grid Computing" When: March 15, 2004, 5:15 - 6:15 pm Where: Software Development 2004 Santa Clara Convention Center
0
1311
by: Ken North | last post by:
If you are in Silicon Valley on March 15, you might want to attend a panel discussion about the marriage of SQL, XML, web services and grid computing. Admission is FREE if you register online for the Software Development 2004 Expo pass. The panel includes the original enterprise Java architect, the editor of the SQL standard, a co-inventor of XQuery, a leading technology writer, a distinguished database researcher, and a Turing Award...
1
1813
by: susie_richie_30 | last post by:
Hi, I am trying to apply gray scaling to color as well as black/white images. I have tried using the pixel by pixel approach to achieve the scaling. But the particular approach has a issue with high mega pixel images. Is there any other approach that can be applied to achieve the gray scaling and also have a reasonable performance?
6
6649
by: Srinivas Rao \(Rbin/eds2\) | last post by:
HI all, Can any one tell me what the term "gray coding" mean in C programming. with regards, K Srinivas
0
1392
by: Dana Epp | last post by:
I have a ToolBarButton that when I set it to disabled (button.Enabled = false;) causes a really ugly gray masking effect to take place. This is normal and the intended way of the button, but I would like to clean it up. Instead of using the gray mask, I want to use my own grayscaled high quality image. I thought by simply setting button.ImageIndex = new_num; (where new_num is the index of the grayscale image) I could do this. But alas, that...
2
2304
by: allanon76 | last post by:
I need to create an Image with more then 256 gray scale. this is my code, i've some problem setting correctly the pixel value. any idea? There is another way to create an image with more then 256 gray Bitmap myBitmap = new Bitmap(256,256,PixelFormat.Format64bppArgb); BitmapData bmd = myBitmap.LockBits(new
1
3816
by: Sugan | last post by:
Hi all, I'm creating a custom button control. I need to show a color image when the button control is enabled and a gray shade of the same image when the button control is disabled. How can i convert a color image to a gray image in VB 2005. Thanks, Sugan Chennai, INDIA
5
2255
by: MC | last post by:
Hi, I have been looking around for a way to apply the filter that grays out a form or div. I found some examples but the code is pretty complex. Any simple ways to gray that out so I can highlight another form or div? Thanks, Mica PS. I looked at several of the 'easy' examples and they did not work when I applied them.
1
2500
by: michelqa | last post by:
Hi, When creating a new toolStip, the default color is the default blue xp control color... How do I change the blue gradient to a gray gradient ?? I want the exact gray color like the one in VS Thanks!
0
8683
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
8611
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,...
0
9170
Oralloy
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...
1
8904
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,...
0
8876
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...
1
6531
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
4372
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
4624
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2007
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.