Search results

I can tell you this much, that I have never formatted a date into a string.

OK, I wasn't aware of the p trick. I'll test that out and see if it works. Thank you.

Thanks for the reply. I'm looking for something that's convenient for users that are used to the am/pm setup. But military time being what's actually entered for the calculations to work right. The calculations are just a beginning time being subtracted from an end time to give you a total time...

OK, that sounds like something I can figure out. Thank you! Thank you, too, CJ

Hello. This might be a ridiculous question, but I'll ask it anyway. Is it possible to create a drop down for time (with 15 minute intervals) that allows the user to choose from an AM/PM setup, but after choosing the value Access would translate that into military time in the field? Thanks in...

Yeah. It was strange to start having so much trouble with something that was working fine. Especially after entering new criteria that seemed predictable.

You're right. Once I put the "where" info in the date criteria it started working like I was expecting.

Hello. I need to create a total for a field in a query. Simple query. 1 table. But the problem (for me anyway) is that the field that I'm referring to is in the query twice. Once as a group by and another time as a count (to count the total times a value is in that field of the table). So when I...

I wasn't compiling. Just running the code behind it through testing out database functionality.

Thank you!!! That did it!! I had to put the main form info in there. I tried that before even posting this question. But my code was off a little, Thank you!!

Thank you. I tried: =IIf([ispaid],"NOT PAID IN FULL!","") same result

Yes, I did. Sorry. Same result.

=IIf([IsPaid]=0,"NOT PAID!","") too Same result

I've also tried: =IIf([IsPaid]>0,"NOT PAID!","") and =IIf([IsPaid]<0,"NOT PAID!","") same result

Yes/No

Right now, since I can't figure out how to do the debug.print, I'm focusing on setting the IIF to one condition. But that condition is set to the IsPaid field. I thought this might be a good start: =IIf([IsPaid]<>0,"NOT PAID!","") But it's not working either. Neither is...

Thank you for your reply. I tried changing the criteria to 1 and -1, to no avail. I'm currently looking into the debug.print recommendation you've made. I've never done that before. That's probably the info that I need.

Hello. Can someone help me with a simple IIF statement with 2 conditions? I just have an unbound text box with the following in its control source: =IIf([ispaid]=Yes And [Balance]>0,"NOT PAID IN FULL!","") All I want is for NOT PAID IN FULL! to populate the text box if the isPaid check box is...

I posted this to another forum (https://www.accessforums.net/showthread.php?t=89285 ) and someone (moke123 ) has given me an example file with code. And it took me a little while to get it going. Then a little while to figure out how it works. But I think I'm going to try to implement that...

Wow, thank you for that info. I'll have to look into that and see if I can figure out how to make that happen. Thanks for pointing me in the right direction.