Microsoft Toolbar Control Version 6

[What-a-Tool]

Is this control compatable with Access 2000?

Can't seem to find the trick to get this control to work.

Have used toolbars in .Net and used the _Click Procedure for the control.

There is no _ONClick method for this toolbar. _Updated doesn't seem to do a
thing. _Enter, _Exit, _GotFocus, and _LostFocus I can get a reaction from,
but these won't do what I want.

AnyBody know the trick to using this control?

Thanks

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

 

[James Mullen (DHL UK)]

All,

Thanks in advance for any help. I have the following simple snippet
....

Sub sCreateView()
Dim cat As ADOX.Catalog
Dim cmd As ADODB.Command

Set cat = New ADOX.Catalog

cat.ActiveConnection = CurrentProject.Connection

Set cmd = New ADODB.Command

cmd.CommandText = "SELECT * FROM tblNew WHERE ID=1"

cat.Views.Append "qryMyName", cmd

Set cmd = Nothing
Set cat = Nothing
End Sub

to create a saved view in code but it doesn't appear in the database
objects (query) window and i can't find the reason in the
documentation i have. Anyone know how to do this?

Cheers,

James

 

[david epsom dot com dot au]

ADOX views don't appear in the Access window because
they can't be run from Access. Access assumes a
slightly different variant of Ansi 92 SQL than ADOX
assumes. The two types are flagged differently. Although
the differences are trivial, there is no easy way
to set or reset the flag.

I think ADOX views are visible in A2K2+.

Use DAO instead of ADOX.

(david)