VBA code error "Expression is not a method"
Isaland
Member Posts: 52
Hello again. When i try to save report, error "Expression is not a method" occurs, and say that mistake at 68 line (second end if in quoted code)
Where i did a mistake?
Where i did a mistake?
Dim CalcQtyOnPage As Integer
Dim PhysQtyOnPage As Integer
Dim LackQtyOnPage As Integer
Dim SurpQtyOnPage As Integer
Dim Modulo As Integer
Public Function CountQtyOnPage(ByVal Counter As Integer,Qty As Integer,Flag As String)
if Counter < 16 then
Modulo = Counter Mod 15
if Modulo = 0 then
if Flag = "Calc" then
CalcQtyOnPage = 0
elseif Flag = "Phys" then
PhysQtyOnPage = 0
elseif Flag = "Lack" then
LackQtyOnPage = 0
elseif Flag = "Surp" then
SurpQtyOnPage = 0
end if
end if
else Counter > 15 then
Counter = Counter - 15
Modulo = Counter Mod 19
if Modulo = 0 then
if Flag = "Calc" then
CalcQtyOnPage = 0
elseif Flag = "Phys" then
PhysQtyOnPage = 0
elseif Flag = "Lack" then
LackQtyOnPage = 0
elseif Flag = "Surp" then
SurpQtyOnPage = 0
end if
end if
end if
if Flag = "Calc" then
CalcQtyOnPage = CalcQtyOnPage + Qty
Return = CalcQtyOnPage
elseif Flag = "Phys" then
PhysQtyOnPage = PhysQtyOnPage + Qty
Return = PhysQtyOnPage
elseif Flag = "Lack" then
LackQtyOnPage = LackQtyOnPage + Qty
Return = LackQtyOnPage
elseif Flag = "Surp" then
SurpQtyOnPage = SurpQtyOnPage + Qty
Return = SurpQtyOnPage
end if
End Function
MB7-840
0
Answers
-
Are you sure you are posting on the correct forum? This is a Microsoft Dynamics NAV (Navision) forum.0
-
I think it was code inserted in RDLC report.Mark Brummel wrote:Are you sure you are posting on the correct forum? This is a Microsoft Dynamics NAV (Navision) forum.~Rik~
It works as expected... More or Less...0 -
Ah. ROFL.
It looks like we need to be able to solve everything from Windows, to SQL, and VBA.
0 -
Mark Brummel wrote:Ah. ROFL.
It looks like we need to be able to solve everything from Windows, to SQL, and VBA.
It seems
~Rik~
It works as expected... More or Less...0 -
Why not?Mark Brummel wrote:Ah. ROFL.
It looks like we need to be able to solve everything from Windows, to SQL, and VBA.

P.s. I have mistake in code, now it`s ok :roll:MB7-8400
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 330 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
