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

    Datasheet Subform: trying to get combo box to populate another field

    I have a form called frmClientTracking, within this form is subform called sfrmService. The subform (datasheet view) consists of ServiceCd and ServiceNm, etc. ServiceCd is a pulldown list populated from another table via the row source control, when a certain number is selected, I want to...
  2. fazm

    Form RecordSource Question

    I have a query that is creating the record source for a form (form_load event): strSQL = SELECT a.ClientID, a.ClientFirstNm, a.ClientLastNm, b.EmployeeFirstNm,b.EmployeeLastNm, b.CaseLoadID FROM tblClient AS a, tblEmployee AS b WHERE a.CaseLoadID=b.CaseLoadID And ClientID=[Enter Social Security...
  3. fazm

    Using Query For RecordSource

    Can anyone give some insight to this: I have a query: SELECT a.ClientID, a.ClientFirstNm, a.ClientLastNm, b.EmployeeFirstNm, b.EmployeeLastNm, b.CaseLoadID FROM tblClient AS a, tblEmployee AS b WHERE a.CaseLoadID=b.CaseLoadID And ClientID=[Enter Client ID]; This is being used as the...
  4. fazm

    Put Results From Qry into MsgBox

    Platform: Access 2000 Qry: SQL query within VBA I want to write a select qry and have the results displayed in a msgbox. Is this possible? Also, can the result be used in another qry. I am gathering that I may need to do this with via recordset, but I dont know how to set that up. Any help or...
  5. fazm

    Taking ComboList Items & writing a qry to select records randomly

    Help! I am on the verg taking a sledge hammer to me PC! I have a form with a combolist on it with 3 items to choose from. Based any one of these items, I need to randomly select a match from another table and then display it either in a datasheet or msgbox. I know SQL pretty good so I was...

Part and Inventory Search

Back
Top