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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by billmsacces

  1. billmsacces

    MS-DOS handlers

    Every time I try to open my web form, I get an error that says that I've run out of MS-DOS handlers and that the page can not be loaded. What could be causing this? Thanks. B
  2. billmsacces

    Open Page for Data Entry

    I am currently working on a page that would be used to submit information to the database. This page will only be for data entry. Is their a simple code that can be used to make it go to a new record when it opens? Thanks. B
  3. billmsacces

    I need help with the order of my forms!

    I've had this problem before and I simply made a query that listed the data in ascending or descending order. I then based the form on that query. There may be a simpler way though. B.
  4. billmsacces

    Searching a database

    I would like to search records in a form (frmCitation) by name (txtName) and/or date (txtPubdate). I made a simple form (frmSearch) with input boxes and a search button (cmdSearch). I have tried using the Find method, which would simply match terms in the input boxes, but I am not familiar...
  5. billmsacces

    searching a form

    That would be great if it wasn't too much trouble. Thanks. B
  6. billmsacces

    searching a form

    I would like to have a result list if possible. Thanks. B
  7. billmsacces

    searching for a record in a form

    I am currently using the built in FIND feature in Access to find records in my database. The FIND feature works but it is clunky. Is there a code that would search specific fields in the database. I’m thinking of something like Query By Form, but instead of displaying the info in a datasheet...
  8. billmsacces

    searching a form

    The Form I'm using is based on a query called qryCite. (The query is based on tblName and tblPub). The form contains several fields, but the ones I'm interested in searching are txtPubDate, which is the publication date, and txtSurname, which is the last name of the individual. There is also...
  9. billmsacces

    searching a form

    That sounds about right. How simple is it?
  10. billmsacces

    searching a form

    I am currently using the built in FIND feature in Access to find records in my database. The FIND feature works but it is clunky. Is there a code that would search specific fields in the database. I’m thinking of something like Query By Form, but instead of displaying the info in a datasheet...
  11. billmsacces

    Sorting Records in a Form

    I am currently working on a database that has a name field and date field. It is currently based on a query that sorts the records by name. But sometimes I would like to view the records by date. Is it possible to write a code that would resort the records by date? It was suggested tome to...
  12. billmsacces

    Choosing a sort method?

    I am currently working on a database that has a name field and date field. Is it possible to write a code that would sort the records by date or by name, depending on what was needed at the time? Thanks. Bill
  13. billmsacces

    Clearing Continuous Forms

    Both methods worked. Thanks!
  14. billmsacces

    Clearing Continuous Forms

    I am trying to clear a continuous form using the following code. Private Sub ClearForm_Click() Do While Me.NewRecord = False field1 = 0 field2 = 0 field3 = 0 DoCmd.GoToRecord acDataForm, "form1", acNext Loop End Sub It works fine until it...
  15. billmsacces

    Clear Continuous Forms

    Okay... Everything works, except docmd.gotorec.acnewrec I keep getting an error that says "The object '0' isn't open." Any ideas? Thanks.
See more

Part and Inventory Search

Back
Top