“Enter Parameter Value” dialog box unexpectedly appears
4 Comments so far
Leave a comment
June 12, 2010, 8:11 am
Filed under: Uncategorized
Filed under: Uncategorized
Environment: MS Access 2003 – VBA
For you who have problem with “Enter Parameter Value” dialog box in Access and end up in this page and you’ve done all steps in that page but still have that dialog popping up, this might be the case:
Case:
- You have a query bound to a form/report
- On form/report open, there is an unexpected dialog “Enter Parameter Value” with a field to fill in the specified parameter
Solution:
- Make sure whether that parameter exist in your query or not
- Check the parameter type, if it is a text data type then you have to use “like” in where statement instead of “=”
It’s simply like that, I don’t have any idea why this is happening :p
Advertisement
4 Comments so far
Leave a comment
Legacy system perhaps?
*kabur ke timbuktu*
Comment by Eru June 14, 2010 @ 1:58 amMohon maaf ini teknologi apa ya?? koq saya belum pernah dengar selama jadi programmer Dot Net. Mohon pencerahan dari Bapak.
Comment by hendra June 14, 2010 @ 3:12 amto be or not to be the parameter, that will be the out of question if they popped out on the window ‘eeeh’
ora dong blas ja’ne je ‘ngeglundung balik ke kebon’
Comment by ansella September 15, 2010 @ 9:05 ammana ni postingan crita2nya, we want drama!!! *gapentingwkkk
Comment by tiiikaaa November 25, 2010 @ 4:48 am