ListView Control
May 11, 2005Hi:
I need to have a listview (or similar control) with several of the columns being a dropdown list. Does anybody know how I can do this? I have done this in Visual Basic 6.0 but not V.B.A.
Hi:
I need to have a listview (or similar control) with several of the columns being a dropdown list. Does anybody know how I can do this? I have done this in Visual Basic 6.0 but not V.B.A.
In a form, I have a listview control bound to a TreeView control.
By default LV considers "selected" the first item on the list even if it is not highlighted.
In Form is a command button that performs an operation on the item selected, but to prevent accidental activation requires two tests:
1) the list is not empty
Code:
If LV.ListItems.Count = 0 Then Exit Sub
2) an item is actually highlighted.
How can I make the second test?
I'm having trouble finding any useful documentation on the ListView control. I'm using Access 97. If you know of a good source for this, please reply.
I have two specific questions, too:
(1) Is there a way to access all the selected items in a multi-select ListView without having to loop through every single item? (Something similar to the Access ListBox control's ItemsSelected property would be nice....)
(2) Is there a way to deselect all items without having to deselect each one individually?
Hi,
I have added a listview on a form from ActiveX control. I am not able to add items to it. I do not get the ListITems.additem when I press dot after listview control name. Please help
hi
Good Day!
anybody here who can help me on how to fill in data in the listview object in MS Access programming, I just want to know in filling up data in each rows and column , as what I know in Vb6.0 its different...
Thanks
Hello all,
I finally got TreeView to work, by downloading the example database from this (http://www.access-programmers.co.uk/forums/showthread.php?t=80805&highlight=treeview) thread. I haven't had as much luck with ListView, though. Does anyone have a database they could post that has a working listview? I'd greatly appreciate it!!
Thanks,
Eric
This is driving me crazy! I have some code that has a list of items in a listview. When I right click it shows a pop-up right click menu with a macro. Then I select an item in the list that says Rename. After ensuring a single element is selected the StartLabelEdit method is called on my list view. Then I can begin editing. Normally this works fine. However, if I first double click a list item. Then I enter my double click list view event handler and from there I open a form. Later if I close that form and then try right-clicking and selecting rename. This time after StartLabelEdit is called, the BeforeLabelEdit event is never called. The whole selected line blinks momentarily and then wherever my cursor is at that moment every item between it and the originally selected item becomes selected. If I move my mouse around the selection changes to be between the originally selected item and the one my mouse is over as it moves. It's as though I had clicked the left mouse button down but didn't let go of it and then started moving the mouse around. If I left click and release again it seems to get out of this mode, but I am still not able to ever manually invoke the StartLabelEdit method after this point. If I close the form and re-open it, it works fine. (I've tried calling refresh on the list view but this had no effect.)
Here's the really weird part. If instead of double-clicking to open a form, I right click and select a menu option to call the exact samed double click event method. Everything works fine as you would expect. Then I tried another test. I made the double click method call another method to open the form. When I did this and tried the same alternate way of opening a form, it did not work and the same original error occurred again. This weird behavior is bizarre and I have no real idea how to troubleshoot it any further.
:mad:
Has anyone ever seen or heard of something like this where StartLabelEdit goes haywire? Please help me if you can.
Thanks...
-Will
I added a new field to one of my tables and query, but when I try to add a control for that field into my form it is not recognising it and the field isn't appearing in the sources for the form, even though the table is sourced to the form? Or am I going to have to do the usual and redo the entire form because I made a minor adjustment?
View 1 Replies View RelatedI have a form with a tab control, inside the tab control I placed an ActiveX control (Microsoft Web Browser). These are at the bottom of the form.
Everything displays fine if the entire form fit on the screen but if the form is too long and I scroll down the browser control is getting obscured by the tab control and getting chopped off (the contents are covered). It is as if the browser control is staying in space where it was and moving behind the tab control as I scroll.
This problem does not occur if I place the browser control directly on the form. Also I note that the browser control is sitting correctly within the tab control.
I have been through all the settings and properties of both controls and haven't been able to fix it. I searched all over the web but no one has previously stumbled across this one by the look of it.
See the attached image ...
I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.
I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.
I have added form controls for modified fields in the past so I am confused about why this is happening.
OK. I have searched and searched and every thread dances around similar situations but none seem to address this particular one. I am trying to make a control on a sub form visible/not visible depending on the condition of a control on a main form. The catch is that the control I'm trying to change the state of is on a subform located in a tab control. I've tried a thousand combinations and none seem to work. How do I reference the control on the subform in a tab control?
Main Form: frmMemberMain
Tab Control: TabCtl12
Tab Control Page: 2
Subform: frmChildren
Control on subform: txtRelationship
Can someone please help before my brain explodes!! Thanks! :eek:
Hi,
I have reviewed the posts for 'Control Validation' and dowloaded the sample database kindly posted by ansentry.
In the PaymentAmount example, a name has to be entered in the first control before an amount is enterered in the second control. If the controls and tab order are reversed, the validation doesn't work.
I have a form where the 1st Control needs validating before moving on. The code below doesn't work.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Employee_No) Then
MsgBox "Employee No Required", vbCritical, "Data required "
Cancel = True
Me.Employee_No.SetFocus
Exit Sub
End If
End Sub
Any help greatly appreciated.
John
Hi,
I have used a tab control to create some forms. However, I can't modify or delete any of the information. It's seems like the forms are just read-only.
How can I change it so that I can modify and delete info please?
Thanks in advance.
Hi all,
I am creating a DB using tab controls, I have my information in each tab section. When I come to view in Form View and move my mouse around the tab page it shudders for some reason? anyone know why and how i can fix it?? Thanks:confused:
I would like to be able to add a tabbed control to one of the pages of a tab control. I have made several attempts and it hasn't worked. There is no reference to it in MS help. I have seen many databases with this facility (not necessarily MS Access). Can anybody offer a suggestion please.
Peter
I usually use wizard for creating forms only now I need to have tabs for quite a few forms.
I've recently discovered that you cant simply put your labels and field on a page then select another tab and put other labels and fields on. I've tried looking frmSampl provided by microsoft put cannot figure out hows the single form with tab control on it works.
Can anyone direct me to online help with forms or provide any help with the tab control tool?
I want a Command Button on a form to move to the next Command Button. I basically want to do the same thing as the Tab button on my keyboard. However, I do not want to use the keyboard.
View 5 Replies View RelatedWe have just been upgraded to '03 and while poking around noticed that the tab control changed a little. The main diff was the active tab is slightly easier to pick up because of the highlight line (See attachment). Does anyone know of any other changes in the newer version in the tab control or any other control?
View 6 Replies View RelatedThis seems like it would be easy enough, but I can't seem to find an answer. I'd like to put a tab control on one page of a main tab control. I've tried to select the page and create a new tab control and cut and paste existing tab control, but in both cases the tab control pastes into the detail section of the form (where my main tab control is) and thus appears on all pages. Anyone know what I need to do? Thanks for any help.
View 3 Replies View RelatedI have added tab controls to my already created form. My original page sits there alone, not on a tab control. How do I put it on a tab control without having to re do everything??? I tried to put it on a tab/page and it lost all the lable names and changed it to numbers.
View 4 Replies View RelatedDear All,
I'd like to bar (make unable to use ) a combo list on my form. The state of the combo list should depend on the true/false state of a checkbox.
I don't know whether it is possible in access.
I'd like to ask for your help.
Thanks in advance.
BR,
Sz.Cs.
A simple question. I have tried to add Tab Control(s) in another tab control but those added tab control added in one particular tab control are shows on all tab controls in the same forms. Is it MS Acess limitation or I just don't get it done correctly?
View 3 Replies View Relatedi have a simple freeware ftp control i use on my machine at work. i need to distribute an app with ftp capabilities, though, and don't want to go to 50+ machines and put this .ocx on them all. my IT department may frown on that also. so....was wondering if anyone knew if there is any ftp support with microsoft .dll's or .ocx's. basically i need something i could reasonably expect any user to have readily available on their machines already.
thanks in advance for any help...
john
If this issue had been addressed before, please direct me to the thread; otherwise please help.
I've created several TABS on a form. Each tab contains several drop down lists.
I've also put a field above the tabs for displaying the choices that I make on the various tabs, BUT I can't get the choices to display in the field above the tabs.
Can anyone help?
Just wanted a little help please. I have about 100 option boxes on a form and I want to be able to change the names of the option box and its label. I want to name them from 1 to 100 sequentially. (i.e. option1, option2 ...).
When I create the controls it automatically names them option0, option2 etc. and label3, label5 etc.
I was going to change them via some code but I don’t know how to refer to a control in a form from design view.
Can anyone help please?
Thanks
Red
I would like to use a Next button instead of having users click the tabs. Can this be done eaisly? Please help
Thanks