Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ielamrani
  • Content: Threads
  • Order by date
  1. Ielamrani

    subreport not working

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

    Limit a text box

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

    code

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

    Retrieve data

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

    Automate reports

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

    Automate email

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

    Nocount On/Off

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

    Nocount On/Off

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

    Primary key blank

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

    Lock subform

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

    Save a report in PDF Format

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

    Delete duplicate from a table

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

    View value of text in a form in a table

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

    List Total

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

    subform question

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

    Seperate Names?

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

    Field Lenght

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

    Print result of list box

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

    Report Form

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

    Error message

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

Part and Inventory Search

Back
Top