Results 1 to 2 of 2

Thread: err " This field name is not known " ?

  1. #1

    Thread Starter
    Hyperactive Member xray's Avatar
    Join Date
    Jun 2003
    Location
    EgYpT
    Posts
    312

    err " This field name is not known " ?

    hi there

    i want to know why this error happen

    " This field name is not known "

    when i try to open the crystal report

    i am using this code :

    Code:
    Option Explicit
    '
    Dim report_app As New CRAXDDRT.Application
    Dim report As New CRAXDDRT.report
    Dim rep_path As String
    
    Private Function common_report()
    Dim dd As String
    dd = "555"
    
    On Error GoTo reportnotin
    If rn = 1 Then
        rep_path = App.Path & "\" & "all voters.rpt"
    ElseIf rn = 2 Then
        rep_path = App.Path & "\" & "holders voters.rpt"
    ElseIf rn = 3 Then
        rep_path = App.Path & "\" & "holder voters.rpt"
        report.RecordSelectionFormula = "{voter_info.voter_holder}='" + dd + "'"
    End If
    
        Set report = report_app.OpenReport(rep_path)
        report.Database.Tables(1).Location = App.Path & "\db3.mdb"
        'report.Database.Tables(1).Location = "\\192.168.0.90\db\cranet.dat"
        With report.Database.Tables(1).ConnectionProperties
            .Add "password", "2041981asamir"
        End With
    reportnotin:
    
    End Function
    
    Private Sub Form_Load()
    'rn = 1
       common_report
       '
      'report.RecordSelectionFormula = "{voter_info.voter_id}='" + report_for + "' And {tests.test_date_med_wig}=#" + date_now + "#"
       'report.RecordSelectionFormula = "{voter_info.voter_id}=2041981"
       '
       cryview1.ReportSource = report
       cryview1.ViewReport
    End Sub
    how to solve this case >>

    thanks
    In the name of allah , the beneficent , the merciful

    Say (O Muhammad ): We believe in allah and that which is revealed unto us and that which was revealed unto abraham and ishmael and isaac and jacob and the tribes , and that which was vouchsafed unto moses and jesus and the prophets from their lord . we make no distinction between any of them , and unto him we have surrendered


    ---- Great Sites For You -------------------

    If you want to know some small things about islam ?

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: err " This field name is not known " ?

    Does the field you specific exist in your database?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width