Replies

Hi charlotte,
Thts right. Thank God you understand what im written here.
Im using macro because im create a command toolbar like menu bar to open this second database. Thats why i have to use access macro.

regards
nuglorious

hi hans
Thks for your prompt reply and your efforts guidance. I appreciate of yr responds.

regards
nuglorious

thks for your suggestion but what i mean link here is no the direct link but by the file name from the second database i have created a make-up table in the query and copy to the main database. Which means whenever i update frm the second database table then i need to update to my first database table. Thts y i need to open the second database

thanks 4 yr prompt reply. The reason why i use access to open another access is because the other access has a link with the one im using now. So whenever i need to check 4 the updated data, I would open the other database directly instead of go to directory and look on my database.

I hope my explanation will give you an understanding …

Looking forward for your reply ….

nuglorious

Hi HansV

Thks for your prompt reply.

The problem has been solved and it works great. Thks to you again

The open file dialog which you have mentioned here, its a great informations. I will surely learn and use it for my this project.

Thanks n regards

nuglorious

Private Sub ok_Click()
Dim retval

retval = Shell(“C:Program FilesMicrosoft OfficeOfficeEXCEL.EXE D:my documentsfeederratetbl*.*.xls”, 1)

Thanks for your reply.
1) when i in use of Access, i do not want to close n exit database. I want to retrieve data using the form in same database.

2) open dialog file means i have created a dialog file to open a file directory and select files which i want to open….(i do not use common dialog activeX control. Its form design custom to create a dialog)

regards
nuglorious

I have tried use my Win98 but my Win98 doesnt pop up message either for me to choose clean or upgrade…its jsut a normal Win98 CD. This CD will allow to reinstall all the operation and others software. I also tried your second options and so far only 1 files being corrected. Nothing much changes. My IE6 still nothing changes.

Hi,
I have tried but its nothing happened. What do you think and how to slove this problem?

Tht means besides of just create to open lotus email, it can also do more than tht? At first, I was thought only once the lotus email is open, I will key in there in the subject line and the body of the email. If Access can do include the subject line and body as well, then what if i create 2 textbox to input subject line and another for body of the email? Is that what I understanding is correct. If so, I can send email direct from Access instead?

Is there another new version for Win98? Where can I find Win98 {Upgrade Option}? If let say after I have install the upgrade one, will my modem connection which have username and password will still be there and others files as well? As I yet to do backup of all the files and i think i have to do backup first before i install the upgrade one. If really this is the only solution, I would like to try it out rather than just sit there with face..hehehee….So do let me know where or how can I find win98 (upgrade) ok?tks…

ok the following which i have done :-
1) Repair – i have try this tool to repair but failed. The results came out as follows :- ” IE6 could not repaired. Pls run setup again to reinstall all components.” and the detail shows as follows :- ” IE6 cannot repair due to following errors:- FILE CP_20866.NLS IS MISSING, FILE CP_28592.NLS IS MISSING, FILE CP_28591.NLS IS MISSING, FILE CP_28597.NLS IS MISSING, FILE MSXMLR.DLL IS MISSING.

2) Unstall – so i tried this tool as well but failed to do so. The error msg as follows :- “The previous installation has been pending work requiring a reboot.You need to restart your computr to complete that installation before uninstallation Internet Explorer. Setup will now close.”

Uptoday, my IE still not working and function well. Whats the problem? Pls help…

its tht mean whatever records they have added into the table then also as my table will be updated isit?And in future i do not need to use the process again to import the table, is tht correct? If yes, then it should be fine and i hv save my time to import large data every month. thks Why i hv not try use link instead of import…..foolish am i … ..As for Charlotte, thks for your advised .. i take patt advise then….. .

Yes, i want to link to the ODBC database

Thanks its works well. cheers! You are really an expert…….