DLookupStringWrapper (1 Viewer)

H

Hek

Registered User.

Local time

Yesterday, 18:05

Joined

Oct 30, 2018

Messages

73

• Sep 25, 2019

• #1

Hey guys

So im trying to make a duplicate of the Northwind sample database as a learning task to help me get better at using Access and VBA.
I have run into an issue with:

Code:Copy to clipboard

Private Sub InitFilterItems()
    Me.lstReportFilter.RowSource = DLookupStringWrapper("[Filter Row Source]", "Sales Reports", "[Group By]='" & Nz(Me.lstSalesReports) & "'")
    Me.lstReportFilter = Null
End Sub

The DLookupStringWrapper is returning a "Compile Error: Sub or Function not defined" error, any ideas why?

Cheers in advance for any help


-Rhys

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 09:05

Joined

May 7, 2009

Messages

19,229

• Sep 25, 2019

• #2

you need to copy module, DomainFunctionWrappers from Northwind db.

 

H

Hek

Registered User.

Local time

Yesterday, 18:05

Joined

Oct 30, 2018

Messages

73

• Sep 25, 2019

• #3

arnelgp said:

you need to copy module, DomainFunctionWrappers from Northwind db.

Click to expand...

Cheers man, just as you answered i figured it out xD

Cheers heaps for the help man, i really appreciate it.

Regards,
Rhys.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 09:05

Joined

May 7, 2009

Messages

19,229

• Sep 25, 2019

• #4

you got it!