Search results

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.

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...

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...

Dear All, I am facing a problem. It may be a bug. I have used timer events on my forms with interval of 1000. On timer event has very small code i.e. me.textbox1.columnhidden = false. Now the problem is that due to this timer event, some code in my other forms and reports not working. I mean...

Dear All, I have a project with one BE and multiple FE users. Each user has its own FE connected to one BE. My problem is that i have used combo boxes in forms that limits data entry to specific tables fields (Using limit to list property). I got conflict in data entry. To understand conflict...

Dear All, I have a form with a datasheet subform. When user adds data on form, the subform data is programmed to change with the help of some queries. BUT then when user manaually do some chnages in subform, ms access give dialog of either save record or drop changes. It seems like ms access...

Dear All, I have added a custom ribbon buttons by adding following xml <group id="format" label="Format"> <control idMso="Bold" enabled="true"/> <control idMso="Italic" enabled="true"/> <control idMso="Underline" enabled="true"/> <control idMso="FontColorPicker"...

Dear All, I have designed ann invoice form where user enters data like inventory, quantity, rate etc. The form has its own formatting that is not changable. Now i want the user to print that form data i.e invoice in a format that he can design or change by himself. However, I do not allow...

Dear All, I have a project having front end and backend DB with multiuser login logout function. Each user has its own FE. In each FE, there is are reports that i want to be shared with other users too at the same time (Similar to data in backend). Is there any work around in which a report is...

Dear All, I want to allow horizontal scrolling of subform while allow addition property is set to false. Why allow addition property setting to false freezes my subform to scroll horizontally. Please note that my subform is continuous form.

Dear All, I have designed a MainForm having a related subform and that subform has datasheet view and showing multiple records. My requirement is to save the mainform record and all the subform records only by a save button and not before in any case. So i have managed that by using temporary...

I have a form with a supreport on it. On form, there are buttons to change the width property of textbox on subreport in realtime. What i want is to save this changed width permanantly so that when the form is opened again, last width property is there. I have used save command on form unload...

Dear All, I want to create a manual scrollbar (Microsoft Forms 2.0 ScrollBar ActiveX Control) linked with a subreport. Anyone knows how to do this task?

Hi, Can anyone help please. I have a main form with a subreport. Mainform width is 22"(Maximum) Subreport Wdth is also 22" (Maximum) When i run the mainform, the subreport shows correctly but the vertical scrollbar is at most right side of main form so i have to scroll main form horizontally...