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 strongm 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. JoeHank

    Using Setfoucs method is cancelling BeforeUpdate event

    Hi, I'm trying to capture the Old Value and Current Values of all the controls on a form in the form's BeforeUpdate event. I created a function that iterates thru the controls on the form and returns the values I need, the problem is that I need the text <a...
  2. JoeHank

    Help with sorting records on a continuous form.

    Hello mstrmage1768, Thanks for the good advice.
  3. JoeHank

    Help with sorting records on a continuous form.

    Hello, I'm using a continuous form who's RecordSource is a table that contains several foreign keys. Is it possible to sort the records on the form by fields in the foreign keys table. Thanks for taking the time to read this request.
  4. JoeHank

    Query ?

    Tanks Trendsetter, for responding so quickly, I was able to resolve my problem using the rowsource property of the list box in as query criteria box using the expression builder. it looks something like this: [Forms]![formName]![ListBoxName].Rowsource And then on my form I have a cmd button...
  5. JoeHank

    Query ?

    Hello, can anyone help me with a problem I'm having with a query. What I want to do is to use the ItemData property to of a list box as the criteria for a record to be selected in a query. Thanks for taking time to read, any help is appreciated very much.
  6. JoeHank

    How can I add records to a table from the values in a list box

    I'm currently trying to add record(s) to a table from the values in a list box. For example, let's say that I have a list box with the following values: &quot;Susan&quot;, &quot;Jim&quot; , &quot;Frank&quot; and wish to add them to my Customers Table in the field [First_Name]. Thanks for...
  7. JoeHank

    Converting Access 97 to a mde file.

    I would like to know if after you convert Access 97 to an mde file does it become a truly stand alone database, capable of be run and accessed by a user who doesn't have Access 97 or any other version on their machine.

Part and Inventory Search

Back
Top