98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Dlookup
Dlookup
Resolved · High Priority · Version 2003
Fri 26 Sep 2008, 09:59Delegate Paul said...
Paul has attended:
Access VBA course
Dlookup
I've done lots of dlookups before but don't understand why this one isn't working.
I have a table called tblMonths which contains the fields MonthAndYear (content e.g. "September 2008" in text) and PriorMonth (number - single format, contents e.g. 200809)
This table is used successfully to populate cmbTeam on form frmTeamKPIs.
The dlookup reads:
=DLookUp("[PriorMonth]","[tblMonths]","[MonthAndYear] = " & """ & forms.frmTeamKPIs.cmbMonth & """)
I get a blank field when trying to run.
Can you help??
Thanks
Paul
Fri 26 Sep 2008, 11:24Trainer Laura said...
RE: Dlookup
Hi Paul
I hope I undersatand your question correctly and that the field MonthAndYear contains text in the same format as cmbMonth on the form.
Building a criteria to look in a text field I would usually use a single quote, ie
=DLookUp("[PriorMonth]","[tblMonths]","[MonthAndYear] = '" & forms.frmTeamKPIs.cmbMonth & "'")
If that doesn't work try doing a debug.print of the criteria to make sure it looks okay.
Let me know how you get on.
Laura
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
