Recent content by taifoor

Hi. I have seen your DB. Your DB also not stoping Fn+Break Key.

Great Work. Could you please guide me which code i have to copy in my DB and modify it accordingly to block Fn+Break Key for my DB only. Please note that in my DB, i have to use shortcut keys for my button by Alt Combination. Alos could you please check for DB Property AllowBreakIntoCode. Will...

Thanks. But i need to do that only for My Database. So this solution seems not perfect fit. For other keys, i used following code on KeyDown Event of relevant forms e.g. ------------------------------------------------------- If KeyCode = vbKeyPageDown Then KeyCode = 0 ' Kill the keypress...

Thanks for your help. I do go through that. But my keyboard have break key to be run with Fn+Break. So its not stopping this Fn+Break.

Dear All, I need to disable functionality of Ctrl+Break or Break Only Or Fn+Break. I am using Autokeys Macro but Autokeys Macro do not supporting Disabling Break Key i.e. {Break}. Please help.

In Ms Access 2010, A form can be viewed as Pivot Table. My question is specifically for that context. In Ms Excel Pivot, i founf an option of Show Value as Running Total on a field while in Ms Access 2010, this specific option is not available. It will be good if someone give guide as to...

Dear All, I am using Ms Access 2010 Pivot table form. I have sales amount by each year presented as Like below and it also contains the desired result: https://docs.google.com/spreadsheets/d/1YUVboEHQKxiSP1VUgQVir5NqE9PG5QpZXZMnZE_lCKk/edit?usp=sharing I am trying calculated fields option...

Right. So I need any solution ...... I am trying by myself too but still not getting lucky :)

Yes. I know its different. U suggested to use Nz with amount not with sum. But its not working as using Nz is the main problem.

I also tried that but its not exporting to excel. I have also tried IIf(isnull(sum([Amount])),0,sum([Amount])) but no luck.

Dear All, I have to sum an amount column in report footer. When is use Sum([Amount]) formula, then it exports ok. But when i use Nz(Sum([Amount]),0) it do not exports to excel. I think its beacuse Nz is not supported by Excel. So my obejctive is to sum in footer and show 0 if all values of...

CJ_London: Your code works as u suggested to use the code in Got Focus event of all controls. I tried the sugguesstion of Linq who suggested to put code on Lost focus event of control that needs to be always visible. Thats not wokring means no code is run as control lost focus event do not...

Its NOT working if i put code in lost focus event. I need only to always show a single specific field that i named here as TextBox1. Also i dont want to put code on all controls got focus event as this is poor procedure and needs to be always checked/monitored. I think its better to add code in...

The solution in link is for recordsets ... i dont know how to use it for all of my form feilds with two subforms too ....

Dear CJ_London, I also have some other code in timer event of some forms. The code is '---------------------------------------------------------- ' To refresh form after print preview closes If PrintPreviewClicked = "Yes" Then DoCmd.Echo False DoCmd.RunCommand acCmdRemoveAllFilters...