Recent content by monkeytunes

Just giving it a bump in case anybody has some ideas...? Thanks!

Hey buddays, So, I've got this report, and I'm pulling the top 10 costs of orders in the source query using the TopValues property. (10 records. Easy.) But the execs want to compare across years. So... What if I want the report to show the top 10 orders for two years? In other words, group...

Waited awhile, thought I'd give it a bump. Help?

Hey buddays, I'm not sure what the definition of this type of concatenation is, so I'm having trouble searching for it. I have three tables - one is tblNames (with ID, first_name, last_name) with 25 records, and tblStates (with StateID, state_name, state_abbrev) with 50 records, and the...

You can use the Toolbox to place a "Command Button" on your form, and if you have Wizards enabled, Access will walk you through the various pre-set functions for a command button, one of which is "Open Form". As you get better with Access, you'll be able to change the events that command buttons...

If you go to "Tools" and choose "Startup", you can designate a form (either a custom form you design or one of Access' Switchboards) to open whenever you kick open the database.

Hey Godofhell, that's a neat trick. I never thought to have a choice of subforms loading in an unbound subform. *dawn breaks over Marblehead* (Massachusetts joke) Let me ask you a performance question - would this method be faster than having tabbed subforms? I find that my forms with, say, 5...

In the Modules section is the Audit_Trail code that is being called by the forms. When you open just the form by itself, all the code points to the right path, i.e. "MyForm". When you have your input form in the tab as a subform, the path is now one level deeper - "MyForm" refers to the form...

I haven't tested it to try it out, but I'm pretty sure that by making your "Update A" form a subform in "Update B" means you'll have to update all the "MyForm!tbAuditTrail" references to account for the fact that "tbAuditTrail" is now in a subform. Access is looking for "tbAuditTrail" on...

Did you mean to type "tblAuditTrail" instead of "tbAuditTrail"? If it's wrong in your link/expressions, Access can't find something if it's misnamed/misspelled.

boblarson, I'm not terribly adept at coding. I can walk-through others' examples and modify it for my needs, but I'm usually unable to do complex operations without an example to work from. Sounds like a good idea, but I'm curious as to what "dynamically change your range" means - we're...

Hey buddays, We recently sent out a questionnaire/suggestion list to a bunch of employees (several hundred) and are expecting responses soon. The questionnaire is in Excel format with two worksheets. The first sheet is locked/protected and only contains instructions for users. The second sheet...

It's been about a day, and I'm still stumped on implementing the "Components" idea into the Applications and Contracts that I outlined above. So, just a lil' bump in case someone can help.

Thanks for the reply, Pat. Your normalization insight is always appreciated! Let me ask you this - what if there are particulars in the applications that are being tracked? For instance, our contractors send us photos - those photos always come in as part of the last application, regardless of...

Hey buddays, I have a contract-tracking database that has been in use for about a year. It used to be that every contract had the same number of periodical "applications" with it - the companies we worked with would send in 4 applications over time. So, I had this set up: tblCompanies (the...