Recent content by OnePoint Consulting

Thanks again Minty =D I understood the part with the "value is a number", i just didn't know how to type it in... I have no actualy knowledge of coding, it's been YouTube tutorials and online forums since i started working on this project. But it all works perfectly now, soo thanks a lot and I...

okay, so i've also added the code to the "form current event" and the only box that isn't behaving like the rest is the second Textbox. It's the only one that'll enable the command button even if the other boxes have no values in them… all the other combo/text boxes work This is the code is...

Thank you Minty =) i've tried it and it seems to work, but not perfectly yet… The textbox values are numbers and you said something about "Checking for 0" in this case... is this the error? and if yes, how do i implement this? ohh, and do you know what i'd need to add, if i'd want the command...

Hi Guys, i'm trying to get a command button to be disabled in it's default state and only to be enabled when the user enters values (text and Dates) into combo and text boxes. i've tried following code in VBA but i haven't been successful yet… could someone help out? Thanks in advance =)...

After quite a bit of facepalming, i noticed that in the german version (for some reason) commas are not allowed, and we use semi-colons instead… after i switched out all the commas and added the correct function which was DomAnzahl (Dcount), I finally got it to work. The final funtcion was...

would it be possible for someone to make the changes and then reupload the file, so i can just continue working with the changes already made? maybe i'll then understand what i did wrong, or so... That woul be really great =)

...which would be "DomWert" but also ends in an error message =(

how do i do that? i'm really sorry if im sounding dumb… edit - found out what you mean with the Lookup field... what other way could i use to get the same result as a "lookup field"? possible?

So, no matter what i try i always end up with the same error code. Did you guys make any changes to the document prior to entering the function? The error code roughly translates to: The expression you entered is syntactically incorrect. You have not specified an operand or operator, you have...

ok, so how exactly should i enter that? i've never worked with vba or the immediate window "function"?

Thanks for all the replies! I'll just upload the File so you guys can have a look at what i've done (or in this case "haven't done yet") The unbound textbox in question is on the Menu form; "Offene Aufträge" And yes, the "Status" fields are text-fields

i Tried it with "Tasks" and it still results in the sam error message… I really don't know where the problem could be.

Thanks for the reply CJ. I've copied and tried it but it still isn't working… Access is giving me some sort of syntax error message or something like that, speaking of operators and operants. I noticed that the table name is acutaly "Tasks" and not the former above (thats the name of the...

Hi guys, i've got a small problem trying to get an unbound textbox on a Form to give me the amount of "assignments" with the Status "Open" from my table "Aufträge Eintragen". I've got about 4h of ACCESS experience, so i'm an aboslute newbie to this. Plus i have no experience what so ever in...

.