Recent content by joolsUK0575

Hi What I want is for the new data to appear in a new column I know that the query will start out as PeriodOfTime: Iif ([application_type]........... But from here on in I get stuck because of the parameters:(

Hi there I am having problems with an IIF statement and I was wondering how I can get the query that I need to work. I have the following columns application_type: this has three values in it - Major, Minor and Other numberofdaystodecide: this is the number of days taken to decide a file...

Hi No Frills Yep. Both are examples of what I have in my database I have Excel 2003. I am reluctant to take the addresses out of the database as it is a LIVE database.

Some of them are and some are not

Hi there I have a database that has some data in it from an old database. This data has been converted in to the new database (many years ago) and subsequently it has gone a bit astray. Basically my problem is this. My current database has 6 address fields in it. At the present time all...

OK. Buggered up! Tried putting this in to a table that is a linked table from SQL Server. Didn't save it! Anyone know how to get this html in the default value of the SQL Table itself?

I want something along the lines of <img src="Images/Key/reddot.gif" width="24" height="24"> This would be automatically placed in to the column each time a user generates a record. The database is being fed out on to the web which is why I want this to happen. Thanks for the help so far

Hi there I need help in a problem that I have and I "think" that VB may be able to help in resolving it. What I need to be able to is as follows: When a user creates a new record within a database a specific piece of HTML will be automatically written in to a column. How in the heck do I do...

Thanks. Worked like a charm :D

Hi there I have some information in a database that I need to make sure sure is correct. There should be 11 characters (numbers, text and items such as /) within this particular field. I know that there is a number of entries that either has more or less than the 11 characters in this...

Um. Now you lost me :confused: What do I do with that and where do I put the code?

I am using asp.net to try and achieve my aim

nearly. But what about the single quotes. Will this still render a hyperlink on the web page or will it cause it to fall over?

Hi Bat17 Nearly When someone creates a new record I want the HTML automatically put in to the required field. The reason for this is the contents of the database is being published on the web and I want to render the HTML.

Will this work when rendering the results of the database through a web page? That is the reason I said about the HTML.