ViewEvent

This is a new database in Access and I'm trying to use ViewEvent when double
clicking on a listing in a subform.

The error message is: Sub or Function not defined

I've used this in previous databases though always started with a sample
database so I'm anticipating that something is not loaded.

Any suggestions on how to get the "VeiwEvent" in an event procedure working?

Unless this is something new in v2007, it's ***not*** a native Access
function. From searching the net it would appear to be an Oracle function. At
a guess you would need the appropriate library, but that is just a guess.

What made you think you could use it in an Access app? Have you done so
before?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200809/1

I have used it before in a database that started with a sample supplied by
MicroSoft for registering participants in training classes.

It was supplied through MicroSofts template and sample database area. When I
looke through the database, it was not contained in the Global Module.

When I go to debug in code view and select the Function ViewEvent, it shows
be a list of items to select, would you know what these are called and where
that list is defined?

If it is a user defined function, I'm not sure where to look to find it.



"Linq Adams via AccessMonster.com" wrote:

> Unless this is something new in v2007, it's ***not*** a native Access
> function. From searching the net it would appear to be an Oracle function. At
> a guess you would need the appropriate library, but that is just a guess.
>
> What made you think you could use it in an Access app? Have you done so
> before?
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200809/1
>
>

Below is the Sub with the definition. Thanks for helping to track it down.

Private Sub ViewEvent()
On Error GoTo Err_ViewEvent
If Me.Status = 9 Then
DoCmd.OpenForm "Event", , , "[EventID] = " & Me.EventID
ElseIf Me.Status = 1 Then
DoCmd.OpenForm "Event_pd", , , "[PeopleID] = " & Me.PeopleID
Else
DoCmd.OpenForm "Registration", , , "[EventID] = " & Me.EventID
End If
Exit_ViewEvent:
Exit Sub

Err_ViewEvent:
MsgBox Err.Description
Resume Exit_ViewEvent
End Sub

"Linq Adams via AccessMonster.com" wrote:

> Unless this is something new in v2007, it's ***not*** a native Access
> function. From searching the net it would appear to be an Oracle function. At
> a guess you would need the appropriate library, but that is just a guess.
>
> What made you think you could use it in an Access app? Have you done so
> before?
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200809/1
>
>