File Dialog Box is not working in Access 2003

Hi Experts,
I build one application using Access 2003, and used File Dialog box to open and select the Text file for import purpose. This browse button is working fine on my machine but when i deployed the application on client machine which also Access 2003. Browse button is not working.

I even try to use custom function written by one MVP-ACCESS. which works on my machine but not on client machine.

whats wrong with that machine..... any help


Thanks in advance for your time and help.

-permood
LVL 1
ExpertProAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shanesuebsahakarnCommented:
When you say this:
> I even try to use custom function written by one MVP-ACCESS

Do you mean the function here:
http://www.mvps.org/access/api/api0001.htm

? I would suspect something wrong with comdlg32.dll, but this is a fundamental Windows component. Have you tried changing your error handling to "Break on all errors" to see if an error is being generated?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ExpertProAuthor Commented:
shanesuebsahakarn,

Thanks for your quick Answer, I am not sure if the both function are same, but i took that code long time ago, and forgot the source. but yes, that function use to work in Access 97 and now its working Access 2003 too. but its not working on Client's computer.


We both using windows 2000 professional and Access 2003. I can't understand why File dialog box is not working when i am using built in commondialog ....do i need to check any library for that....

what am i missing here... ....
0
shanesuebsahakarnCommented:
Does it give any errors or does it simply not work? Have you tried changing the debug mode? (VBA editor, Tools->Options->General->Break on all errors).
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ExpertProAuthor Commented:
one more thing...


I checked both machine have Reference to

                       Microsoft common Dialog control 6.0 (SP3)

is there another library i need to reference to call microsoft built-in file dialog box......
0
shanesuebsahakarnCommented:
No, that reference is only relevant if you are using the common dialog ActiveX control (the FileDialog object and the API code don't use this).
0
ExpertProAuthor Commented:
shanesuebsahakarn,
Thanks again. There is not error, simple command button is not avail. I try to compile but didn't get any error message.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.