Search results

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...

I have tried the afterupdate suggestion but after I make a selection the focus remains on the combo box.

I hope that someone is able to help me with this bizarre situation. I have a combo box with status codes selectable within. The situation that I have been asked to perform is that when a specific selection is made from the combo box (say TDY) it displays a message (i have this part covered...

Morning all I have a small issue with two dates that I hope you can help with. background: need to have 2 date boxes formulate the following information. start date, end date, sum total number of days between them, display time remaining from current date...not to exceed 365 Status I have...

Thank you both I knew it was something simple but I couldn't get it lol Just out of curiousity is there any way to not allow duplicates from being assigned? I will be assigning those positions to actual names but I don't want to people being assigned the same positon. so how would I not allow...

I have attached my working form in the DB please if you can help I would appreciate it. I have a combo box (cboMtoe) pulling from a query (Qry_Mtoe1) that generates a large list of choices. I would like those choices to fill in the appropriate text boxes that I have set up on the form. I...