Search results

I'm using MS Access 2010. I'd like to add a simple pie chart to the footer on one of my reports. The pie chart would be based on a temporary table having only one record containing six fields. Those six fields (currency values) correspond to the pie wedges I want to chart--when summed they...

I've run a networked Access97 app for years with no problems. But it has slowed down dramatically after a recent migration from Novell NetWare version 5.0 to Windows Server 2003 with Active Directory Services. I'd appreciate any suggestions for speeding it up (without having to move to a...

Depending on the number of detail records, my report's footer winds up all by itself on the report's last page. That's aesthetically nasty, especially if the footer contains totals. What's the best way to handle this problem? Regards, Blake

I have a text box in which I'd like to display the total of the numbers appearing in the second column of a list box located on the same form as the text box. I've tried a variety of things in the text box's ControlSource, such as: =Sum([Me].[ListBillingsByTimekeeper].[Column](1)) but I keep...

I've got a tabbed form with several pages. Each page has a TextBox control that I'd like to receive the focus when the user clicks that page's tab. Each page has an associated Click event, but putting Me!MyControl.SetFocus in that event doesn't work (unless I click the page body, not just the...

I have a situation in which I want my application to click the left mouse button, once. The purpose is to clear the black highlighting in a control which has the focus, due to a FindRecord action. I'm aware of the SendKeys action, which lets one send various keycode combinations, and I'm aware...

I can't find this in the Help dialogs, but some simple experiments suggest that the maximum number of records I can display in a combo box is 65536 (i.e. 2^^16). It happens that my table has many more records than that. Is there a way to extend the number of records displayed in a combo box...

Is it possible to dynamically change a form's subform content? I'd like my main form to have an option group which lets the user choose one of several lookup options, each option corresponding to a different subform having data entry fields in which the user enters various lookup parameters...