Recent content by simonI

Just like to thanks everyone who has helped me these past few weeks in designing my first database!!! Thanks for putting up with the stupid questions Si

thanks for everyones help i think i have got it working!!! cheers again Si

i think i did what you said (except i have kept the code as there is a fair bit) but no when the form opens i am getting a runtime messge of "Cannot add record(s): join key of the table not in the recordset" argh... please help thanks again

its Alpha numeric in the form of A123456.... do i still need to remove the wrappings?

thanks for the help... much appreciated!

no because the studentID is unique...

i have a form where the user has already enter there student details... they then move onto the next form where they re-enter the student id and the other details appear in the 3 text boxes below.. the problem im encountering is that the Dlookup only seems to return values for the first record...

Thanks very much - i knew it would be something stupid but like i said i am a beginner and this stuff can get really confusing!! thanks again

HELP..... i am trying to set up the intial format of my form which runs on the Onopen event. i am trying to hide all my checkboxes until confirmation is made.. this works fine on all but my first checkbox with the run time error "You cant hide a control that has Focus" appearing.. is there a...

i have about 14 fields that relate to subjects, basically i want to be able to run a query that searches for all the people who have choosen the module and report bak who they are.. now i know i can do this 14 times over but is there a way that the user can choose the subject first and the...

sorry new to access how do you do the no duplicates or the Dcount.... cheers again..

Folks, i have two forms with a command button on the first which opens the other... is there a way of getting this button to validate the primary key (i.e. make sure its not a duplicate) before it trys to open the next form?? i've tried to call the next record function (as the button seems...

thanks i sorted it by just multiplying the SQL sum thingy by -1 and it seems to work..

i have created both of these using the wizard.. and i cant find anywhere to put the code.... i have tried to use the expression builder in the control source of where the number appears on the form but it keeps giving me syntax errors this is a portion of the SQL code that the query uses...

yes i thought that - similar to excel - but i havent the foggiest where to put it...