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 Rhinorhino 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: *

  • Users: Chad1984
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Chad1984

    Using a multiple-selection list box in a query

    I have a form that allows the user to select options for a report. One multiple-selection list box allows the user to select counties- any combination of counties- before clicking up the report that will only include data for those counties. I had hoped that I could just refer to the field on...
  7. Chad1984

    Setting MSCAL.Calendar.7 date value

    I'm using an MSCAL.Calendar.7 class object on a form that allows the user to select a report name, options, and the start and ending dates the period should cover. The user then clicks a button and the proper report fills out. The problem I'm having is that I can have the objects pop up with a...
  8. Chad1984

    Creating/removing grouping levels in VBA

    Okay. I'll admit that I feel a little stupid after reading the help on CreateGroupLevel, GroupOn, etc, playing around with it, and I'm still not able to get it to work. Basically, what I want to do is have a form that allows the user the option of picking which counties to include the report...
  9. Chad1984

    Type-ahead search in large database

    I'm currently using a number of comboboxes (AutoExpand = True) as search fields for my database- the user can scroll through the list, or type out the name and it will pull it up. But I wonder; what will happen when there are hundreds of records in each combobox? What if it gets as large...
  10. Chad1984

    Importing data from multiple tables

    What's the best way to import data from 3-12 tables into a database? I read the help on the import command and the transferdatabase macro action. One problem I have is that I don't just want to import one table, but many. The other problem is that the tables already exist. I can erase all...
  11. Chad1984

    Datasheet combo box with one binding, different rowsets

    Due to some quirky business rules, I need a combobox on a form to use different rowsets for different records. In my specific example, one record in a household has a relationship of "self." Any other record will have the choice of any possible relationship except "self." So I have code that...
  12. Chad1984

    Error source

    I've read a little bit about error trapping/handling in Microsoft Access, but it's still confusing to me. According to the client's business rules, the user must be prevented from accessing the various subforms until all required fields are filled in on the main form. I would like a specific...
  13. Chad1984

    Automatically numbering a record (not autonumber)

    In my database, the form needs to assign a case number to new records; currently I'm using a dmax and adding 1 to come up with the new value. This is working fine (although I'm open to suggestions on how to do that differently), but here's the real issue: getting it to display the value...
  14. Chad1984

    Disable subforms until record is entered

    Hi all. I'm making a database for a client who wants the subforms to be disabled until the main form has a complete record entered. Of course, the database relationships will ensure that no record could be entered in a subform until a record is entered on the "one" side of the relationship, but...

Part and Inventory Search

Back
Top