Search results

No luck. Still i see values in combo

I want to empty the combobox every time when form loads. Using the below code Private Sub Form_Load() combo1.RowSource = "" End Sub But Combobax is not emptying.

I want to empty the combobox every time when form loads. Using the below code But Combobax is not emptying.

I'll send the sample DB

Method importexcelfile() is in standard module and calls first, CurrentFileNameNoExtension will have the value.

I have one method Public CurrentFileNameNoExtension As String Public Sub importexcelfile() CurrentFileNameNoExtension ="Filename" 'do something End Sub I want to use **CurrentFileNameNoExtension** value in **onEnter** event of the dropdown list(**cmvalues**) event. That...

Thanks for the link. I'll follow this next time.

I have figured that it can be done by Set listbox property Multiselect to 'None' and by using the below code to achive this :). Moving down Private Sub cmdDown_Click() Dim sText As String Dim iIndex As Integer Dim bottomLimit As Integer iIndex = lbfNames.ListIndex bottomLimit =...

I've figured that we can do this way. Set listbox Multiselect property to 'None' <CODE> Private Sub cmdDown_Click() Dim sText As String Dim iIndex As Integer Dim bottomLimit As Integer iIndex = lbfNames.ListIndex bottomLimit = lbfNames.ListCount - 1 'check: only proceed if there is a selected...

I didn't try use hidden field. same requirement working on excel, but not with access with VBA. Here s my code for excel list box Dim i As Long Dim leaveAlone As Boolean Dim pos As Long Dim Temp As String pos = 0 With Me.lbLeft For i = 0 To .ListCount - 1 leaveAlone = False If...

I've designed access form with one listbox and added 'up' and 'down' buttons to move up and down the selected item in the listbox. i.e from its selected position to one item up when 'up' button clicked and same as one item down when down button is clicked. Any VBA code will do this functionality?

I've tried all vba listbox methods contains in access

I'm writing code in access vba for the list box selected item to move up and down. Needs to use .List Property in access . But it throws an error says no method or member found. Any replace method with .List ? Private Sub cmdUP_Click() Dim i As Long Dim leaveAlone As Boolean Dim pos As Long...