Recent content by PennyPitSt0p

No That would make ENTIRELY way too much sense! Thanks!

Ok :confused: Well, it appears that this may WANT to work, however it appears that it does not like the "printrecord" piece. I am getting a compile error which says sub or function not defined. The help section is really not much help, so if you could help it would be more help than I am...

OK, I think that I may be over thinking this, and that there may be a simple solution to what I am trying to do. I am not sure if this should be in the Forms section, or in the Reports section, so I am posting this in reports. Please keep in mind, that I am very new at this, have no formal...

Simple Simply that they are navigating to the next record. I had some really slick code created that popped up a message box that told the user that they were changing records, but my manager found it annoying that it beeped and made the user acknowledge it. The internal message field simply...

New Variation Is there a way that I can show a field, briefly, if a user navigates to another record. I want to warn the users, but not use a VBOKOnly, VBYESNO or anything that they would need to actually respond to. I created a field in precall_form_view called Internal_message. I was...

Mea Culpa I actually had inadvertantly opened my old test database and pasted in the incorrect code. Then, I got to working on something else.... blah, blah, blah, yada, yada. I just got back on here to state that I figured out my problem, when I noticed that I had put the wrong code in any...

OK. Requirements changed again. :rolleyes: Now, not only do I need to check that comments are required when this field is in pending, and entry on TASQ, SER and App are complete, I now need to check that when this field is set to SENT_TO_AV that the AV_Comments is not null. Sounds simple...

OK. That makes sense to me now. Thank you for your input. I have only been doing this for less than two weeks, and I have no formal training, so explanations really help. The empty string thing is great! I would not have thought to test for that, even though I know that I have seen empty...

Works like a charm! It does not look a whole lot different than what I had. Why did yours work and mine didn't? Was it the format? You had the null first... Thanks!

OK, I have a field (info_updated) on my form (precall_form_view) that I only want to be visible on the form when the value in that field is not null. I have looked through the forums, and I can not seem to find an example that is like what I am looking for. It may be in there, but sometimes...

You know, I found out what I had done wrong with my last code example, I had the mycheck# isnull values all set to the same variable (tasq). Changing that actually fixed that problem. Your code looks tighter though, so I tried it and it works as well. Thanks to all for your assistance!

OK, my requirements were just changed by the end user for this field. :eek: Now, it appears that not only if the status is pending, do they want to require comments. They also want, if the status is complete for the following fields to be required: TASQ Order # Serial # App I put this...

OK, I figured this one out myself! Woohoo! I modified the error response on my save command button to state, "Can not save record for pending merchant without a comment." Works like a charm! Thanks again guys!

:confused: OK, I spoke too soon. When I add this line to my code, and try to save without entering a comment, it gives my response and I click ok. Then it gives another response, The DoMenuItem action was canceled. I removed the do.cmd item, so I am not sure what it is trying to call as a...

:D Woohoo!!!!! This is a great suggestion. I had to take it a step further, and had to cancel the do.cmd though. At this point, I don't really need to force them to go to the comment section, as it will not allow them to save without updating. Thanks!