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 know i am going to sound like a complete newbie, but i have never used the Dlookup before is it straightforward??? Many thanks in anticipation, rob

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...

Top one, solved the problem, what a star! Many thanks Rob McCreedie

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...

I don't know if this will help but whenever i want this to happen i create a macro to maximise then with the form open in design view attach the macro on mouse move. so when the user moves a mouse the from maximises. Rob

A copy would be great. Many thanks rob.

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...

Many thanks to all of you on the ball people, you hav helped me crack it. Thanks again Rob

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...