Search results

Thanks, tried but not getting a color, also when I switch the option button I get error 2427: "your entered an expression that has no value. Private Sub Frame28_AfterUpdate() With Me.Frame28 If Option31.Value = 1 Then Frame28.BackColor = vbGreen Else Frame28.BackColor = vbRed End If End With...

Dear experts, I'm trying to figure out how to change the OptionGroup background field to color based on the value of the option button. I found that the control is transparant: OptionGroup.BackStyle 0 and can be changed to normal OptionGroup.BackStyle 1 and then the interior color can be set...

Hi Colin, Thanks for helping me out whith this, very much appreciated! :-) I'm trying this out, think I need to actually test this out to really understand as I'm still a bit puzzled with the numbers reflecting in CommunicationsT for the employees. I'm thinking too much excel ;-) Have a great...

Sorry, but I'm a bit confused with "Create a table PhoneNumbersT listing all 50 numbers on your exchange" and the numbers then in CommunicationsT? Best regards, Siegfried

Thanks Colin! Would you agree that I also link the PhoneNumbersT to EmployeeT for easy entry of the WorkTel? EmployeeT EmployeeID FirstNameFK LastNameFK UserIDFK PhoneNumberID IsActive Best regards, Siegfried

Dear experts, I'm trying to figure out how I can mark values as "available". I have a list of 50 phonenumber which are available on our phone exchange. I have this an excel where it shows the telephone numbers sorted and behind the number the name of the employee who has the number assinged...

Perfect!!!! Thanks for your help JHB! :)

To say it short, I'm replacing on the the Form the field VesselCurrentStatusID in Tabel TblVesselManagementStatus by these comboboxes.

Hi JHB, No, the other comboboxes don't update the tables, they select a value from those tables. It's in the Table TblVesselManagementStatus field VesselCurrentStatusID that I have to select a value to give a vessel a status. And the value I'm now entering refers to a combination of several...

Hi JHB, Thanks for your efforts. The comboboxing are cascading correctly but the value is not updating in the tabel? Refer to attached.

Hi JHHB, Yes, that's correct!:) That's how I would like to have it on my FrmVesselManagementStatus. B. Rgds, Siegfried

Dear JHB, I've attached a few pictures to clarify my problem. Picture FrmVesselManagementStatus.jpg show the from I'm working on with the comboboxes I've created. Frm Result.jpg shows what I want the form to do. I now have a field status which I want to replace by comboboxes. When selecting the...

Hi JHB, No, I'm not getting a result, when I run the querty I don't get any records.

Godmorgen JHB, Thanks for your interest in my post. I'm having problems cascading the comboboxes for vessel's status. In my form FrmVesselManagementStatus based on TblVesselManagementStatus a vessel gets a status. TblVesselManagementStatus VesselID FK VesselCurrentStatus ID FK SSS In my...

Dear experts, I keep struggling with cascading comboboxes. The examples I find on the internet usually don't match my more complex requirement... Can somebody please guide me and help me out. I have a ton of excel files which I want to get rid off by using Access. Hence I'm trying to create...

Thanks Colin. This helped out. =DCount("*";"tblEmployees";"functionFK<>12") & "/" & DCount("*";"tblEmployees";"functionFK=12")

Thanks Arnelgp, What do you mean with [separation from company date field]? Kind regards, Siegfried

Thanks colin but I'm getting a value 44/44, being both total count of employees...(?) =DCount("*";"TblEmployees") & "/" & DCount("*";"TblEmployees";"JobTitleID - '12'") 12 being the temp job title. I'm want to achieve total count 44 and when we have a interim worker (temp) to show that...

Dear experts, Calling once more on your expertise. I have a form that lists all employees (FrmEmployees.EmployeeID) with their job title (JobTitleID). I want to display on the form in a separate field the total employee count of the hired employees and, if so applicable any temp seperately ...

Dear Pat. Thanks for your help and advice!:) I've updated my StudentProgress table so students can mark when they completed a tutorial (yes/no button, auto-assigning a date when they set it to yes, so HR knows when they completed it. Linking courses to departments/job titles is an idea...