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

    Win98 SE network issues

    When my win98 SE machine boots up, an error alert box pops up saying that "an error occurred while loading protocol 0. Error 59 occurred." Also, the hourglass cursor appears quite frequently. I have not added/removed any hardware or software. All I did was shut down my machine the night...
  2. jpmillr1

    Resetting the autonumber

    Is there a way to reset the autonumber to Zero? I have a test database that is up to 30 or 40, and I want to reset the count to Zero to roll it out. Thanks. JP
  3. jpmillr1

    Combo Box question

    I have a troubleshooting database with two data fields in question - a STATUS field that denotes an issue as either "open" or "closed." I also have a DATE CLOSED field that tells what date the issue was closed. Is there a way to force the STATUS field to...
  4. jpmillr1

    Required Data on a form

    Is there a way to require a text box to have some data entered on a form? I have set the "Required" property to YES and the "AllowZeroLength" property to NO already, but I am still able to skip those fields in the form. How can I demand that a user enter something into...
  5. jpmillr1

    Delete confirmation box

    Yep, it does ask to confirm. I just want different actions to take place when this delete prompt comes up. For example, if you click "Ok" it closes the form and goes to another. If you "Cancel" it leaves the current form open.
  6. jpmillr1

    Delete confirmation box

    I have a form with a delete record button, but I would like it to keep the form open if the delete is cancelled, or close the form and go to another if the delete is confirmed. How is this done? I am trying to figure out a macro or an SQL statement, but I am stuck. Thanks, John
  7. jpmillr1

    Limit on complex SQL statements

    Is there a limit to the complexity of SQL statements? I successfully wrote a query based on 6 combo boxes, and it worked once or twice. But then it stopped working and an error box said it was too complex. What gives? Thanks, John
  8. jpmillr1

    Complex Query Without profuse code???

    Is there a way to query a table based on up to 6 combo box-based criteria (they can be null or defined by the user) without writing tons of SQL statements? Thanks! John
  9. jpmillr1

    Complex Combo Box Query

    That explanation would have the functionality I am looking for, but with 6 combo boxes there are many permutations...so yes, I guess I am just seeking a 'shortcut' if one exists. Thanks though! John
  10. jpmillr1

    Complex Combo Box Query

    I want to do a query based on combo box values, with the functionality that when all boxes are left blank, all records will be selected (because no criteria was specified via the combo boxes). The query returns records containing data that matches the combo boxes, and if combo boxes are left...
  11. jpmillr1

    Query Design with Multiple Combo Boxes

    Hi Richard, I was just wondering how you solved this problem, because I want a query to do the same thing. I have ~7 combo boxes, and want to filter my query based on their choices (or lack thereof for any number of them). How did you do it? Thanks!
  12. jpmillr1

    How do I open a form upon opening a database?

    I want a "Main Menu" form to open (maximized) when I first start the database. How is this done? Thanks!

Part and Inventory Search

Back
Top