Search results

I will be tring the following in ASP code and hat should work in my opinion: <% Dim i as Integer For i = 1 To oRecordSet.RecordCount If IsNull(oRecordSet!DateTimeColumnName) Then Response.Write("To Be Confirmed") Else Response.Write(oRecordSet!DateTimeColumnName) End If Next i

Hi, Not sure if this is possible but is there a way in access for a date/time field to have the text "To be confirmed" if no date is entered. I am creating a courses database and some courses do not have dates yet as they are looking for suitable venues. Is this possible?

Hi, I tried adding <ul> <li> </li> <li> </li> <li> </li> </ul> in the default value in the table design view, however this brings up a message saying: <b>The expression you entered contains invalid syntax </b> Is there another possible way around to this? Thanks

I have a table for which I have set up a form for people to input data into the database, is it possible for me to set a default value of: <ul> <li> </li> <li> </li> <li> </li> </ul> In one of the columns which is named description? Many thanks

I have been looking a bit closer at my tables, I think the Courses table can be split, some fields in the table like courseDay, researchFrom, researchTo are not always populated and reading the normalisation stuff, this is not the way it should be, so I have created some tables with TEST on the...

Thanks Bob, I better let you get some sleep seen as it's 2am there. The example on the link you sent are good so i'll see what can be done, im at work for another 7 hours yet at it just turned 10am here and im in til 5pm, so we may get to speak later. good night.

Thanks bob, I did read something similar when designing the DB with my colleague, I know that the RepeatedCourse and NetworkCourses have similar information to the main Courses table and this maybe does not make it normalised, however when we start creating the web pages for this to go on the...

Thanks for that neil. The reason RepeatedCourse and NetworkCourses have similar information to the main Courses table is because they pretty much hold similar info to the Courses table with the exception of having different courseCode, Day, Date, Time and Venue. For example a RepeatedCourse can...

Hi, Is anyone able to have a look at my database in the previous post to confirm if they think it is ok? I have to have this completed very shortly and not being experienced in Access is what is bringing this doubt into my head. Any help is greatly appreciated. Thanks

Thanks RSMONKEY, Attached is my database. The Database has 5 tables, the ones in question which I would like to know are correct are the "Courses" and "NetworkCourses". The other 3 tables I am happy with as they are fairly straight forward., The current information in the database is dummy...

Hello, I am new to this forum and Access databases in general, me and a colleague have been given the task of recreating our course brochure into an online searchable webpage. The web side of things I am ok with, its just the designing of the database that is causing us both endless problems...

Thanks Spoole, I guess its back to the drawing board, Is the only real option in that case to get someone to copy and paste from word to access? Thanks

Hi, I'm new to this forum and it's my first post, any help is greatly appreciated. I have just been given a big project of firstly transferring information we hold in word documents over to Ms Access and then using ASP or .NET I got to make this a searchable, more user friendly web page...