Recent content by campanellisj

sorry I am totally confused now. how do I apply a condition to make the cboduration box visible if the optleave is 1

I thought of this but in design mode the conditional formatting is not avalible for the option group. I would really not want to use single forms is there another way to accomplish this?

yes that is correct

I know that there is probably a better way to write this code but this is what I have thus far and it works to a point. I have an option group (optLeave), a combobox (cboDuration) and two text boxes (txtLvStart, txtLvStop) I simply wanted the combobox and text boxes to be visible only if...

I would have never caught that again thank you, and to any moderator looking her, I love this site

Holy crap your the man! That dam thing was making my day horrible! Thank you again, as you can tell I am still learning VBA lol I hate to ask this but can you break down what it was I did wrong. I mean looking at that string you sent the only difference was the: & "" you added to the...

Thank you for your response....so the code is right but the query is wrong? When I look at the Query supporting the list the ID is there. Are you saying the criteria needs to be attached to the ID field and not the CLS_SSP*** Field? or change the code to look for that CLS_SSP*** field? Dim...

I attached a copy of the forms and queries in the DB here. The ID field is an ID field, that is autonumber.

Morning and thanks for any help in advance. I have a form called frmPMR that has a list box (SearchResults) in it that I am trying to configuare with the dbl click event. I would like the user to be able to dbl click an item in the list and have a smaller form (frmPmrPop) open displaying more...

I'm Sorry I truly don't understand. I am not a VB coder (obviously lol). I understand what you mean by placing something in the before update area of the FORM, but what is the code? and the code has to allow empty (null) values for the date when "TDY" is not selected from the dropdown....I only...

DK, Sorry to keep bothering you, you have been a great help. I tried your last suggestion but the results were not good lol. It still allowed me to tab out of the date field without entering a date at all. Everything works great except that..... Is there a way we can add something to the...

DK, I hate to ask you this but my wonderful boss has also asked to not allow this field to accept a null value once it has focus based on the code we worked yesterday. In other words once "TDY" is selected and the focus is changed to the box, the message displays the individual can then just...

That did it, thank you so much for your time and effort

everything worked great up to the afterupdate part. I typed: If me.arrival_data.value > date Then cancel = true me.arrival_data.setfocus = true end if i used greater than cause I didn't want a future date to be allowed, but it still allows the input of any date..

I click the dropdown select 'TDY' the message box appears stating that a start date must be entered to continue, but the focus is not set to the date box, it stays at the dropdown. Also If possible I would like the date field to be in inactive until 'TDY' is selected, then the message, then the...