Search results for query: *

Oops that is an old comment when the routine was a subroutine now it is a function so parameter list should be in brackets ?ADOUserRoster ("C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb") You can also get errors like this in Access if your subroutine has the same name as the...

Replace is an intrinsic function added in Access 2000 and VB6. There are lots of examples that exist on net to maintain backwards compatibility with VB5. Here are some See also http://www.mvps.org/access Function Split(ByVal Expression As String, Optional Delimiter = " ", _ Optional limit...

Just open up a new module. Copy and Plop this code into it Now just press CTRL-G. This brings up the intermediate debug window. Then type in ?ADOUserRoster "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" Replace with the path and name of your mdb and you will see a...

Copy a table's structure using a make-table query SELECT Table1.* INTO table2 FROM Table1 WHERE (((False)<>False));

Try this ' Constants ' 'The Microsoft Jet Provider defines a number of GUIDs 'and property values that are for provider-specific features 'and properties. Because they are provider-specific values, 'ADO does not expose them in enumeration values or constants ' for further info see: '...