|
-
Jun 2nd, 2008, 05:56 AM
#1
Thread Starter
Hyperactive Member
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 ?
-
Jun 2nd, 2008, 06:43 AM
#2
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|