Search results

Hi everyone I am not very good with code and any help would be greatly appreciated. I am trying to achieve the following. I have a series of fields in a form. Each has figures in them. I have summed the fields into one field. When all of the fields are reduced to 0 I want it to look at the...

I have a main switchboard and 2 other switchboards. When I originally set it all up it was all working fine. I had to go back to my database and correct a few errors and the links on the main pages to the other 2 switchboards is not working. I tried deleting them and recreating them but this...

Hi everyone I am hoping someone can tell me if I am I even on the right track with this. This is something along the lines of what I have in my form, but it is not working. =IIf(Nz([Form]![WIP]![Variation records subform1]![Total Variation Value])=' ',0,Sum([Form]![WIP]![Variation records...

Help me please, it is probably a simple answer Hi everyone I have a main table that contains all of our Work in Progress with a primary key of Job number. I am running a query on this table with certain criteria such as Project manager etc to generate a sum of the contract. There are other...

Query filter problem Hi everyone I have a database that I have created to track our work in progress. The primary table has the records of all of the jobs. I have created a form to control this table and I have a subform that tracks invoicing (more than one invoice per job). I am trying to...

Hi everyone I have been through the forums about subforms and there has been this question asked in other posts but no answer ever. I have attached a microsoft word map of what I am trying to achieve with my database. I have probably got most of it up and running except the subforms. I want...

I have created a form from 3 different tables. I used the wizard to create it. I have just realised that there is a field that I did not incorporate when I used the Wizard. How do I go about getting this field onto my form. It is not in the list box. Kind Regards Jodi

How do I get a form to open to the last record. In the properties of the icon I have tried using the expression builder, but I can't seem to get it to work, it seems to add an expression but then the expression does not work and when I try to use the button I get an error message. Any ideas...

I am trying to assign each entry a number. The database has a number in place of BA4415 etc. I want to automatically assign a new number to the next record created in a form. Is there an easy way to do this or does this number have to be manually typed by the user each time. As far as I can...

Hi everyone, I am new to this forum, I have created a microsoft access database for my work. I am at a loss though, I need to secure the database so that certain users are able to add information to the forms that I have linked in the switchboards. These users must be able to add information...