Recent content by katieb

That has worked a treat! Thanks very much. Kate

I have a database that contains a large amount of addresses. The problem is that the postcode is not always in the POSTCODE field, it could be in 2 other fields. How can I build a query to identify the contents of a cell where it could be in the format: "xx xxx" "xxx xxx" "xxxx xxx" Doing a...

I am new to Lotus Notes and would like to find a tutorial where i can learn about creating databases. I am experienced in other types of database and databases in principle, but have no clue where to start with Notes! Any links to web pages, pdf's etc would be great. Thanks.

We have an applet that is used to authenticate a user with their NT account. The website was recently moved to a new server (and the original one has now been trashed) and on some machines they cannot access the system, either with the notinited error or Object Required. The console log states...

The tables are either in SQL or Access, not a combination of both. So thanks very much for your response - I have had no joy getting this to work and I was after confirmation that it was impossible. Thanks for answering so quickly. Kate

Hi, We have a set of 10 databases which can either run in SQL or MSAccess. We use a script to alter the SQL databases in one go, e.g. Use DATABASENAME alter table tablename1 alter column columname1 varchar(55) alter table tablename1 alter column columname2 varchar(20) alter table tablename2...

Hi, We have a database that books rooms, and we need a query that can determine whether or not any bookings are double bookings. The main problem is the searching for bookings that occur during the time of another meeting. What can we do to bring up a list of bookings based on StartTime and...

Hi, I have a very silly problem that I can't fix. Our Windows 2003 server is running terminal server and the default keyboard layout and date format is US rather than UK no matter how I try and change it. I have tried changing this, but every user that logs in picks up the US settings, rather...

I've got a little further, but when I display the page it says: Expected end of statement /residents/Electoral.asp, line 25, column 50 strSelect = "SELECT FirstName, Surname, DateDiff("yyyy",[dateofbirth],Date()) AS Age FROM tblResident WHERE age>19));"...

Hi, My Code is as follows - I have just put in a SELECT * FROM for now, but this will need to calculate age as of today, and then only display records for people over 18. Dim db Set db = Server.CreateObject("ADODB.Connection") db.provider = "Microsoft.Jet.OLEDB.4.0" db.Open "C:\Documents...

I am trying to display a list of records from an MS Access database of people who are over 18. There is a column in the table called dateOfBirth. I have tried to generate this list, but no joy. How do I write the ASP/VBScript code to do this? Please help, I am a very new newbie and my head...

Can I also ask a stupid question? If Windows 2000 uses Active Directory, what does Windows NT use? I am trying to modify an ASP page that connects using the following lines: Provider=ADsDSOObject Open=Active Directory Provider Connect="'LDAP://ServerName'" The pages work pointing to...