Search results

If you go to the properties of the button on the form you can locate the On Click Event property. From there you can set the code to run when the button is clicked. Not sure if it can reference the Private sub, so if you have strange errors that could be it. Wish I had more for you, but I...

Glad you got it sorted. Those nested IIFs can get out of hand sometimes.

A quick google search returned this: http://www.simply-access.com/Hiding-Error-Messages.html

after vaping for over a year exclusively...what a difference. i tried to smoke a cigarette the other day and i physically could not inhale the smoke. i can vape anywhere (minding societal constructs), i don't smell, my mouth tastes delicious, i dont hack shit up, there is no cigarette...

Sounds like it may be because it's an expression and not an actual field per se, but I don't know for sure. You can easily test that though. After you format the expression are you given the same options in the property sheet as [30% due date]?

I would create a dummy table with a date field and add it to a form. Do the same thing you're doing now and see if you get the same results.

The formula works just not with any dates higher than 5 days??

How are you inputting your date formulas into the conditional formatting box?

:) Happy to help.

Basically, if you're familiar with VBA, then you will just pick an Event for the control you are "clicking on" and when that Event occurs then set the other control = today's date. If you aren't familiar with Events let me know. For example: Private Sub ClickedControl_AfterUpdate()...

Is this on a form?

I'm having trouble visualizing how this looks in table form...Did you try a Crosstab Query in Access?

This forum is extremely easy to troll I've noticed. Very serious opinions around here.

Have a look at this even though it's for older versions of Access. The principle remains the same. Create a multi field index, so duplicate values can't be entered. Set the "Allow Edits" Property of the form to "Yes" to allow users to edit values such as the address. You can lock fields...

Need more info. Maybe you can post your original query.

That seems strange to me. You might want to run a compact and repair on your database and see if that helps. Maybe it is corrupted?

First, it might help you (and us) to give your controls like comboboxes identifying names, so you quickly know what they refer to. I'm guessing Combo548 is the 'member' selection. I would put the code in the after update event of the second combobox, so that it's triggered immediately, but...

Try something like this: Private Sub combo2_AfterUpdate() If combo1.value <> 'left' then MsgBox "You must change status to left .... etc" combo1.SetFocus End if

So basically, after the update of combobox 2 you would need to set combobox 1's value to 'member'. Something like: Private Sub combo2_AfterUpdate() combo1.Value = 'member' I didn't test that. Don't be afraid to post your code. Gotta start somewhere. :)

no problem, good luck!