Split form event error

[witooldas]

Hi there,
I have a problem with split form. Form displays information and blow it displays date from the query. Now I want to create a button which will show me simple alert window with VB help.

Code:

Sub CommandButton4_Click


MsgBox "Test"
End Sub

When I click button access throw error window, which tells me some thing about OLE server or ActiveX problems.
What it can be? Thanks.

[jgelpi16]

Is that a straight copy/paste from your VBA code? If it is I believe your code needs to look as follows:

Private Sub CommandButton4_Click()
MsgBox "Test"
End Sub

[witooldas]

Sorry for that code... Yes, i use Privete Sub

Is that a straight copy/paste from your VBA code? If it is I believe your code needs to look as follows:

Private Sub CommandButton4_Click()
MsgBox "Test"
End Sub

[jgelpi16]

And you are still getting the same error message? Do you have "Option Compare Database" at the top of your VBA code? Try this...

MsgBox "Test", vbOkOnly

[witooldas]

Hmm... i was trying to do new database... but now i even can't run VB to write code... it tels me that "Microsoft Office Access ar failed to create Visual Basic module"

Maybe some property variable are set as false or blank?

[jgelpi16]

Whoa, I'm not sure what is going on now. There may be something wrong with Access itself? What version are you using?

[witooldas]

hmmm.. Microsoft Office 2007 but what is the version is i don't know where i can look

[pkstormy]

If this happens on every new accdb, I think you need to re-install office since it sounds like something corrupted shared resources (possibly another corrupted type of visual basic installation when installing another program). Either that or there's something you've left out telling us in your posts.

You can also try creating some vba code in Excel and see if you get the same error. If so, re-install office.

Did you install office from a cd or from a shared network drive? Did you remove any older office versions or keep them on the computer or did you upsize a previous version? When installing office, were there any components set to run from the cd versus 'my computer'?

[witooldas]

Hmm.. In excel VBA working perfectly.. I thing problem was in the table. Now I again can create module, but still throwing error with "OLE server or ActiveX problem". When I creating new database with blank form and with VBA help I can throw "Alert", but in mine database I can't. Maybe it because I using "SharePoint" (one of table are in the server).

O had an experiment, I took that table which in the server and export it like table with records to the database. But it still throw that error with OLE server or ActiveX.

If this happens on every new accdb, I think you need to re-install office since it sounds like something corrupted shared resources (possibly another corrupted type of visual basic installation when installing another program). Either that or there's something you've left out telling us in your posts.

You can also try creating some vba code in Excel and see if you get the same error. If so, re-install office.

Did you install office from a cd or from a shared network drive? Did you remove any older office versions or keep them on the computer or did you upsize a previous version? When installing office, were there any components set to run from the cd versus 'my computer'?

[witooldas]

3 days and 3 nights i was testing form and what i found:
When i insering objekt's in form all buttons with VB code working perfectly, but when in form design u trying to create "Form name" ir insert "Logo" then all buttuns not working.

Maybe some one know how to change some property variable, to make it work with logo ?

[witooldas]

i Solved that problem i then Visual Basic > Tools > Refences i had to select "OLE" And "ActiveX" options

Thanks