Search results

  1. D

    Creating new values in a table based on existing values

    I've got a table tblTopValues containing two fields, a unique ID number and a value. I want to be able to create a new table (or put values into an empty one), with the second field sequentially numbered from 1 to the value already held e.g. ID Number 3 5 2 2 4 3 ID Number 3 1 3 2 3 3 3 4 3 5...
  2. D

    Changing value of ForceNewPage

    I have a report that splits the output over several pages using the ForceNewPage property (After). I want to give the user a choice as to whether they wish the report to print on one page. Is is possible to alter this property depending on the value of a check box on a form ie IF Value = True...
  3. D

    AfterUpdate

    Hi I'm having a problem ensuring that the user enters valid data. On a form after the user has input their values for several fields I am using AfterUpdate to check if they have a valid input according to the rules of the program. For example if the totals of fields 1 and 2 are less than the...
  4. D

    Matching any characters in a query

    Can anyone help me please. I have been trying to create a report by using a query to include those records specified by the user. One field of a table can contain a number of letters eg ABC, ADB, CDEB, or DEA etc. I want the user to be able to enter *their* selection of letters (in any order)...
  5. D

    Machine locking up when deleting record

    Hi, very new to this board, and also to access (2 weeks). not sure if this will turn out to a table problem, but it occurs when using forms - hope you can help. I have tried to create my first app which is fairly simple It is to hold data for fishing competitions by team/player/weight etc. I...
Top Bottom