When button is pressed from Forms of MS-Access, a file open dialogue box is displayed. I need the VB code.

Recommended Answers

which vb code u need

Jump to Post

hI,

Use "Microsoft Common Dialog Control " , add it from Projects>Components:
"Microsoft Common Dialog Control 6.0"

add it to form and in command Click :

CommonDialog1.ShowOpen    
    FileName = CommonDialog1.FileName

Set "Filter" property to filter particular File extensions

Regards
Veena

Jump to Post

All 6 Replies

which vb code u need

code to open a File open dialogue box by pressing button. through this, one can load different files in the textbox.

hI,

Use "Microsoft Common Dialog Control " , add it from Projects>Components:
"Microsoft Common Dialog Control 6.0"

add it to form and in command Click :

CommonDialog1.ShowOpen    
    FileName = CommonDialog1.FileName

Set "Filter" property to filter particular File extensions

Regards
Veena

Thanks for ur help.

thanks for help

What would be the code if log book is maintained by the secretary of the company to calculate and manage the leave days taken by the employees. The secretary is able to view the information of an employee except their salary remuneration. The basic principle of the company is that each employee is allowed to take 30 days of paid leave per annum. The system does not allow an employee to take more than 30 days of leave.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.