Search results for query: *

It is possible to use some VBA functions in queries. so you can do it by setting the content of your query field as follows. shortDescription: left$([tablename].[description],50)

I'm trying to use the MS datetime picker control to make date selection easy for users (for setting appointments). The control works fine in the sense that I've placed two controls on the form bound each to the date/time field and each updates just fine. However on re-entering the form the...

Which country you in, US or UK... The UK position is straightforward. Under the Public Interest Disclosure Act you must notify your employer first(and keep a record of the notification given in writing). If they fail to take remedial action then, and only then, could you approach the BSA. Fail...

You're better off using a provider that offer's MySQL than one offering Access as porting back to Oracle will be much more straight forward... You could try www.openhosting.co.uk - prices start at £20GBP per year for 20Mb with full ASP,PHP and Access DB support, MySQL is an option at a base...

On second thought's scratch that idea... try the following code Add Dim msgBody as String to declarations Dim myMail Set myMail = Server.CreateObject("CDONTS.NewMail") myMail.From = strEmail myMail.To = List("Email") myMail.Subject = strSubj msgBody = strName &...

Have you tried using HTMLEncode on the the subject and message fields

This would depend, for me, very much on what back-end database is in use, whether you're planning to include a search facility and, if so, what kind. If you've got a decent SQL RDBMS at the backend (such as SQL Server, MySQL, Oracle etc) which supports full text querying (or even English Query...

Slight correction to previous comment - you can do it by writing your own COM object or ActiveX control to do the job, but you'd be daft to try that route.

DAO isn't supported in ASP, only ADO, so the answer to your question is you can't do it.

Steve's advice is absolutely sound - running a testbed/evaluation system is an absolute must as the expectation will be that any transition must appear seamless to the end user. In fact your best case scenario if given the go ahead is if you're users don't even realise you've made the change...

Take out the path information from the OLE DB connection string thus... Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("City.mdb") The Server.MapPath method is already giving you the full path information to your DB, so your original connection...

Yep, you can do it on the client side using Javascript... What you need to process is the 'LostFocus' event.