Recent content by CodeHammer

Thanks guys. It was the wildcard that was the problem. I was using * instead of %.

The following query: select * from customer where displayname like '*farm*' works perfectly when used inside Access. It returns 44 records. However when the following code is executed SQL$ = "select * from customer where displayname like '*farm*'" Set clsadoRec =...

The following code is an example of how I add a 4 column relationship inside of an access database. Set kyForeign = New ADOX.Key Set cat = New ADOX.Catalog cat.ActiveConnection = axCon kyForeign.Name = "TickFactDT" kyForeign.Type = adKeyForeign...

The following code is an example of how I add a 4 column relationship inside of an access database. Set kyForeign = New ADOX.Key Set cat = New ADOX.Catalog cat.ActiveConnection = axCon kyForeign.Name = "TickFactDT" kyForeign.Type = adKeyForeign...

A few things you might think about. 1) Any numbering system will end up with gaps in it if you allow records to be removed unless you are willing to renumber the entire table each time a record is added or deleted. In that case the record numbering system has little or no value. 2) You can...

I would do it pretty much that way except for the following. 1) I would write a type statement that matches the recordset I wanted to post. 2) I would use update the type statement in the recordset loop. 3) I would use a put statement to write to the file. Good luck

Peter, Here is what I do. When developing your Crystal reports, use an ODBC connection of a specific name to link to the database on your machine. Then when the application is at the client location, use the login information for the application data to generate an ODBC connection of the...

If you have constructed the query in the manner in which you want it to work, simply open it in a recordset, using a server side client. Then you can use the recordset count property to get the number you need.