Search results for query: *

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

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

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

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

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

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

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

Hi, Does anyone know a solution for this problem: Whenever the user add a new record a Prospect key number is generated by the database. Now all the info entered is there except the prospect key (blank). Your help is appreciated. Thanks. Ismail

Can anyone tell me why this is not working? If UCase(Text57) = UCase(Me.Combo66) Then Me.frmForPhysicianRep.Locked = False Else Me.frmForPhysicianRep.Locked = True End If End Sub I have a form(frmMain) with a subform (frmForPhysicianRep) in it. If the value in text57...

Hi, I have an access report called "ReportR -MainReport". I would like to create a button in a form, once I click on this button the report will be transfered to a folder in PDF Format. This is a routine that I do everyday and I am looking to automate it. Thanks in advance

Hi, I have a table with data like this: LastNm FirstNm Smith John Jordan Al Jordan Al Sheriff Ahmed Sheriff Ahmed I would like to eliminate duplicates from a table and keep only one record for each person. The query would give...

Hi, I have a text box (Text145) in a form (MainForm), Text145 control source equal the following: =[TMarketingCall subform].Form!CallBackDt MainForm is linked to MainTable What I would like to do is: to be able to see the value of Text145 in another field in MainTable. How do I do that? I...

Hi, Is it possible to generate the Total of a list box on a text Box? thanks Ismail

This sounds very simple but I am having trouble making it work. I have a form (frmMain)with a subform in it. in the frmMain I have a text box called txtDate and another text box in the subform called txtCheckDt. what I am trying to do is: whatever date is typed in txtCheckDt (in subform) should...

Hi, i have a name like this: Smith John I would like to seperate smith from John. In other words put Smith in one field and John in another field. There is a space between smith and John. Thanks Ismail

Can anyone please tell me why this is not working. I am trying to see field street2 where lenght is Greater than 10. SELECT DISTINCT dbo_PROV_MASTERS_HCVW.PROVID, dbo_PROV_MASTERS_HCVW.LASTNAME, dbo_PROV_MASTERS_HCVW.FIRSTNAME, dbo_PROV_ADDINFO_HCVW.STREET, dbo_PROV_ADDINFO_HCVW.STREET2...

Hi, I have a list box that displays some information. What I would like to do is create a button to transfer the information from the list box to excel. Does anyone know the code to put behind the button to make it work? I hope this is clear Ismail Thanks

Hi, I usually run reports for other department but my boss wanted me to create a form where users can run their own reports. Does anyone know an easy way to create a form where a user can choose a table and criteria (like running a query) and then he/she will have the ability to export it. I...

Can anyone tell me why I get the following message: Data type mismatch in cretiria expression. The query open for about 10 seconds and then I get the above message. I can't copy the query or export it. Here is the code behind it: SELECT DISTINCT Mid([Street],1+InStrRev([Street],' ')) AS...