Recent content by Tangent

Oh the tables will be related via the Pupil ID field of course. As I don't really understand the relational aspect and this is the first relational database I've ever tried to build I am not sure if this makes the job a lot easier.

Well I now have the beta of 2010 and love it so it looks as though I'll be committed to buying it when it comes out now as I'm using it to build my application. Still not quite sure what the ribbon is though let alone about it's modifications!

The 'Pupil Details' table of my driving school database includes the fields: 'Pupil Type' (Learner with no previous experience; Learner with previous experience; refresher, etc) 'Age at Start' 'Sex' with the 'Pupil ID' (a six digit number with the first two digits denoting the year) as...

Thanks Brian :)

Thanks Stopher, it seems to be working now but once I've edited a record it remains editable. I put in a Save Record button using the wizard but this still leaves the record editable and so open to corruption by mistake. Is there any way that I can return the form to AllowEdits=No after...

I wish you were right about the clear and accurate thinking Lightwave LOL It doesn't feel like I think that way to me most of the time I did try to do the sums in Access but found it way beyond my capabilities! Thanks for the welcome :)

It is asking me that if "me" is a macro that I must make sure I have saved it

I have the beta version of Access 2010 and have created a form for one of my tables and set allow edit and allow delete to No so that I can't easily accidentally alter any of the info in the table. I used the Command Button Wizard to create Add Record and Save Record and Delete Record buttons...

I have Professional 2002 which is no longer supported as far as I can see. Now that I am trying to create a database for my business I think it is probably wise to upgrade. Professional 2007 is currently about £350 and this would be difficult for me to afford. Can any of you answer any of the...

Thanks for that. Don't know how I didn't manage to suss that one out for myself A huge thanks though :)

OK I shall try that now Thanks

In my address book I created about 8 years ago I have a lovely tabbed form with a william morris design on the front and different controls on every tab. Totally forgot everything I picked up back then So following the instructions on the microsoft site But no matter what I do all the tabs...

But if I work out the age of the pupil at the time they start their lessons with me and enter it into the field AgeAtStart there are no calculations taking place within the table as I will be calculating that myself. It is static as it is the age they were at when they had their first driving...

Thanks Brian, I will do it manually then. But there is no problem having the three fields in the table if no calculations are carried out? The DOB will be accurate unless I make and error entering it as it is contained within each pupils Driving Licence Number. But I ge what u r saying about no...

In my driving school database I currently have three related tables: Pupils Prices Lessons I also want to create a table for TestResults with fields for all the criteria on the driving test form so that I can monitor whether I have any weaknesses in my tuition skills or whether any particular...