Recent content by bijuvijayaraj

  1. B

    Use randomly selected table entry & no repeat

    To achive this create expressions bound to the text boxes such as: ="Hello my name is "& [your table]![field containing name] & " I am" & [your table]![field containing age] & " years old and live in"& [your table]![field containing country] Try this for all sentences.
  2. B

    horizontal line at bottom of the detail

    hai one small suggestion. Is it mandatory to use vertical and horizontal lines in the detail section ? Why not you make the borders of the text boxes visible and make them as the required lines. Give it a try you can create great looking reports. Try this in the header section also. Tip...
  3. B

    appending data to an existing table: renumber key

    here is the tip to create an update query. You seems to be familiar with delete and append queries. To create an update query, create a new query, select the query type as update from the menu, include the table to be updated to the grid and drag and drop the autonumber field to the first...
  4. B

    appending data to an existing table: renumber key

    you can remove the auto number field if it is of no use, but for the sake of a solution to this issue I suggest you to create an update query to reset the autonumber field. You can set the field value to the number you wish to start with. Make sure that you have deleted all records from the...
  5. B

    Validating a field to match a corresponding field in another table

    hai, try this if it can help you. Create a look up (combo box) for the identical field of second table (u can find it in the properties of the field in table design view) by using the first tables identical field as input. Set the limit to list property to yes to validate data entry.
  6. B

    calculated field to display numeric data from combo box as text

    alternately you can use choose function from the expression builder.
Back
Top Bottom