Recent content by krunalprajapati

Hi all Need some help..... I have written a code in Worksheet_FollowHyperlink(ByVal Target As Hyperlink) event in a worksheet. In Excel help(F1), the help shows this event "Occurs when you click any hyperlink on a worksheet." but when i click any hyperlink in the worksheet the event is not...

Thnks for the Help

Hi all Is it possible to mail the selected content from Excel directly into default mail. Need help... Krunal

Hi All i have a mde file, which is in a folder on server. the folder is shared with full rights to all users. but by mistake if a user deletes the mde file than? i have the source file, but the data will be in mde file only. i made the folder read only, but than the user can not make entry in...

thnks thnks it works. i have the habit of closing it. but when users going to use it, and if they knw Access and working on another databse of their own, and close Access with opened Propertysheet, than wht? thts why i want this. again thnks..

Dear all I have created an application in Access, it has startup form set with a menu in it. when I close my MS Access window and if the Propertysheet window is opened when I close Access, than Next time when I open the Application it will open the Propertysheet window too. I want to close the...

Thnks OldSoftboss... this is wht I want....

thnks gemma-the-husky. i got the solutioin. I Used this code to make the menus enable or disable. and the commands are direclty put as a menu. Application.CommandBars("Training").Controls("LOGIN").Enabled = False thnks anyways...

Even this is not working... DoCmd.SetMenuItem 0, 1, , acMenuGray any help regarding this....

Custom MenuBAR HI Everyone, I searched the forums, and i got one solution but, still i want a help. i have a menubar created using customize command. Now i want to make enable & Disable some of the commands in that menu. I got following code for enbling or disabling the menus on custom menu...

u can write code to open report in the button's click event. just write "docmd.openreport" and spacebar, it will open a help of the function below ur code and u can write wht u want to do.

do onething. select the text box or the control on which u get the err, thn in the Record Source property click the down arrow, this will display the columns of the table u attached to the form. if the given name is there than it is selected automaticcaly else u have to select from the list.

Use the below code in ur command button click event. see help(F1) for this command. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 hope this will help u.

Thnks all of U. why i didn't think to make a file? anyway thanks a lot, i will do that.

pls Help, I knw how to change the background of a form. but i need a particular file for the background. and i want to knw where the file is stored? the file which i want is a texture file in a WORD. i.e. in word when we try to set the background of a page, the option Background gives us some...