Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Deleting row from entry in listbox on a form error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennifer - 30 Nov 2007 18:30 GMT
I am getting an error
Object does not support this property or method

Here is the code i am trying to use
Private Sub cmdDelete_Click()

   If lstData.ListIndex = -1 Then Exit Sub
'    Dim Index As String
   Dim msg As String
   Index = txtDataID.Text
   msg = lstData.List(lstData.ListIndex, 1)
   msg = msg & " " & lstData.List(lstData.ListIndex, 2)
   msg = msg & " " & lstData.List(lstData.ListIndex, 3)
   msg = msg & " " & lstData.List(lstData.ListIndex, 4)
   If MsgBox(msg, vbYesNo + vbDefaultButton2, "DELETE #" & Index & " from "
& cboRation) = vbYes Then
       RemoveItem Index
   End If
End Sub
Private Sub RemoveItem(Index As String)
   Dim found As Range
   Dim ok As Boolean
   With Worksheets("Rations")
   For Each found In .Range(.Range("A2"), .Range("A2").End(xlDown))
       If found = Index Then
           ok = True
           Exit For
       End If
   Next
   End With
   If ok Then
       found.Resize(, 6).Delete xlShiftUp
       LoadData
   Else
       MsgBox Index & " not found!"
   End If
End Sub
Signature

Thank you,

Jennifer

John Bundy - 30 Nov 2007 19:05 GMT
I tried to recreate your form, but i'm not getting any errors. Where are you
getting the error? The only thing that sticks out to me is you show this
If ok Then
       found.Resize(, 6).Delete xlShiftUp
       LoadData
   Else
but don't show the code for LoadData
Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> I am getting an error
> Object does not support this property or method
[quoted text clipped - 33 lines]
>     End If
> End Sub
Jennifer - 30 Nov 2007 19:20 GMT
It is not showing where i am having the error just that i just put that part
in so i assume it has to be in there.

Here is the load data code that works in my update code and lstbox click code.
Private Sub LoadData()
With lstData
.Clear
Ration = cboRation.Value
For Index = 2 To source.Rows.Count
   If Ration = source.Cells(Index, 2) Then
   .AddItem source.Cells(Index, 1) 'id
'    .List(.ListCount - 1, 2) = source.Cells(index, eBoxes.Date1)
   .List(.ListCount - 1, 2) = source.Cells(Index, eBoxes.Ingredient)
   .List(.ListCount - 1, 3) = source.Cells(Index, eBoxes.Percent_of_ration)
'    .List(.ListCount - 1, 5) = source.Cells(index, eBoxes.Ration_ID)
   .List(.ListCount - 1, 4) = source.Cells(Index, eBoxes.Pounds)
   End If
   Next
   End With
End Sub
Signature

Thank you,

Jennifer

> I tried to recreate your form, but i'm not getting any errors. Where are you
> getting the error? The only thing that sticks out to me is you show this
[quoted text clipped - 41 lines]
> >     End If
> > End Sub
John Bundy - 30 Nov 2007 19:28 GMT
Sorry i really can't tell without seeing the sheet, someone here can i'm sure
Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> It is not showing where i am having the error just that i just put that part
> in so i assume it has to be in there.
[quoted text clipped - 62 lines]
> > >     End If
> > > End Sub
Jennifer - 30 Nov 2007 19:33 GMT
Thank you for your time i will keep at it. ;)
Signature

Thank you,

Jennifer

> Sorry i really can't tell without seeing the sheet, someone here can i'm sure
>
[quoted text clipped - 64 lines]
> > > >     End If
> > > > End Sub
Jennifer - 30 Nov 2007 19:36 GMT
Ouch! I found it. i had tried to add this
Me.lblDate = WorksheetFunction.Today()

just before adding the delete button and didn't test it. Obviously it
doesn't work i just wanted a label to fill showing todays date. So small and
it just halts everything.
Signature

Thank you,

Jennifer

> I am getting an error
> Object does not support this property or method
[quoted text clipped - 33 lines]
>     End If
> End Sub
Jim Thomlinson - 30 Nov 2007 20:14 GMT
Try
Me.lblDate = Format(now(), "mm/dd/yyyy")

Signature

HTH...

Jim Thomlinson

> Ouch! I found it. i had tried to add this
> Me.lblDate = WorksheetFunction.Today()
[quoted text clipped - 40 lines]
> >     End If
> > End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.