access 2010 64 bit listview control alternative

MonkeyPie
MonkeyPie used Ask the Experts™
on
I need a neat alternative to the ActiveX Listview control for a 64 bit Access application.  (Listview not available for 64 bit Access sadly.)  

The user needs to be able to click on a line (record) to trigger opening a form for editing current record, and also click beyond the list of records (but still within the control area) to trigger opening a form for new record data entry.

The control needs to be able to hold an image for some flagged records, so a listbox won't do.  I'm considering datasheet subform or continuous subform, but neither will detect mouse click beyond end of list (Listview does this via the listview.SelectedItem=listview.HitTest(x,y) on mousedown event.)

I am willing to consider buying a 3rd party control if it will do exactly what ListView control does.  (can't find one, but have found similar for vb.net)


Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
All can be done in a form. You can add button for a new record

Author

Commented:
Thanks for answer, but I think I didn't make myself clear.  I need to replicate my 32 bit app functionality.  I do have NEW and EDIT buttons that the user can click, but I also need the functionality I described - ie.  User clicks on row to trigger edit mode, or clicks on blank area of control to trigger add new mode.

My main problem with either datasheet subform or continuous subform is how do I detect when the user clicks on blank area?   If I msgbox the record ID on click event in the empty space I will always get the ID of the current record.  So how to unselect the current record in a datasheet or continuous form?

Thanks.
Not a problem to add click as event on a form. I don't understand why you prefer to click on a blank area, when you can have button for it. You have on mouse click on form, but you should calculate - was it in blank area or not. You can create also special control without any visible parts in blank area and use mouse events for this control
Look at example (Double click to edit field; Click on text under form for adding a new record)
Similar events could be used if you like to have subform for editing and adding data. In this case you case set this form visible or not.
DBlist.accdb

Author

Commented:
Thanks for example - but not what I want.  It is my client who wants the functionality of clicking in blank area for add new - not me.  You say "mouse cilck on form - should calculate was in blank area or not" but how do I do that?  Also, how could I 'create a special control and give a  mouse click event".  I have never created a control before.

Thanks.
1. In form's down event (test sample)
2. There is such control in my example (text - Press....)
DBlist.accdb

Author

Commented:
1.  Yes, but this is only in the form footer area - not the rest of the detail area.  This is the 'blank area' I want to use - what I want is for the user to click here and I detect no current record and fire add new pop-up form.
2.  I thought you meant create a whole new control type - not just an unbound text box.

Thank you for your help so far, but I am  still no further along than before.  I don't have a ListView control alternative for 64 bit Office, nor do I have a way to detect a mouse click on blank area of a continuous form (except for the footer as you have demonstrated on your sample db.)

So, for now I am going with a continuous subform, without functionality to click in blank area to add new record.  I've also written some code to highlight current record.  

But I would love to be able to deselect the current record if user clicks somewhere else.  Any ideas for that?
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
AFAIK, there are no ActiveX alternatives for 64-bit Office. Most of the control vendors have not moved to the 64-bit platform, and those that have are almost entirley .NET vendors.
1. In new example you can click on blank area on a form and get message with coordinates.
2. It could be any control

Author

Commented:
Yes, I had got that far on my own. (ie. getting co-ordinates on mouse down event).  Knowing the co-ords doesn't help me detect if on a valid record or not, unless I do some really sneeky code to calc the co-ords of the bottom right corner of last record in list.  BUt I don't know how I would do this.
As you can see in example, clicking on valid record doesn't generate this event. So you can use it without coordinates.

Author

Commented:
Yes - I could indeed do that!  Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial