Search results for query: *

You're right, my boss just told me the same thing. I will include the name of the main report and subreport. Thanks

You're right Text35 was spelled Txt35. Now the code works thanks so much for you help Ismail

Hi, This is driving me crazy. I have a report (let call it Report1) with the following code: Private Sub Report_Activate() If Me.Memo = "CONTRACT TYPE: INDIVIDUAL" Then Me.Check39 = False Me.Check51 = True Me.Label49.Visible = False Me.Text37.Visible = False Else Me.Check39 = True...

thank you. It was there.

Hi, I want to allow a user to enter only 16 digits in a text box (no less no more) and the character can be either letters or numbers. How do I do that? Thanks in advance Ismail

guys, Thank you much for your help

it still does not like this line: If Me.Text35 = "CONTRACT TYPE: GROUP*" Then thanks

Can anyone tell me why this code is not working? Thanks in advance Private Sub Report_Open(Cancel As Integer) If Text35 = 'CONTRACT TYPE: GROUP*' Then Check39 = True Else Check43 = True End If End Sub

THANK YOU

Hi, I have a text box with the following data: contract type: Group (Global IPA) contract type: Group (UPA) contract type: Group (QLIMG) contract type: Group (Atlantic) I would like to retrieve only the following: Global IPA UPA QLIMG Atlantic Is it possible. Thanks Ismail

Thanks for the tip. I'll check the site Ismail

that's it. thank you. to be honest with you I never used the SENDOBJECT Command before. Ismail

Hi, I ran reports once a day (at 4PM or later) then these reports are exported to two separate excel sheets one called: DailyAuth and the other called: DailyAuthMCR. Then I use 2 email templates to email the 2 sheets. One template called: Daily Authorizations sent to a group of people with...

Hi, I ran reports once a day (at 4PM or later) then these reports are exported to two separate excel sheets one called: DailyAuth and the other called: DailyAuthMCR. Then I use 2 email templates to email the 2 sheets. One template called: Daily Authorizations sent to a group of people with...

Well explained. Thank you very much Ismail

Thank you very much

Can anyone explain the meaning of SET NOCOUNT ON and SET NOCOUNT OFF in the following code: USE pubs SET NOCOUNT ON GO DECLARE @pub_id char(4), @hire_date datetime SET @pub_id = '0877' SET @hire_date = '1/01/93' -- Here is the SELECT statement syntax to assign values to two local --...

thank you

Can anyone explain the meaning of SET NOCOUNT ON SET and NOCOUNT OFF in the following code: USE pubs SET NOCOUNT ON GO DECLARE @pub_id char(4), @hire_date datetime SET @pub_id = '0877' SET @hire_date = '1/01/93' -- Here is the SELECT statement syntax to assign values to two local --...

You right, the reason the number was not being added was because the field was on number not autonubmer. Thanks so much for you help and patience.