Search results

A better generic solution is provided here: https://access-programmers.co.uk/forums/showthread.php?t=290574

Arnelgp/JHB: Thank you BOTH, very much. I'm intrigued to see two quite different approaches which both give the desired result. I'm working well beyond the limit of my ability here, but I'm trying to understand. JHB's approach seems to bring the Microsoft Excel graphing capability into...

JHB: Yes, that's exactly what I'm looking for. Arnelgp: Thanks for your sample database. Looking at your Report_Open code, I'm guessing that the idea is to do some preparatory charting work in Excel, then import the result into Access and adapt from there. Is that the general idea? I've done...

Yes; here's an example: Available Funds $24,959.94 Fee #1 -$ 3,683.36 Fee #2 -$ 2,341.18 Fee #3 -$ 146.25 Fee #4 -$ 1,878.91 Net Remaining $16,910.24 My original post mis-described the data. The "Available Funds" constitute 100% of the pie; the other five fields are the...

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

Wow--I'd forgotten all about my posting from 2002. But in the interim I've learned (via other contributors to this site) that it can take ages for DSUM to calculate the sum of a list box column. In some cases it took so long that I included an hourglass type symbol to warn the user. It's...

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

I finally get it. When combined with the page footer totalling technique explained in Q132017 I get what I want. But, it comes at a price. If there aren't many detail records, I wind up with a lot of white space between the last detail record and the totals in the page footer. A report...

I really appreciate the feedback. I've looked at the suggested code, but I don't see how it solves the problem. The failing is probably all mine: inadequate explanation of problem &/or inadequate understanding of the code. The suggested code will apparently enable me to tell if I'm on the...

I gather you're referring to an item in the Microsoft Knowledge Base? I can't find an article with that number.

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

Thanks very much Pat. For anyone interested, it may help to know that the solution wound up looking at lot different than what I'd been flailing around with (see my initial post). Pat's guidance put me onto this: =Format(DSum("[myField]","myQuery"),"Currency") which works, when plunked into...

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

Thanks! It worked! Regards, Blake

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

Thanks hugely Drevlin. That did the trick nicely. Regards, Blake

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

Thank you both for your helpful suggestions. After doing some experimentation, I've settled on Pat's tabbed form suggestion as simplest. Indeed, despite having tabbed forms staring me in the face via several applications developed by others, I've never had time to try them. They do appear to...

Thanks. I've pondered the problem and decided that you're right. My initial reason for wanting the combo box was that the recordset (invoice numbers) is fragmented. By using a combo box, I could have forced the user to pick a valid number from a list. But, I can validate a number entered via...

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