Recent content by Cirrostratus

I've got a form where the user can only enter the character asterisk or numbers. No letters or other special characters allowed. The asterisk is a problem since its a wildcard. How do I allow the user to use it or numbers only? I've tried Validation Rules, I've tried vba but I don't seem to...

If there is two queries, will the form be able to update the data displayed in the second query? I'm thinking not but I'm not 100% sure. :confused:

I know, this is an old topic but same question with a twist. I have a form where a user updates the "capacity" data, I want to link a query to the form so the form updates the data via the query. My data is like this: CaptureDate Location Capacity 10/01/2013 A011 100...

Hey, I'm just throwing this out there because I'm not sure if this can be done.. Is there a way to create a report that will show inventory location capacity in a graphical form. So if a location is determined to be utilized 25% a picture A is used, if 50% picture B is used, 75% picture C is...

Thanks for all the suggestions!! So, I was able to solve it. This was some really creepy stuff and I really just stumbled over this. The Lot_Size_AfterUpdate was not being triggered at all. Nothing in there was working, whatever I put in it just would not work. So I went back to the form and...

Ok, I tried the debug but its not producing anything. I also tried the watch and hovering over strWhere (after plugging in the values in the form) and still nothing is coming up. The program looks like this now: I was able to reconfigure the query so I didn't need to do the RemoveFirstChar...

No, I definitely gave that a shot. Tried again just to be sure. No message box pop's up. Its not generating anything.. :(

Good idea, but no change unfortunately.. I tried taking the RemoveFirstChar out from it entirely, but even without it, its not working. Could the Lot_Size > Buildable not be working? I'm not sure if that's even the correct way to use that? Should there be quotes or something around it...

That didn't bring back anything, but no error messages either..

Ok, I tried defining "Buildable" but it came back with an error message on the Buildable = where it said incorrect use of Null or something like that.

That fixed the compile error message, thanks! But unfortunately the program still doesn't work. If the user enters into the lot_size field a qty larger than the "buildable" it still doesn't produce the msgbox. Does the "buildable" need to be defined? if so how? and can I use that then in the...

Its all on this one form, the only thing not there is the query in the dlookup.

Yeah, that's still giving the same error message. Very strange?!?

all of those fields are text, so I changed it to: But now VB is giving a compile error message, "expected end of statement" at the closing parenthesis that I have highlighted in bold. Something is still not right.. :confused:

I guess there is a couple of things that could be going wrong here. The RemoveFirstChar function, I'm not sure if that works inside the dlookup function? And the Buildable, does it need to be defined or is my message box syntax wrong? Thanks again!