Results 1 to 6 of 6
  1. #1
    rjurke is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    7

    Creating new database.

    Hi



    This is my first post on here as I am relatively new to ms access. I am using access 2010 for a project at work.

    Basically I need a database to record faults which are found on a production line.

    I need to be able to enter new faults to the record and the user (in read only) needs to be able to search for faults using four categories with cascade combo boxes (machine type, machine spec, fault type, symptom)

    This will be used to aid production to search for common faults and hopefully help them to identify the fault cause which they have.

    I have already created a table with my fields in where the faults will be recorded and a form which will be used to enter new faults into the database.

    What I need now is a box to search for faults with the four cascade combo boxes and a report which will be generated with the records of all the faults which are within these boundaries.

    I need to know what objects I use for this function, how I get the combo boxes to work in cascade and also how I get the report to be generated and list only the faults that the user needs to view.

    Any help is appreciated.

    Thanks

    Richard

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Can you explain what you mean when you say you need the combo boxes to 'work in cascade'?

    If you can explain what that means, getting your report to work with the 4 values from your combo boxes should not be too difficult.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    rjurke is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    7
    I have managed to get the combo boxes working correctly using the datapig tutorials but I am struggling to work out how this form then opens up a report of all the fault records based on the criteria of the combo boxes?

    Thanks
    Richard

  5. #5
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Ok. I think I understand. The link you provided explained it very well. Useful!!

    So . . .
    After you have made all your selections from your Combo Boxes, you want to open a Report using the criteria in the different Combo Boxes.
    Is that correct?

    Can you give me an example of what will be selected in your 4 combo boxes? I'll use that info to create the code that opens your report.

  6. #6
    amaconline is offline Novice
    Windows Vista Access 2000
    Join Date
    Sep 2011
    Posts
    4
    Can you share your data with us? or any example work that you have done..

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating First Database
    By marrone12 in forum Database Design
    Replies: 1
    Last Post: 09-08-2011, 05:02 PM
  2. Replies: 4
    Last Post: 01-25-2011, 11:37 AM
  3. I need help in creating a database report.
    By fastorm in forum Queries
    Replies: 1
    Last Post: 10-27-2010, 09:54 PM
  4. Help with creating a database
    By ITChevyUSSNY in forum Access
    Replies: 0
    Last Post: 07-31-2009, 05:48 AM
  5. Creating database
    By ramzyamal in forum Database Design
    Replies: 1
    Last Post: 05-07-2007, 08:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums