"HasModule Property = true"

[gpbuckley]

I have imported into my database the browsing form and all seems to work on until I try to copy the VBA code into another form where I want the browse option. I get the message to view in design view (which I am) or change "HasModule Property = true". I cannot see the HasModule" field or reference - can you tell me where on the form I should be able find this.

Link to thread from where the form was found is:
http://www.access-programmers.co.uk/forums/showthread.php?t=97787

Kindly put up there by ghudson (thanks a million - its of great use

)

Thanks folks - very new to VBA and only beginning to really find my way around access. These forums are invaluable to me.

PPS: I have attached a image file showing error message looking for bBrowse and also a txt file with coding for the event procedure property of the onclick field of Browse button.

 

[Trevor G]

The ambiguous name that is shown indicates you have already used that name and can't use it twice.

Would be easier to look at if a sample of the database was uploaded.

 

[gpbuckley]

Hello Trevor G:

Thanks for the help. I have attached the database in zip format. As you will see I am having problems with the forms "general_rev2"; "pcb" etc. Same message.

I really appreciate the help. I have been given this project with the "sink or swim" understandfing!!

 

[Trevor G]

OK I have downloaded your database and via the navigation payne double clicked the form and it took me into the vba screen as you have one of the command button names repeated twice, please see below:

Private Sub bBrowse_Click()
'Private Sub bBrowse_Click()
On Error GoTo Err_bBrowse_Click

If you place a comment (where the green text is shown) at the beginning as indicated here it will then allow you to continue.