Search results

  1. Z

    Query - Date criteria problem

    Hey guys, I really need some help on this problem. I have a database for a tutorial center, and we have invoices recording the dates of the lessons that students pay for in this month. We have a reminder form that display query results when today is the last lesson for the student so we can...
  2. Z

    Concatenate results from text field in continuous form.

    I would like some help on this one: I have a continuous form based on a query. It only has a single text field txtStudentName. What I want to do is combine all those names into a single text field separated by a comma. Any help would be appreciated!:D
  3. Z

    Update date text field from several combo boxes

    I've searched for this everywhere but I haven't yet found a solution, even though I'm sure it should be pretty simple. I have 2 combo boxes: cboMonth, cboDay and a text field: txtYear cboMonth has values: Jan-Dec cboDay has values: 1-31 After selecting the combo boxes and entering the year, I...
  4. Z

    Message box show only first time

    Hi guys. I have a few problems with my message box. 1. How do I enable a message to pop up only the first time I click a save button on a new record in a form? 2. How do I run the following ONLY AFTER you click Yes on the message box? After you click yes, it can be locked forever...
  5. Z

    Combo box fill in text box..BUT!

    I know how to base the combo box on a query, and in the after update enter Me.[txtboxName]= Me.[cboName].Column(1) BUT... I want to bound the combo box to a control source. How can I achieve that? Thanks~
  6. Z

    Value in Text box as criteria for query which populates combo box

    Combo box from text box value Simple question but I've been stuck for a looong time. So what I want to do: 1. enter a value into a text box (Home_Tel) in a form (frmStudentClass) 2. which runs a query (qryNameTel) 3. and return the results to a combo box (Student_Name) on the same form. The...
Back
Top Bottom