Search results for query: *

I have a field called time, the format is 4:30. I want to convert it to 270 minutes which I would store in the field timeminutes. I am trying to write a trigger that when the record is inserted or updated the timeminute field would be updated with the correct minutes. Thanks, Dennis

All you have to do is add another apostrophy. replace(string,"'","''") example: search for "O''Connell"

Here is an example opening a connection using ADO. Public Sub OpenDB() Dim strDB As String strDB = "c:\db\ww.mdb" 'open the connection Set cn = New ADODB.Connection cn.Provider = "Microsoft.Jet.OLEDB.4.0" cn.CursorLocation = adUseClient...

I used mixed security. Dennis

I cannot register a server. I keep getting the following error: "A connection could not be established to SQL01 - Access denied. ConnectionOpen(CreateFile()).... Please verifty SQL Server is running and check your SQL Server Registration properties (by right-clicking on the SQL01 node)...

I am trying to show a Rich Text File (.RTF) on a web site and when I try to hit it using IE 5.0 I get a challenged response asking for a user name and password. The server will server html, asp, and pdf files not asking for a user name and password. What can I do to fix this. Thanks, Dennis

You will need to run IIS on the server. You can use SQL or Access as the backend they both work just fine. Try this book: Professional Active Server Pages 3.0 published by Wrox ASP is a combination of html and vb script to create the weeb pages. I have never heard about using Access to do...

Is there a function to return the version of the exe that I have compiled? I would like to show the version in my app. Thanks, Dennis

Try this: dim strDB dim cn strDB = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\iweb\dbs\merchant.mdb; Jet OLEDB:Database 'open the connection Set cn = Server.CreateObject("ADODB.Connection") cn.ConnectionString = strDB cn.Open This works for me. Dennis

Have you gotten an answer on this, I am getting the same exact error. I new to crystal reports so I'm not sure I doing it the right way. Thanks, Dennis