Search results

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.

Good Job Bob...thanks very much!!!

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...

Thanks for the tip...the additional space was a cut and paste problem... However, I did find the problem...there was confusion between the tabcontrol named FORMATIONS and the subform in the tabcontrol called SUBFORMATIONS... the subform did not have focus even though the primary key field in...

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...

I have had some success up to now, though limited, with the following. I have trouble going to the new record on the form. I will open a new thread to explain it. ******* Sub DrawOnSubForm_Click Initialize Get name for drawing off of main form Search the name string field in all records of...

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...

I finally found one simple solution which was to perform the WHERE criteria on the form control rather than on the table itself.....solution looks as follows... SELECT tblGames.TEAM1 FROM tblGames WHERE (((tblGames.GameID)=[Forms]![FormPlay_Input][GameID])) UNION SELECT tblGames.TEAM2 FROM...

Thanks UncleGizmo... I now understand why you made the recommendation...indeed it makes sense Considering the bigger picture, I think the overall structure is indeed most logical...the problem with the lookup list of one single field would not warrant changing the entire structure The...

Thanks UncleGizmo for the quick reply ... I reviewed the thread you suggested and I understand that I should consider changing the structure of tblGames. I assume this is based on the fact that it is not good practice to have a table such as CUSTOMERID...ORDER1...ORDER2...ORDER3..ORDER4.. as...

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...

problem solved

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...