I have a problem with a database which I cant understand for the life of me, no tsure if anyone has experienced this, any suggestions woul dbe welcome.
My database is not large its not complicated and there is nothing unusual
It consists of a table and one query with names and addresses
A form ehich has nothing other than 10 hyperlinks, these are hyperlinks to word docs. c:\customerLetter1.doc etc
The word docs are linked to the query
theidea is that I click on a hyperling which produces a popup box prompting for an ID, I input the ID and the Word doc opens with he acorrect address merged. BUT when I click on the hyperlink I get the pop up box as soon as I input and ID and click OK the database closes and the word doc does not open.
here is the strange thing, if I craate a new database the has no tables or queries I import the form containing hyperlinks from theoriginal database, now if I use the second database and click on a hyperling I get the pop up box ,I input an ID - this then opens the original database containing the addresses and the word doc is open and the correct address is merged.
I need to have the hyperlink form and data in the same database
can anyone shine any light here please, it's beating me into the ground
thanks
My database is not large its not complicated and there is nothing unusual
It consists of a table and one query with names and addresses
A form ehich has nothing other than 10 hyperlinks, these are hyperlinks to word docs. c:\customerLetter1.doc etc
The word docs are linked to the query
theidea is that I click on a hyperling which produces a popup box prompting for an ID, I input the ID and the Word doc opens with he acorrect address merged. BUT when I click on the hyperlink I get the pop up box as soon as I input and ID and click OK the database closes and the word doc does not open.
here is the strange thing, if I craate a new database the has no tables or queries I import the form containing hyperlinks from theoriginal database, now if I use the second database and click on a hyperling I get the pop up box ,I input an ID - this then opens the original database containing the addresses and the word doc is open and the correct address is merged.
I need to have the hyperlink form and data in the same database
can anyone shine any light here please, it's beating me into the ground
thanks