Prikazi cijelu temu
03.11.2020 11:55
03.11.2020 11:55
Predmet:Re: Access 2000
mdb
pokrene se program i
i može da se uđe u program
ali neće da rade funkcije preko formi
nešto sam čito na netu
When you put in a parameter in the query line that comes from a variant data type, (such as a function which has no type or a field from a form, Forms!MyForm!MyCriteriaField, Access can misunderstand what datatype you are using. If you enter 1/1/97 in a field on a form, is that text, a date, or a mathematical function. The functions CInt, CLng, Cstr, CVDate, CDbl and all the rest, ensure that you are using the correct data type when there could be some confusion. In the full retail version, if Access is unsure as to what the type is, it gives you an error message, however, at times the runtime will just die a painful death (GPF). Making sure that all of your queries with parameters have been specifically cast using the CStr, etc. functions have eliminated many GPF's in runtimes for me.
proba sam i kao administrator
mdb
pokrene se program i
i može da se uđe u program
ali neće da rade funkcije preko formi
nešto sam čito na netu
When you put in a parameter in the query line that comes from a variant data type, (such as a function which has no type or a field from a form, Forms!MyForm!MyCriteriaField, Access can misunderstand what datatype you are using. If you enter 1/1/97 in a field on a form, is that text, a date, or a mathematical function. The functions CInt, CLng, Cstr, CVDate, CDbl and all the rest, ensure that you are using the correct data type when there could be some confusion. In the full retail version, if Access is unsure as to what the type is, it gives you an error message, however, at times the runtime will just die a painful death (GPF). Making sure that all of your queries with parameters have been specifically cast using the CStr, etc. functions have eliminated many GPF's in runtimes for me.
proba sam i kao administrator