PDA

View Full Version : Debug Help with a Delete button



vampyrus
06-09-2008, 11:12 AM
Ok I have almost everything working just how I want it now. Except for a slight error. When you select the view all button it shows a record called title and when you select this record it displays all the values in the dvd or video sheet on row 1 which is the column titles.

How can I stop the records from showing this row ?

Bob Phillips
06-09-2008, 11:15 AM
I don't see one called Title.

vampyrus
06-11-2008, 04:52 AM
OK. I just downloaded the file I linked and I do not see the one i was talking about either.

When the database is completely empty of all entries and you use the view all button it shows an entry called "title".
This entry is actually all of the column headers from the "dvd" and "video" worksheets.

Is there a way to stop this from happening?

Charlize
06-11-2008, 05:06 AM
Private Sub cmbViewAll_Click()
If optDVD = True Then
'Count the no of row in dvd sheet
If Worksheets("DVD").UsedRange.Rows.Count = 1 Then
MsgBox "No DVD movies found !", vbInformation
Exit Sub
End If
ViewAllDVD
Else
'Do the same for the video sheet
ViewAllVideo
End If
End Sub
When filling the list with your DVD movies, you start the range at A3 ? Why ?

Charlize

vampyrus
06-11-2008, 07:36 AM
I do ??

Never noticed.
It's not actually my creation ... It was given to me by somebody else.
I have just made some adjustments to the user forms. I'm not very good with code.
Thanks for the code to stop it showing the headers.

I have just changed it to start at A2 instead.