Search results

I know this must be very simple but I am having a complete mental block. I have a table with three fields; Ward, Date and Dependency Score. The data in the dependency score field will be either 1,2,3or4. what I want to do is work out how many of each score there are i.e. Like "1" and then add...

I have a form (frmentry) for entering data into a table (tbldetails) and I want it to automatically check a surname taht is entered against the suranme field in another table (tblstruckoff) and then alert the user if there is a match. I am presuming that htis would be done using an After Update...

I hope this will be an easy question for the high calibre members of this forum. I have tried to add the Not criteria to elimate all records taht have Nursing Midwifery in a certain. It takes out the fields containing the specified data but it also removes any blank fields, does any one have...

When I enter the surname of a person in the text box on a form i want to be able to automatically check against a list of names in a table that details staff not to employ and alert the user to this fact but not stop them from carrying on. I am a bit of a novice in terms of expressions and vb...

I have a combo box on a form that i just can't seem to get to appear in an a-z format. Does anyone know how. Many thanks in anticipation, Rob

I am trying to total 40 fields into a label at the end of a line on a report. If i try and type =[field1]&[field2]&etc into the label all that it does is put the values next to each other and if i replace the & sign with a + then nothing appears. Does anyone have any ideas? Many thanks in...

I have a report which will contain many different entries which gets the info from one query. As there is so many different entries I want to be able to copy the structure of the report but replace the query with one that is the same but for a different area. So my queston is how do I cahnge...

I have a basic report and i need to display three fields (title, forename and surname) the same distance apart irrespective of the length of field. At the moment I have got three seperate text boxes displaying the fields and the result is the same as below: Mr Rob McCreedie whereas...

I have a job applicants table which is linked to a jobs available table via another table containing an id from both of these. what I want is to be able to have a form containing the information from the applicants table and a drop down box or something similar to select a job from the other...