Search results

Hi, My database records managers ratings of sales peoples competencies. I have designed a form for managers to enter this data which works ok. My manager now wants to insert a chart in a seperate window linked by a button to show progress of the sales reps/team depending on the manager(Team...

Yes that helps and worked.

Hi, I'm not the best with SQL but could you please give me a hand to write the code? Thanks, Noreen

Hi, I want to display a list box dependent on a choice from a combo box which is working fine. However, to further complicate the db - When the results of the list box are displayed, I need each of the results to display a combo box (for rating) dependent on how many results are displayed...

Hi, I want to insert a label box (title)in a form that will display text that depends on what the user picks from a combo box as it will linked to a main form through a button? Is this possible? Thanks for your help in advance of it Noreen P.S I am looking for a lot of help today so I...

This if statement is incorrect as I have another combo box dependent on it and it doesn't update so I have to reselect. Is there a way to have an if statement with select rather than typing the value?

Re: If Statement Updated Hi there, I tried this but now it's selecting New Hire Belt for everybody. Also FYI, Tenure is not displayed on the form Option Compare Database Private Sub Combo12_AfterUpdate() Me.Competency = Null Me.Behaviour = Null Me.Competency.Requery End Sub Private Sub...

Please help with If Statement Hi there, I have a form that has details of a competency Matrix with 5 combo boxes: Team Leader Rep Name Belt Competency Team Leads Rating I have the form set up to after updates etc with the following code: Option Compare Database Private Sub...

Oh cool got it thanks a million for all ye're help:D

Haha, it does now that Ive read over it again!!! One last question before I leave you be! I created a button in the db is there anyway I can give a description if someone overs over this button with their mouse? I have been trying to find this out for quite a bit If you could answer it...

Haha Yea, I've learned a lot this morning, more than a days training at the training center! Fantastic forum to get help from :):D:D:D Forgot to say: You should be star bar named :) ;)

Hi, You were fantastic, really patient and helpful :) so proud we did that!!!! Wouldn't have been able to solve without your help. BEST STAR BAR ;)

Nevermind I found it! Thank you :) Can I give you a good rating or something?

Perfect, you wouldn't know how to do that by any chance? Thanks a million!

I autoexcued it to open with a macro so it opens so that's solved. However, this is bringing up the training done FORM first is there anyway in a macro to assign which form opens first? Also it is only the way we describe the form it is NOT a report Thanks a whole bunch for all your...

Hi, just going on lunch I promise I will try whatever you suggest when I come back - Thanks a million for all your help You're a star bar :)

It works once you open the Training Done form first but this is not what I wanted as I have a button in Prog_Report to open Training Done Report is there anyway I can stop this or do I have to develop a macro to open training done form first? As the button has now become useless apart from...

Prog_Report

Private Sub RepName_AfterUpdate() Forms("Training Done").Controls("Training").Requery End Sub

It's definitely saved as Training Done so this means it s called it right? So that only leaves subform - I inserted a button to open training completed does that make it a subform?