Search results

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

Query is working, yet the subform is shown blank. Maybe the conclusion is that today just isn't my day :( Edit: With blank I mean there are no records shown on the form. In the query are all the records which is good. SQL of the "working" one (query wise): SELECT VRMUTSTAF.AF_lengte...

No still stuck, the question remains. I know I also had this problem yesterday. But no idea what I did to make it work. Probably a lot of luck helped me :D When I open a new query with just columns from VRMUTSTAF I can edit all. The moment I add VR to the party I can't update anymore..

You know what the funny thing is.. This query is the exact same as it was in the application that crashed, and there everything was updateable. New SQL SELECT DISTINCT VRMUTSTAF.AF_lengte, VRMUTSTAF.AF_zaagbreedte, VRMUTSTAF.AF_datum, VRMUTSTAF.AF_ordnr...

Those queries give me so much headache :banghead: My program cracked down, so everything I did past 2 days has to be redone. Now this query won't let me add records, which in the previous version was possible and I don't see what I'm doing different this time. I'll post the SQL maybe you see...

It's very close, it sums up the length perfectly. Yet this is not what is used. What is used is AF_lengte + AF_zaagbreedte. i'll try to play around a bit to see if I get it working with both :) GOT IT just a + [fieldname] :D SELECT VR.Annkoop_datum, VR.Aankoop_lengte...