Search results

Using the domain aggregates was the next thing I was going to try. When I put them in, it was summing up the whole table. Manager, Category Ben, A Ben, B Ben, C Each item has both a manager & category assigned to it. Is it possible to use the domain aggregates holding to both of these? I...

I'm struggling with a non-updatable query issue. I have a table at the category level that should allow entry but it needs to pull in information from another query. In this 2nd query, its doing group by/counts/sum's from an item level table. From reading about the dynasets and trying to fix...

I guess the be a little more specific, I'm building this into a form. On the detail section, this is going into the conditional formatting in order to highlight that entire row when the first or 2nd high numbers come up. For the max number, I'm using: Expression is: [gam potential]=Max([GAM...

I'm trying to identify the 2nd highest number in a field in Access. While searching, I ran across the =large(a1:a3,2) formula, which works perfectly in Excel. I'm trying to duplicate this functionality in Access 2003, but it looks like this formula isn't in there. Any ideas on how to...

Jon this is perfect! Thanks a ton.

Hi, I'm trying to compare partial text records across two tables. The first table simply has a description, such as: DescriptionHammer Bone Saw Power Saw The second table is a list of terms and a category, such as: Term, Category Hammer, 1 Saw, 2 I'm looking to build a query will compare the...

I got this method to work pretty easily. The issue I am running into now involves the fact that our PC's run Novell - Client for Windows on top of WinXP. The scheduling works just fine as long as the computer is on and Novell hasn't locked the workstation. When this happens, Access just...

Hi, I have a rather large database with a lengthy append query that I'd like to run overnight. I've read some posts about using a form with a timer built in, its not real clear on how it works (http://www.dbforums.com/archive/index.php/t-331813.html). I've also come across some talking about...

Perfect, got it working. Thanks!

I've gotten the medianf fuction that is pasted on these boards working in the attached db example. The problem I am running into now is the medianf function (correctly) takes the median for an entire table at once. My dataset example looks like: type num t1 1 t1 2 t1 3 t1 6 t1 6 t1 100 t2 1...

Ah there it is. Should've picked up on that, guess I was working with too long to notice. Thanks for the help, really appreciate it.

Here is the sample DB. I've stripped out the majority of the info & coding in it but the basic fields I'm trying to drive the dlookup off of are in there. Once you open the DB, go to the "Select_PMgr" form. Once open, click the "New Program" button and just hit enter. Once the 2nd form comes...

Correct, all 3 are text fields. I'll upload a portion of the DB tonight/tomorrow.

After doing some more digging, I found some of the alterations I need to use based on composite keys. http://www.access-programmers.co.uk/forums/showthread.php?t=46627&highlight=Dlookup+Composite Based on that thread, I've come up with... =DLookup("[R12 Sales $]"...

Ah that'd be my misudnerstanding. From reading through that other link, I thought they were using the &'s and ""s for some custom concatinations. It seemed odd to put quotations around everything so I hadn't tried that yet. I'll give it a shot.

I had a feeling it was going to come to the DLOOKUP. I've been fighting with it a little. Based on the criteria from http://www.mvps.org/access/general/gen0018.htm, I put in... =DLookUp(qry_sales_by_family_w_analysis![R12 Sales...

Thanks Paul. I've got the enable/disable working now. Regarding the text box population, it would be feeding off of a query that pulls on the combo box selections. Using the after update event, it didn't seem to like that much. =[txt_h_sales]=qry_sales_by_family_w_analysis!SumOfSales_Dollars

Probably an easy one here...I have a series of cascading combo boxes where once the last once it chosen, I'd like some sales info to populate in a group of text boxes. What command would I use for this? Also, I have a checkbox that I'd like to use to either enable or disable a textbox as well...

Thanks! I'll give it a shot.

Not sure if this is the right forum for this. I have a switchboard that one of the buttons is tied to run a specifc report. Once the user clicks this button, is there a way to show a loading bar so they know its on the way (outside of the loading bar in the lower left). I'm looking to make it...