Search results

  1. B

    Looking for nicer report templates

    Just wondering if one new of somewhere where nice looking report templates would be available. The ones available within access are not that great. I searched Microsoft Office Templates sites with no luck.
  2. B

    Adding blank space to lookup list

    I have a lookup list which yields something like this **** City1 City2 City3 **** I want it to add a blank space to it, to look like this **** City1 City2 City3 **** I tried add a union query to SQL statement generated by access like this.. SELECT "" UNION SELECT **THE STATEMENT GENERATED...
  3. B

    Subform within tabcontrol...goto new record

    I have a form with a tab control. In the tab control, I have inserted a subform. I have a command button in the subform to add a new record. I can't seem to make it work. For debugging purposes, I have replicated these conditions in a simple database and the command button works. This is...
  4. B

    Adding clarifying data on sub-form

    I have a form with some data associated to TableData. The form contains one field with a Name string. I want to associate a drawing to each name string to make things more clear for the user. The drawing is done on a sub-form by inputting letters in the many textboxes on the subform. All these...
  5. B

    Lookup list

    I have field BALL in tblPLAY for which I want to input data based on a lookup list. The structure of tblPLAY looks like this PLAYID...GAMEID...BALL... The field GAMEID is the primary key in a second table called tblGAMES which looks like this GAMEID...TEAM1...TEAM2 For each record, I...
  6. B

    DLookup function in report (using grouping)

    problem solved
  7. B

    Crosstab query graph in report

    Say I have the following table Employee ID....Name....Gender...City I want to know how many males work in each city and put it in a column chart. So I create crosstab query as follows... Row Heading = Gender - Where males only Column Heading = City Value = Count of EmployeeID Row Heading...
Back
Top Bottom