W
william ho
Guest
There are some limitationswhen developing database working Access Runtime since many functions in Full version MS Access is not supported in Runtime
I am working on a module to open a form and filter on 1 numeric field and 1 date field. It works just fine in my Access 2000 Developer Edition when I put the filter criteria into a string and put it in the Docmd.OpenForm. Then when I try the module in Access 2000 Runtime, the form does not pop up at all. I debug and find that the Runtime does not accept the date in criteria (i.e. [Closing Date]=#9/19/01#). Does anybody know how to fix it?
Thank you!
I am working on a module to open a form and filter on 1 numeric field and 1 date field. It works just fine in my Access 2000 Developer Edition when I put the filter criteria into a string and put it in the Docmd.OpenForm. Then when I try the module in Access 2000 Runtime, the form does not pop up at all. I debug and find that the Runtime does not accept the date in criteria (i.e. [Closing Date]=#9/19/01#). Does anybody know how to fix it?
Thank you!