timer event

I

inchong

Is there a way that i can open one form to another form with longer
time?
i tried to use ontimer event and time interval property but it doesn't
seem work.
can anyone tell me a full step to do this?
please advise.
Thanks
 
S

storrboy

Is there a way that i can open one form to another form with longer
time?
i tried to use ontimer event and time interval property but it doesn't
seem work.
can anyone tell me a full step to do this?
please advise.
Thanks


Can you please clarify what...

Is there a way that i can open one form to another form with longer

means?
Thanks
 
I

inchong

Ok. sorry.
I remember you. you helped me for runtime error 2450. thank you!
i have a few steps but i am not going write all.
when i open one form, this form bring datas from a different location
on the same network.
for example,
i enter a customer number and click Documents button.
a first document displays and there are additional documents
associated with that customer.
I click another button to see additional docs, this form is the
document search form.
i choose a different doc in this form. this form finds a right doc
whatever i select and i click Preview button to see it. - and
Documents-Additional form appears.
Additional documents are stored in a different place as .mdb file.
Sometimes there is a problem on a network. ( i think? becuase i have
experienced wierd things using these two db files lately. i haven't
figured out why it is doing....
i get runtime error or .....) ex) i can view additional documents but
some users can't view them. ???
so i think, between Document search form and Documents-additional
form, give a little time to Document search form to find an addtional
doc on a network.
maybe i think wrong. i don't know what i am writing.let me know.
Thanks.
 
S

storrboy

i get runtime error or .....) ex) i can view additional documents but
some users can't view them. ???

Does this mean you get an error? Others do? What error?

so i think, between Document search form and Documents-additional
form, give a little time to Document search form to find an addtional
doc on a network.
maybe i think wrong. i don't know what i am writing.let me know.
Thanks.

How does this form 'search' or 'find' a document? Is it a record in a
table or are you actually location an external file on the network?
What formats can these documents be in?
 
I

inchong

between Document search form and Documents-additional form, give a
little time to Document search form to find an addtional doc(this is
stored in a different db and folder but in the same network.
anyway, Document search form has a subform, which has all the location
for each additional documents. i should mentioned this a long time
ago, sorry.
[Forms]![Document Search Form]![Lease/Docs/DB Name subform].[Form]!
[DatabaseName] this tells where the additional doc is located.
ex) [DatabaseName] - \\server\Customer\Scanned Documents\Docs1.mdb
- an external file on the network?
What format - OLE object

someone told me that it might not find this location fast enough when
users try to open Documents-Additional form.
i was researching about how to delay time for opening two forms? is
that something i have to do in Operation system?
i am a beginner in access. i took access class but you know how a
beginner class is....
Thank you. let me know if you need more infomation.
 
S

storrboy

Well you didn't mention what the error was.
As for added time - I don't think so. When a form opens it does most
everything it needs to do before it is visible. So if you can see it,
it's done. You can use the form timer to delay it's visibility, but
all the work has been done by then so don't see how that will help.
This sounds like a connectivity issue. The person(s) responsible for
managing the network should likely be involved.
 
I

inchong

Well you didn't mention what the error was.
As for added time - I don't think so. When a form opens it does most
everything it needs to do before it is visible. So if you can see it,
it's done. You can use the form timer to delay it's visibility, but
all the work has been done by then so don't see how that will help.
This sounds like a connectivity issue. The person(s) responsible for
managing the network should likely be involved.

thank you!
My previous error was runtime error 2450 when i tried to open
Documenst-Additional form in database window,
You said, according to the code, it is expected Document search form
to be opend. so i added Docmd.openform "Documents-Additional" and the
error was gone.
i still want to figure out about it but not now. i was thinking about
a network problem,too becuase some user could, others not. I wasn't
sure.
what other things cause this?
Then i asked my boss. he said to me do some research about how to
delay time in Access in order to bring the data(external) outside the
currnet opening database(Customer). Additional documents are stored in
a different database but on the same server.
anyway, thank you for your great help. this is my first job and i want
to be good. still lots things to study and learn.
Thank you
 
Top