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: *

  • Users: cwadams
  • Content: Threads
  • Order by date
  1. cwadams

    ASP + Recordsets + SQL

    I am a newbie to ASP and am trying to learn. In my ASP page I have 2 SQL Select Statements. I am passing a value (4+)that is stored in my (SubRs "Class")recordset to the 2nd SQL statement, but I want to extract only the first character and then add a wildcard. So that I can extract all...
  2. cwadams

    Nested IIF's with conditional statement in Query

    I want to compare two values. The value that is on my form and the value(s) that are in the query. Ex: "If Value on form for [Cond] is "A" and true; & value for that field in the query is: E, G, A, F, or P. I want to calculate a value. There are 5 different values that can be on Form. E,G,A,F,P...
  3. cwadams

    Passing a Wildcard

    I am using Access2003 and in VBA I have a NBHD of RJA. In the condition of my query,I want to query from the table all NBH that are like the first character that matches frmMyForm.NBH So I want to see all NBH that start with the letter R, regardless of length. Suggestions for the syntax...
  4. cwadams

    Grab first 3 records

    I have a tblTemp with 2 fields PropID, and RecordID I can have many records but I want to always grab the first 3 records and pass to a report. Any suggestions on the syntax for this VBA code? I know that SQL uses TOP (3) but I cannot find a reference to this using Access.mdb and VBA.
  5. cwadams

    Creating a Make-Table Query in VBA

    In Access, Using VBA Only, I am trying to write A Make-Table Query from a table named CompSales INTO a table named Temp using conditions from a form, and then get a count of records. If I write the query in design view it works, but coding in VBA it does not return a record count or update my...
  6. cwadams

    Creating a Make-Table Query in VBA

    In Access, Using VBA Only, I am trying to write A Make-Table Query from a table named CompSales INTO a table named Temp using conditions from a form, and then get a count of records. If I write the query in design view it works, but coding in VBA it does not return a record count or update my...
  7. cwadams

    Creating a Make-Table Query in VBA

    In Access, Using VBA Only, I am trying to write A Make-Table Query from a table named CompSales INTO a table named Temp using conditions from a form, and then get a count of records. If I write the query in design view it works, but coding in VBA it does not return a record count or update my...

Part and Inventory Search

Back
Top