If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access queries running slowly using forms objects in criteria
Anyone know anything about this?
I'm using MSAccess 2003 sp2 and I have several queries that run quickly when I use hard values or prompts in the criteria line but as soon as I try to use a value from a text box or combo box on a form they grind away for minutes on end. Thanks, Tom. |
#2
|
|||
|
|||
Access queries running slowly using forms objects in criteria
If the controls on the form are unbound, then Access may not know what the
datatype is, which can cause performance issues. Maybe wrap the parameter with cint, cdate, or other function to help it better understand? e.g. CInt([Forms]![formname]![controlname]) (You could also try using the parameters declaration box to specify the datatype, too. I've never tried it with this syntax, so don't know if it will work. Choose Query / Parameters from the Menu.) -- Steve Clark, Former Access MVP FMS, Inc http://www.fmsinc.com/consulting "Tom Telford" wrote: Anyone know anything about this? I'm using MSAccess 2003 sp2 and I have several queries that run quickly when I use hard values or prompts in the criteria line but as soon as I try to use a value from a text box or combo box on a form they grind away for minutes on end. Thanks, Tom. |
#3
|
|||
|
|||
Access queries running slowly using forms objects in criteria
Thanks, I'll give it a try.
Tom. "S.Clark" wrote: If the controls on the form are unbound, then Access may not know what the datatype is, which can cause performance issues. Maybe wrap the parameter with cint, cdate, or other function to help it better understand? e.g. CInt([Forms]![formname]![controlname]) (You could also try using the parameters declaration box to specify the datatype, too. I've never tried it with this syntax, so don't know if it will work. Choose Query / Parameters from the Menu.) -- Steve Clark, Former Access MVP FMS, Inc http://www.fmsinc.com/consulting "Tom Telford" wrote: Anyone know anything about this? I'm using MSAccess 2003 sp2 and I have several queries that run quickly when I use hard values or prompts in the criteria line but as soon as I try to use a value from a text box or combo box on a form they grind away for minutes on end. Thanks, Tom. |
Thread Tools | |
Display Modes | |
|
|