Search results

  1. C

    recordsets collection doesn´t work

    Is the table a linked one. If so you need : set rec = dbs.openrecordset("tablename",DB_OPEN_DYNASET)
  2. C

    Dynamic RecordSources

    I use the OnOpen event to bind a report to dynamic SQL strings if that is what you want - I guess this works to change query/table also.
  3. C

    changing report set-up

    Yes - it's easy. Just create your query, and then bind the report to that instead (RecordSource property). As long as the fields have the same name - no problem.
  4. C

    Viewing specific data when opening a form

    Is the form bound? Are you closing it to go back? If so then you could force a save in the form OnClose event - use the button wizard to generate the save code.
  5. C

    Calculating total

    I'd do it on the subform. Use "=sum([FieldName])" as the control source. Otherwise use a DSum if you want it on the main form.
  6. C

    View/Edit Record Based upon Combo Box

    If the combo box contains the key field, then it is easy. In the AfterUpdate event of the combo, build a SQL string e.g. strSQL = "SELECT * FROM TABLE WHERE KEYFIELD = " & Combo.Column(0) Then change the recordsource of the form to be the SQL string (Me.Recordsource = strSQL). You can do this...
Back
Top Bottom