Search results

Code Not Working Help Me Please Hi all Please see conversation for the rest of the thread. Is there anyone out there that can help me further with this? Regards Jodi

Ok so how do I go about this? Regards Jodi

Hi thanks for your help. I have cut ant pasted both codes in, but it is still not prompting with the message box. It is not returning any errors either. Any further suggestions? Kind Regards Jodi

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

Switchboard Items I can't get the attachment this time round. Am trying to download a program for appropriate format., it does not seem to accept Excel I have completely deleted my switchboard and started from scratch. It all works fine until I activate the macro for the main switchboard to...

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

Not sure if I understand Hi Pat I am not sure what you mean in the above. I recreated my queries, one to show invoicing totals and one to show variation totals. I then created another query and pulled the information into that query and it is doing everything I want it to do except if there...

Ok that is all working but what now This is the expression I have used in my query. It is working in the fact that it is returning a 0 value if there are no entries. Invoiced: Sum(Nz([Invoicing].[Value],0)) Variation: Sum(Nz([Variation Records].[Variation Amount],0)) My next question, a...

Thanks for the feedback. I have done something similar to this, but am unsure and not confident with queries. Very very rusty. In my Forms I have been doing similar to what you have above, but I have been using the ! between the names and it has not been working. Should I be using a . or...

Nz Function More detail required Thanks, i looked up the Nz Function and have now got that working in my forms. It is fantastic. However in my query I have imported 3 tables as follows WIP, Invoicing Details, Variation Details. In this query I want to show the total of the value from the...

Got it working, thanks for your assistance.

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

That works, but it is not calculating thankyou for your help, that was very easy and probably very silly of me not to realise that was the problem. However now it is not returning a value for a total. I have the following fields included in my query, contract Value, Sum of invoicing, sum of...

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

MAP HERE Sorry forgot to add the map to the previous post

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 grew up watching Vic TV as that is what was broadcast to our area. Took a liking to the Blues as a kid and now I am obsessed, absolutely hate the crows and port! Can't help it, only been in sunny Qld for 3 months and can't possibly change teams now! Jodi

Thanks brad Your a legend, yes got it now, I knew it was something simple, I am still so rusty on all of this stuff. Glad to hear Vic is sunny today, I used to live near mt Gambier, approx 30km from the Vic Border in SA so I know Vic quite well. Go the Blues! Jodi

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