Connecting Tech Pros Worldwide Forums | Help | Site Map

isLoaded not happening in split database

bbdata
Guest
 
Posts: n/a
#1: Nov 13 '05
strange thing happened when i split my database.
i have a search form where you enter parameters, and get back filtered
records displayed on another form. when you close this one, theres a
code in OnClose event which clears all fields on search form.
the code which was working perfectly well previously, now is newer
happening, because when it gets to

If frm.isLoaded then
---code here
endif

it goes straight out of the if , as if the form is not loaded. but it
is.
and everything is painfully slow, and i did compact and change
subdatasheet name to none.
any suggestions?

Allen Browne
Guest
 
Posts: n/a
#2: Nov 13 '05

re: isLoaded not happening in split database


The IsLoaded property relates to objects of type AccessObject.
The variable "frm" is generally used for objects of type Form.
What declaration did you use for your frm variable?

Regarding performance, work through the list at:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"bbdata" <predrag.nikodijevic@cibc.com> wrote in message
news:46f5da80.0503110850.77b7589f@posting.google.c om...[color=blue]
> strange thing happened when i split my database.
> i have a search form where you enter parameters, and get back filtered
> records displayed on another form. when you close this one, theres a
> code in OnClose event which clears all fields on search form.
> the code which was working perfectly well previously, now is newer
> happening, because when it gets to
>
> If frm.isLoaded then
> ---code here
> endif
>
> it goes straight out of the if , as if the form is not loaded. but it
> is.
> and everything is painfully slow, and i did compact and change
> subdatasheet name to none.
> any suggestions?[/color]


Closed Thread


Similar Microsoft Access / VBA bytes