Sub Show Form () Error

[bbworld]

Hello,

I am a newbie with VBA and have reviewed the previous articles on the Sub Show Form () error I am getting in the attached.

I have followed a learning video and rechecked my content twice yet the same error is presenting.

The workbook is attached and the code in particular that is causing grief is;

Sub Showform()

frmForm.Show

End Sub

I have checked the declaration on the Sub and it matches the code.

Seriously at a loss.

 

[bbworld]

FYI the best way to get help, is to answer the questions that have been asked of you.

But I have... please see the run time error png file I loaded.

 

[Fluff]

I have ran the newer code from @VBE313 and attached are the errors/issues/my newbie oversights.

I asked you what error you got with your original code.

 

[bbworld]

Runtime Error 13 (Google tells me this is a very generic error code)

when you go to debug, it highlighted the code I had entered to show the form.

 

[Fluff]

Ok in the VB editor select tools > Options > General > Check "Break in class module" > OK.
The run the code again, when you click debug it should take you to the line that is causing the problem.

 

[bbworld]

This is the line that was highlighted.

This is in the lesson (checked the video content twice)

Not sure why this has changed from the show.form.

Cheers
D

 

[Fluff]

Remove the space between the counta & the (

   irow = [counta(database!A:A)]

 

[bbworld]

That has worked. Thank you Fluff.

What a huge difference a space makes.

Another QQ if I may?

In the User Details frame, the identifier, I was trying some code to generate a alphanumeric key that is unique. (Say hex, 8 characters)

Private Sub txtPW_Change()

Dim strPassword As String

Dim i As Integer

End Sub

I have this within the frmForm section.

Q1. Would this code generate a random alphanumeric key?

Q2. Is this code in the correct section, frmForm?

 

[Fluff]

That code won't do anything at all, all you have done is declared two variables.
But to get help on that, you will need to start a new thread.