Recent content by MartynE

Scott's home brewed

with hairy strippers

Enlighten us, by telling us who you are..? I'm getting the popcorn, please continue.

With three sweaty

Is there any reason why my database crashes when I click this button. In design mode it works perfectly. Yet in the application it crashes 90% of the time. Edit: When I just filled in a reservation I can click the button and it works, when I close the form and re-open this same record and click...

I was playing with the quotes I knew it had to be something like that. Didn't know it was making a string of it. Thanks!

Hey all, I'm trying to move a record from reservation to actual mutation. It's almost done just the last bit of deleting the record in the reservation table us not working. It gives the data type mismatch error. I've tried several things but I'm missing something and that's what I need some...

No idea about the ; I just know that the , doesn't work in this function. Let me try that Wrapper function. Edit: Works like a charm thanks Paul for the quick help!

I'm trying to sum up 2 expressions. 1st. UsedAF: nz(DSum("AF_lengte+AF_zaagbreedte";"VRMUTSTAF";"VRID = " & [VR].[VRID]);0) 2nd. UsedRES: nz(DSum("RES_lengte+RES_zaagbreedte";"VRRESSTAF";"VRID = " & [VR].[VRID]);0) Now with a third expression I like to sum those 2 up. 3rd. Used...

I just gave up and just make a button to make mutations and show the previous mutations in the subform. I think that is just the easy way out. Thanks for your time and help!

Tried both, the problem is that it tries calculate [used] while no autonumber is given yet. I have no idea why it should give a autonumber field to VR.VRID since it's determined by the record you are in. So it should be filled in already.. I tried in the criteria: Forms![VR01:Voorraad...

Tried that before u posted that, how about you take that coffee ;) It gives the same syntax error. ( I work in Access 2003 )

Uhh when I try that I can't leave the column of the query it says it's missing a operator. Indeed I've been working hard, the sooner this is done the sooner I can go spend my free days.. :P

Okay I lost all hope now and am desperate on what is causing this. Especially when I think off that it all worked before the program decided to crash :( Some more info on the error: The subform shows the right records and it is possible to update the existing records. When you want to add a new...

Got it! It was the property Data entry of the form that was set to yes.. Last error I hope is: syntax error (missing operator) in query expression 'VRID = ' I will google this and hope I can find it and post it here :D This is the one giving the troubles. Used...