Recent content by MattAnderson

No they will stay with that specific student forever

@Uncle Gizmo I think I explained it slightly wrong. The students will keep that same tablet for 3 years but some may get a new one after one or two. In this case then there would need to be a record of both of their devices attached to their name

A third table being for the second load of tablets I'm assuming. The thing I can't understand is how I make that relation of which students have which unique device when they're in separate tables. Thanks, Matt

Cheers I will have a look at that link in a bit and let you know how i get on, @KenHigg eventually one student will have two tablets?

Hi Guys I'm having a bit of a problem understanding how i should create and link these tables. I'll explain it as clear as possible. Basically I have a table for Students at a school which has their "user number" "first name" "last name". I also have a table which stores information on tablets...

Thank you very much for you help. I have come to the conclusion that the idea I have is way too complicated due to the fact i also want to integrate data from a form and put it into the pdf or print along side it. my solution to this now is to just re create the pdf in a access report so then I...

Hey guys I'm wondering if you can help me with the issue I'm having at the moment. What I want to achieve is to have a button in a form that can print a PDF that is in my documents. This PDF is not related to the database in anyway shape or form. I know you can open a PDF from a form by using...

Thank you ever such a lot, it works perfectly. Regards, Matt

Hi guys, what I'm trying to achieve is to have some form of wildcard inputted into my queries. I have a database which is for a nurse to input patients etc... One of my queries is to retrieve every patient who has been in for a headache or stomach ache etc.. Is there a way i can shorten what...

Thank you so much for your help, you really are a life saver. Regards, Matt

Hey guys I've just joined this amazing site so hello to all. :) I have a query which I'd like to create which would be to retrieve records from a specific month of a specific year, in this format "01/14" "02/13" etc.. Would anybody be able to tell me the criteria I need to input for this to...