Search results

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

Nokia 3650 I have a Nokia 3650. It does everything I need on the road - built in camera, video with sound (which I've used to document a car accident), To-Do list, calendar, etc. With Bluetooth and Infrared, I can sink it pretty easily with both Mac and PC address books and calendar programs...

I don't know, but I wouldn't think so. Wouldn't all the calculating - i.e. counting and sums - be done on the Access/client side? I have an ODBC record set from which I'm drawing, and my Access query is using the Sum(((IIf[]="",1,0))) fields, and then the form is summing those. It's the...

Unfortunately I can't post a sample DB - the backend is using a mix of local tables, linked Access tables, ODBC SQL tables and ODBC Oracle tables. It would take more time than I'm willing to commit to make local Access-version copies of all the tables and upload it. I'm going to just have to...

No, I have all the controls named correctly. What happens is, if I put 11 or more =Sum([count field from query]) text box controls in the form footer, they ALL turn into #Error. It doesn't matter which ones I keep or delete, if I put more than 11, they all choke. So, back to my original...

bump bumpy bump bump