Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Chad1984

    Excel PivotTables: finding origin of grouped field

    The code works great for the months field... the years field displays some odd behavior, but ah well--I'll just assume that they are based on the same database field. Thanks again, Skip, you're a lifesaver!
  2. Chad1984

    Excel PivotTables: finding origin of grouped field

    Wow, Skip, thanks for taking the time to write that super-fancy code! That seems to almost do the trick! I say "almost" because, oddly enough, it worked for one field and not the other. I have two fields, "Months" and "Years," which may or may not be based on the same data field. The macro...
  3. Chad1984

    Excel PivotTables: finding origin of grouped field

    I'm having trouble analyzing and replatforming some reports that are delivered in Excel, the data of which comes from a string of Access databases (oh, the horror!). This specific snag is about grouped fields in PivotTables. I've discovered the VBA code to find the connection string to a...
  4. Chad1984

    Viewing recent changes to data

    How can I bring up a list of changes to a database? The database will be used across three computers and the client would like to quickly review it each day to catch any obvious errors made by her volunteer staff. This seems like a common need- is there such a feature in Access, and I just...
  5. Chad1984

    Access - Multi level search query

    Okay, I'm pretty confused here... it looks like you're saying you have three tables. I'll give an extremely oversimplified version of the definitions. Table App ---------- App_ID App_Name Table Server ------------ Server_ID Server_Name Table App_Server ---------------- App_Server_ID App_ID...
  6. Chad1984

    Search Key Error

    Hi! That's an interesting question you have there- I was totally clueless until I did some Googling! A couple of thoughts for you: it's helpful if you post the EXACT error code and error message. :) Also, this "Import Specification" thingy looks like it's an Access 2007 feature only? That could...
  7. Chad1984

    Calculating an Average Time

    It's hard to say- it would be helpful if you could post the VBA code in the "ElapsedTimeString" module. I have a few thoughts/questions for you: Your function is named elapsedtimeSTRING. Does it return a string value or a number? If the former, can strings be averaged? If that doesn't work, do...
  8. Chad1984

    Multi-level GROUP BY clause is not allowed in a subquery (report only)

    For future reference, I did find the answer. Or "a" answer, although it doesn't seem to work very well. When in doubt, write more queries. One query? Two? Three? That would have been simple enough, and worked for the other queries. I'd be embarrassed to say how many I actually ended up...
  9. Chad1984

    Multi-level GROUP BY clause is not allowed in a subquery (report only)

    Uh, thanks... but I kind of want that grouping. The report works find if I use something like: County Ethnicity Percentage ------ --------- ---------- Otsego Caucasian 88% Otsego African American 10% Otsego Hispanic 2% Osceola Caucasian...
  10. Chad1984

    Multi-level GROUP BY clause is not allowed in a subquery (report only)

    I'm not certain of whether I should post in here or in the queries forum. I decided to post here because this error ONLY appears when I try to view the report; the underlying queries work just fine. The report is meant to show the proportions of ethnicities for each county. I have a base...
  11. Chad1984

    Error 3086

    My mistake; I listed the correct error in the subject (3086, "Cannot delete from specified table,") but mistyped the error code in the post and neglected to provide the message as well. Hope that's more helpful!
  12. Chad1984

    Append Reverse Cross Reference?

    Hmm. I'm not expert, so I'm not going to pretend I have the holy grail in hand here- just some ideas from someone else that's learning. I don't really know how you intend to use this data- you can't just say something like SELECT rcustomer_id FROM customer WHERE customer_id = (SELECT...
  13. Chad1984

    Error 3086

    I have a bit of an odd situation here. The short short version: the database works fine for me after I added new features, but the client says reports are popping up with error 3089. Since I cannot duplicate this error or visit the site to see their computers, this will be tricky. I do believe...
  14. Chad1984

    Annual Testing Date Problems

    I think you might find the following page helpful: http://office.microsoft.com/en-us/access/HA010546621033.aspx?pid=CL100570041033 Look at the "dateadd" function specifically. If I understand what you want correctly (and I may be confused) you want to view all people whose training dates are...
  15. Chad1984

    Filter both report and subreport

    Okay, I figured it out, finally (yay!) after guessing and researching many many different wrong ways to do it. I'll post the answer here as a reference (because many answers I find are from Googling forums like this one) The simple answer to filtering a report and its subreport is: you don't...
  16. Chad1984

    Filter both report and subreport

    Wow, I must be more tired than I thought. Obviously I wasn't paying attention when I tested it- that did NOT fix the issue! So! Any thoughts on filtering both a report and subreport?
  17. Chad1984

    Filter both report and subreport

    Never mind- I figured it out. I realized that it is possible after all to have the "totals" query run off the regular report query, simply grouping and summing it, minus the "county" field that groups it into sections in the main report. Then when the main report is filtered, the subreport is...
  18. Chad1984

    Filter both report and subreport

    (This is a continuation of the thread at http://www.tek-tips.com/viewthread.cfm?qid=1398184&page=1) Okay. I'm using VBA code to add filter critera in the DoCmd.OpenReport statement. I have a report based on one query with a subreport based on another query- both queries are based on the same...
  19. Chad1984

    Using a multiple-selection list box in a query

    Thanks! That was very helpful, the code worked like a charm with very little change. However, now I'm complicating things further! In order to have totals of the data (i.e. all the same data without the county or being grouped by county), I created a separate query that takes all the data from...
  20. Chad1984

    Using a multiple-selection list box in a query

    Thanks... so I take it your answer is that, of the various options I listed for using a multiple-selection list box as the base for a report... the best way is to use VBA and assemble recordsource string using the listbox values and the values from every other control on the form, then use the...

Part and Inventory Search

Back
Top