we are struggling with how to make sure that the playlists are no more than 15 minutes. is the a validation formula that can be applied to the length field which makes sure the selected tunes are no more than the 15 minutes. also how do you apply times to the play list so that the participants know when there tunes will be played.

pete forder

Our Lady and st chad sports college wolverhampton

Hi,

We have started the Music database this week. Length field is stated as being in (secs) and the max length as 10 mins. Therefore we have converted the max time into secounds as well.

 10 mins = 10 x 60 secs = 600 secs.

So, we can apply validation as >0 AND <601. This will allow values between 1 and 600 seconds to be entered.

 Hope it helps

William Melton

wmelton@copleston.suffolk.sch.uk

Copleston High School, Ipswich

In ACCESS you could try:

>=1 And <=600
or
Between 1 And 600
to achieve the same results.

Not alot of people know about the Between function.

You could make the playlist only 3 tracks long : this would pretty much guarantee the length limit is not reached with the existing tracks.

In the query sort the tracks by length ascending, say, and In the query design add in TOP 3 into the SQL view of the query: SELECT TOP 3  FROM .....

You are licky - we cannot get the file to import into Access at all.  Tried in Office 2003 and 2007, created new text files, CSVs but no joy.  It seems pointless to create a table structure in design view and then have to import the text file into a new table, and start all over again.

 Have had the same problem with the Applied ICT GCE stuff too.  Don't have this trouble with material from other exam boards.  Anyone any ideas why its casuing such a headache?

 Thanks
Richard

To import a csv directly into the table you have designed in Access, this can only be done:

a) if the table field names and headings in the csv are IDENTICAL and preferably in the same order
b) if there are no headings in the csv and the fields are in the same order.

The field order is very important. You must of course ensure that the datatypes are correct for each field and that validation has been set as necessary.

My preferenceis to design/create the record structure, import the txt/csv file to a new table the create APPEND QUERIES to transfer the imported data to the new table.

I used >0 AND <601 for the validation of seconds allowed. This validation was entered straight in the design of the table. I also got my pupils to enter some from of Validation text to promote usability of the form. This will give them opportunities to discuss these elements in the eportfolio.

We saved the data text file http://www1.edexcel.org.uk/spbs2007/d201/documents/links/Tracks.txt directly on the pupils computers. They setup the databases in design mode and kept to the suggestions of the list http://www1.edexcel.org.uk/spbs2007/d201/documents/links/Data_items.rtf.

We setup the datatypes, field lengths, validation and lookups for the codes accordingly.

214 records were successfully imported.

Having fun, Wil

Ann Weidmann's advice on this is simply to export a suitable list from the database to a spreadsheet or word processor then simply delete records to leave just enough for the required playlist. No need for any sort of 'fancy' functions/filters/scripts or anything else.

 Essentially its a pretty wooley task..

GQ52 - http://groups.msn.com/EdexcelDIDAResources/

Great stuff,

We did the same. I am sure we've got it right.

Cheers,

Bismark

The same prolblem here.

I tried it 3 time and eventually had to import text file into a new database. Did not find any rejected records though.

Bismark