Search results

  1. A

    Hyperlinks showing full network path rather document name

    Use Str() function to separate doc name and show only that in form
  2. A

    Assign value to set of values

    CalValue : Int([Value]/18 ) +1 value CalValue <18 1 <36 2 Etc.
  3. A

    OpenForm (filter name)

    Use the following as filter in condition part of query =[Forms]![Form Name].[Filter Field name] This will filter query to Form Name and shown Filter Field name.
  4. A

    Calculate Opening Balance

    The table structure and your nomenclature is not clear to me. You need to put all value of your calculation fields to one query and than calculate opening balance. you can also do it via VBA.
  5. A

    Force text box requery

    You can set the [TempVars]![PopUp] as after upupdate property of pop up. Create the query filter on [TempVars]![PopUp]. That way when pop up changes [TempVars]![PopUp] changes and query data modify and hence form update.
  6. A

    Getting column totals for Crosstab

    Add the column fields in a query and show that additional field as row in Cross tab. i am using this method successfully. eg col =1 ,col 2=3 col3=5 Total:Col1+col2+col3 . show Total in cross tab as row.
  7. A

    IIF and WHERE from Tables without values

    Your query are still linked to old xls table so do not run. since you have a working db so what is missing in it. Your question is highly unclear?
  8. A

    Check box in Forms

    You need to prepare a update query where two column value are = to each other. The checkbox is updated to Yes for records where two column value are equal.
  9. A

    IIF and WHERE from Tables without values

    what exactly is your question? sorry i could not make out what you want.
Top Bottom