Calculate monthly consumption, based on selection in combo box
- Thread starter anb001
- Start date
As mentioned in another post, then I'm sitting "behind" a very slow satellitte connection on an oil rig. And there are lots of people sharing this connection. And varios web pages takes forever to load. It's very annoying, but unfortunately the way it is. But I'll try to be patient, and I guess I'll succeed sooner or later.
Happy days for you then
Ok, hopefully it works now. It should be attached.
Should you have time, I'd appreciate if you could take a look at the frmSapdor form. For some odd reason data is dissapearing when using the tab key (and coming back with shift+tab key).
Should you have time, I'd appreciate if you could take a look at the frmSapdor form. For some odd reason data is dissapearing when using the tab key (and coming back with shift+tab key).
See attached. I've done 1 to 4 so you will need to follow the same layout for months 6 and above.
With your regards your second question I don't understand what you're pointing at. It looks like a database that was built by a company so I'm sure you can get support from them if anything. I would have to see it to know what's happening but can't guarantee I will have time to diagnose the problem.
With your regards your second question I don't understand what you're pointing at. It looks like a database that was built by a company so I'm sure you can get support from them if anything. I would have to see it to know what's happening but can't guarantee I will have time to diagnose the problem.
Ok. Thanks a lot.
Regarding seperate question, then it is actually a screenshot of another system, with text boxes on the top, in order to show figures in the right sequence when entering them into that specific system. But no worries, it's a minor thing for now anyway.
Regarding seperate question, then it is actually a screenshot of another system, with text boxes on the top, in order to show figures in the right sequence when entering them into that specific system. But no worries, it's a minor thing for now anyway.
VbaInet,
For some odd reason then only subform with january is showing when the main form frmConsumption is started, even though there are also data from February. If I after start then go to design view, and then again to from view, it will show me both January and February.
Everything is updated as it should in the query.
If I open one of the subforms, then they all show the same data as subform 1 (frmCons1), except the average calculation says 'error'.
Any idea what is wrong????
/Anders
EDIT: Please ignore this post, as I have discovered the problem. I had accidently changed some settings for the combo box, messing things up.
For some odd reason then only subform with january is showing when the main form frmConsumption is started, even though there are also data from February. If I after start then go to design view, and then again to from view, it will show me both January and February.
Everything is updated as it should in the query.
If I open one of the subforms, then they all show the same data as subform 1 (frmCons1), except the average calculation says 'error'.
Any idea what is wrong????
/Anders
EDIT: Please ignore this post, as I have discovered the problem. I had accidently changed some settings for the combo box, messing things up.
Last edited:
Similar threads
