Search results for query: *

OK but behind the form there are 5 forms are still attached to this one right? Also what I forgot to mention I want users to have only one form without a whole Access.mdb is this possible and I think it is but if one form has another 5 to call wouldn't having one form for a user to see become...

I just think it was awesome help so here is the star for you Hawi! WOW!

I have a few sets of reports for different departments. I need a form that will have names of the departments and when they click it should bring that department feom with bunch of reports to run. My question is how to make it pretty? I know I can have a Main Form with macro running on click...

Thanks so much!

I got it! Please, comment on improvement! Private Sub Recruiter_ID_Name2_AfterUpdate() If IsNull(Me.BUSINESS_UNIT) Then Me.Recruiter_ID_Name2.Enabled = True Else MsgBox "Only one parameter allowed for this Report!", vbExclamation Me.Recruiter_ID_Name2 =...

OK, I solved it. Please, comment if can be improved! Private Sub Recruiter_ID_Name2_AfterUpdate() If IsNull(Me.BUSINESS_UNIT) Then Me.Recruiter_ID_Name2.Enabled = True Else MsgBox "Only one parameter allowed for this Report!", vbExclamation...

Sorry what is trhe 'code module for the form'? I am inserting it as General CbxCtl...

Nevermind last question...it is NO right?

Wait! Should I substitute CbxCtl with something in : Private Sub CbxCtl(ctl As Control)??????? Thanks

wow! THANKS I am getting an error 'Invalid use of NULL' here oppName = Switch(ctl.Name = "ComboName1", "Comboname2", _ ctl.Name = "Comboname2", "ComboName1") Yes I did substitute with names I have on my form. I can select value in the first one and when I am clicking on the...

Me.cboBusiness = Null ONLY IF another box is <> NULL... OK here again. I have a Form with 2 combo boxes. Report can be only run for 1 combo box value. So when user picks value in one combo box and leaves another empty - Report is running fine. IF for some reason user picked value in one combo...

Sorry I was not clear. I have 2 combo boxes. Report is to be printed for one value only. When user selects the value in one and wants to select a value in another one - he is not suppose to be able to. So OnClick I am writing an error message and I would LOVED if when used clicking OK to the...

I want advise. I wrote this Private Sub Business_Unit_Click() On Error GoTo ErrHandler Me.BUSINESS_UNIT.Enabled = False ErrHandler: (it is a wrong one but for example it works) If Err = 2501 Then ' Report canceled - ignore this Else MsgBox Err.Description, vbExclamation End If End Sub I am...

When value was deleted out of the combo box - is it different then if it was empty to begin with? I am having problem to have second box become Enabled when values are deleted out of the first combo box... Please, help.

How do I code this in If user erased value in one box - another becomes Enabled again?

What I am using right now disabling a second one if value in one picked. I need not to erase but not to disable but get a message for user to not to touch another IF one value had been picked. Private Sub Business_Unit_AfterUpdate() If IsNull(Me.BUSINESS_UNIT) Then...

I have 2 combo boxes on a form. Report can be run for only either - or value. If empty - brings all data. So if user is picking the value in one of the boxes and then trying to pick in another - message should appear like 'Report can be run for one value only' BUT if they change their mind...

How do I prevent information in Report Header to be printed on a last page? Thanks

Sorry wrongly described above. Nevermind it.

Hi! I had almost finished Report with 2 subs. And of course ran into issue. I have Main and 2 sub reports. Second sub is the summary of the 2 and suppose to be printed at the last page like standalone page. I have Page Header that has Report Name and PersonalID. Than I have JobID section...