I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top
of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.
How can I learn this?
TIA
- Turtle 4 5239
Datasheet view is just a view. It doesn't expose sections like that.
If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.
--
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.
"MacDermott " <ma********@nos pam.com> wrote in message
news:Hz******** **********@news read3.news.atl. earthlink.net.. . I have an Access 2000 form with a subform in Datasheet view. When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the fact that I'm clicking in the header and not somewhere in the detail section.
Thanks, Allen!
My client wants to be able to order and size the columns -
I'd hate to have to program THAT functionality in Continuous forms.
I've found that I can check the y value on the MouseDown -
if it's less than 255, I'm in the "header".
I still haven't figured out the question in my other post, though.
Even if I set the application's Shortcut Menu to my custom menu, when I
right-click on the "header" of the subform, I get the default shortcut menu.
Any ideas on that one?
- Turtle
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:3f******** **************@ freenews.iinet. net.au... Datasheet view is just a view. It doesn't expose sections like that.
If you work in Continuous Form view, you can detect that the label you clicked on is in the Form Header section.
-- 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.
"MacDermott " <ma********@nos pam.com> wrote in message news:Hz******** **********@news read3.news.atl. earthlink.net.. . I have an Access 2000 form with a subform in Datasheet view. When I click on an item in the header of the subform (the title at the
top of one of the columns), I'd like to be able to capture the fact that I'm clicking in the header and not somewhere in the detail section.
Nah.
Actually I rarely use datasheets, precisely because the client can resize
and hide columns. Ever had users asking where the column has gone, and how
to get it back?
"MacDermott " <ma********@nos pam.com> wrote in message
news:al******** **********@news read3.news.atl. earthlink.net.. . Thanks, Allen!
My client wants to be able to order and size the columns - I'd hate to have to program THAT functionality in Continuous forms. I've found that I can check the y value on the MouseDown - if it's less than 255, I'm in the "header".
I still haven't figured out the question in my other post, though. Even if I set the application's Shortcut Menu to my custom menu, when I right-click on the "header" of the subform, I get the default shortcut
menu. Any ideas on that one? - Turtle
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:3f******** **************@ freenews.iinet. net.au... Datasheet view is just a view. It doesn't expose sections like that.
If you work in Continuous Form view, you can detect that the label you clicked on is in the Form Header section.
-- 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.
"MacDermott " <ma********@nos pam.com> wrote in message news:Hz******** **********@news read3.news.atl. earthlink.net.. . I have an Access 2000 form with a subform in Datasheet view. When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the fact that
I'm clicking in the header and not somewhere in the detail section.
Al*********@See Sig.Invalid (Allen Browne) wrote in
<3f************ **********@free news.iinet.net. au>: Actually I rarely use datasheets, precisely because the client can resize and hide columns. Ever had users asking where the column has gone, and how to get it back?
Why not have the form set all columns to a certain width in the
datasheet's OnLoad event? Then if the client has the problem, they
can close and then open the form to see all the columns.
I don't use datasheets much, either.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: ivan |
last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within
that subform is another subform (OrderDetail). That subform (OrderDetail) is
displayed in Datasheet view. When I am entering customers and their
respective orders, the first order entered is fine with the "tab" field
orders correct. On the second and subsequent orders, when I go from the
Order form to the subform "OrderDetail", the curser goes to the wrong field...
|
by: wayne dooley |
last post by:
This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform
to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully, except
I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back...
|
by: Matthew Wells |
last post by:
I have a a parent form with a subform. The parent form has two command
buttons to change the subform view to single form view and datasheet view
respectively. I can't seem to get this to work. There is a menu item to
switch to datasheet view, but it won't go back to form view. The only way I
see so far is to open the subform by itself in design view, change the
default view, save & close, then set the sourceobject property in the main...
|
by: Mason |
last post by:
This is probably an incredibly newbie-ish question. I just haven't
had the cause to use many subforms before, so I'm pretty sure I just
don't understand it correctly (even after reading up on it).
I have a relationship set up that is used to track the hours an
employee has worked on each project during the week. I'm trying to
set up a Form to allow someone to choose their name and a Period
Ending date (basically, the tblTimeReport...
|
by: Gary T. |
last post by:
I have a subform (that is linked to a table) in a blank form.
When the table is viewed in its subform state in the form, the headings are
not user friendly.
ie. CustN
I would want it to read in the subform heading column as Customer Name
without affecting the actually field heading in the table itself..... if
that makes sense.
Any suggestions?
thanks
| |
by: Smartin |
last post by:
Using Access 97
I am trying to create a form that allows for user entry of search terms
and displays a table of results. I thought I could accomplish this using
a subform but it isn't quite doing what I want it to do.
What I have so far:
Fields to enter search terms
Subform bound to a query
|
by: Thomas Zimmermann |
last post by:
I have a form with a subform in datasheet view. Now, I want to trigger a
procedure (P1) each time the user selects an entire column (by clicking in
the heading) in the subform. The procedure (P1) I want to trigger needs to
be called with the selected column as a parameter.
As far as I am aware, there is no event procedure for clicking in the
heading of a datasheet. So insted I need to start by having an other
procedure P0, which is...
|
by: Ken Mylar |
last post by:
First a quick background on the form:
I have a form that is normally viewed in Single form mode. It has a
subform on it that is in datasheet view. The main form is for work
orders and the subform is for parts used on the work order. On the main
form I have a LaborTotal (from main form), PartsTotal (from subform)
and TotalCost (which is Labor + Parts). All works fine as is.
Now to the question:
I have a button on my main form to browse...
|
by: Orv |
last post by:
I have a search form which contains a non-linked subform. When I fill the
criteria of my search and click the search button it returns the results in
the subform, datasheet view.
I then want to select/click on the row (record) on the datasheet and have
that record pop-up.
Any ideas?
TIA,
|
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...
|
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,...
| |
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...
|
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...
|
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...
|
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...
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |