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!

  • Congratulations bkrike 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: DonBerry
  • Content: Threads
  • Order by date
  1. DonBerry

    Hi, I'm new to javascript and I

    Hi, I'm new to javascript and I am having trouble with a function to set the value of a text type input in a form. The problem I'm having is the name of the text input is in a variable and I don't know how to use that variable correctly in the access sting ie document.myform.mytext(this is...
  2. DonBerry

    Query problem / challenge

    I want to do a query on linked tables in a one to many relationship. I want to return items from the one side that match two or more items on the many side in an "And" form of the "Where" clause, i.e. each item returned must contain all the criteria in the many table. I...
  3. DonBerry

    How to find newly entered record after form requery?

    In an application I have a form that must be requeryed after a new record is added to update info on the form. My question is how can I get back to the last entered record and make it current? Its position in the recordset may change from the last record after the requery due to the sort.
  4. DonBerry

    #name error on common functions in access 2000

    I have a database I designed on one machine and when I copy it and try to use it on another machine I get errors on common functions that work fine on my machine. I read in the FAQs about a similar problem in access 97 but when I try the suggested cure of opening a form in design view on the...
  5. DonBerry

    Report not sorted

    I'm using Access 2000. I have a query that is the data source for a report that is sorted but when I preview the report, it is not sorted as defined in the query. Any ideas why this happens? Thanks, Don
  6. DonBerry

    HTML Docs from report

    I have a rather large multipage report. I would like to output each individual page of the report to a seperate HTML Doc. Can this be done using VBA? Thanks Don
  7. DonBerry

    Access 2000 db.OpenRecordset Problem

    I am experimenting with the reocrd set concept in VBA and have been trying to run the following code: Private Sub Command0_Click() Dim db As Database Dim rs As Recordset Dim intCount As Integer Set db = CurrentDb() Set rs = db.OpenRecordset("tblInvoices")...

Part and Inventory Search

Back
Top