Search results

That is brilliant thank you very much! I (honestly) will enjoy going thru that later. However, I have had a go and I am just SO lost! I cannot get my head around how to do this - I guess because of the 3 tables? I believe in working things out myself - is there any kind soul that would help me...

I'm building a database to record which books Pupils at my school have read. I have 3 Tables: Pupils - ID, Forename, Surname, ID Books - BookID, BookTitle, Author, Level, Genre Read - ID, BookID, DateOut I'd like to create a query that shows the BookTitle of the latest DateOut. Can someone...

I really am too careless sometimes - many thanks! (I'll take on board your name critique)

Before I start, I consider myself a programmer who is punching far above his weight! I really struggle with SQL. I have a database for my school that I'm creating to log books read by Pupils. I have a Read table linked to both to a Pupil table and a Book table to say that the book has been...

As in my original post margins, fonts, sizes etc are the same. The only thing I can imagine is line spacing - Line spacing in Word is set to 0pt but I dont know what point line spacing the Access box is... Anyone?

Hi all, I work at a school and have a Reports database. I have a form for each subject and a number of fields per form. I'm trying to get the teachers to enter information about the kids into very precise boxes and then have that printed via Word mailmerge to produce end of year reports. So...

On further investigation it looks as though I had a corruption somewhere. I tried to open the target form and it gave an error about the query, so i changed the record source to point directly at the table. This too gave an error saying it couldnt find the table. The database is split so I...

Thanks for the reply. I'm a programmer of old and managed to get this code working initially by asking our friend Mr Google and found the code when I did so. I have to say I'm a little flummoxed. I removed the references to DAO (not really sure what DAO is though) and it didnt work. Tried...

Hi guys - I work at a school and have a form that lists the classnames in a listbox. I have code that allows the selection of multiple items before it opens the form with pupils from the selected classes. This code worked when my database was mdb(2000) but now it is accdb (2007) it comes up...