Recent content by Ean James

please??? anyone!!!

here is a small version of my db, I would be very gratefull of any help! Thanks alots guys, I dont know what I'd do without this site! :o

How is it done because all the ways I have tried just changes the number and I get errors?

????????? ????????????????

I have a form that displays a list of users and there programs in a sub form, I would like a combo box instead of the user ID number so that I can press on it and all the user ID's will appear, then I can select it and there details will apear. Can this be done?

I have a file size limit of 2meg but my database is pushing well over 4? I have added images that were quite big but took them out when I relised how big they were. After compacting the database the size remains the same? What can I do? Its a stupid problem, but it is however, a problem...

it ok I found it, thanks very much 4 your help, FoFa, KeithG

Thank you very much for your replys! Where would I find default value? Thanks again :D

Thank You!!! Ur a Star!! :D :D :D It works a charm!!!

Hi Keith Thanks 4 your reply, So the controlName would be the name of the StudentNo field on the form? Then I could just have a button that opened the report and the report would take the information from the open form? That would work because the button is on the form so it would have to...

Hello peeps! Just someone advice if I can! I have a table that contains student details: StudentNo Surname Forename I have created a form to add students to this table but I need a button that will read the highest StudentNo and then add one, putting the new stundent number in the form in a...

Im making a student database that holds information about students and the modules they are taking. On my student entry form I wish to have a button that will read the current student number shown on screen and place it in my query to make their timetable? I understand that this can be done...

Thanks What does the (vb_short) stand for then, will that have to be included in the expresion or will something need to be in its place, I have looked it up as much as I can but it only talks about date and how to calculate them Thanks again Ean James

Hi, I need to calculate to times in a data base Table: Times leaving time 07:30 Interval 02:30 I did this calculation in a query: Time: [Times]![leaving time] - [Times]![Interval] Both fields are in SHORT TIME When I run the query I get: Time = 0.208333333333333 What am I doing wrong...