Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query has grown too complicated (Access 2000)

    I have created a Query that has grown way too complicated. I have alot of data in many different tables. This data is full of Null values. I have created a form that allows the user to search any field in all the tables through many combinations. I will attach the form. At this stage the form is incomplete. The search options at the bottom of the form only allow fot a single value query. I will be adding the ability to enter a range of values to search through. When the search button is pressed a form is opened that has its source being a query with criteria determined from the search form. I need this query to be able to search through the data, get Null values when the text box values are "[0-z]*", and search for a range where the upper and lower values of the range are found in 2 seperate text boxes. If you know of a way to do this same function without using "[0-z]*", feel free to suggest it. I appreciate any and all help anyone can provide.
    ]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query has grown too complicated (Access 2000)

    The database you attached is irrepairably damaged.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query has grown too complicated (Access 2000)

    Sorry about that. Unfortunately I am having trouble supplying you with a better version due to the Nature of the database and where I work. If you need more information to assist me than was supplied, let me know.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query has grown too complicated (Access 2000)

    I cannot open the form in the database you posted, so I can't offer any assistance. Sorry.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query has grown too complicated (Access 2000)

    Is there a way I can send you a file that is larger than 100kb? Its a zipped database 189KB.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query has grown too complicated (Access 2000)

    See <post#=401925>post 401925</post#> for instructions on how to reduce the size of a database for posting it.

  7. #7
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query has grown too complicated (Access 2000)

    Here it is. Thanks.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query has grown too complicated (Access 2000)

    In my experience, users often claim that they need to be able to do very complex searches, but 99% or more of the time, they only do simple ones. The forms and queries you have created will only become more complicated and unwieldy if you try to add more functionality. I would aim for radical simplification instead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •