Search results for query: *

My report has a text Box which has a Control source based on a series of IIf Statements as follows: = IIf ([type]="chambre" and [position]=1,"chambre", IIf ([type]="chambre" and [position]=2,"vulture ", IIf ([type]="mersey" and [position]=1,"mersey", IIf ([type]="tyne" and...

The following query selects teams that are competing as Honours Only (HO) and not Honours Only (NH). I have created individual queries, both of which work, but when I combine them in a Union Query, I receive a dialog box with the following statement: "The ORDER BY expression ([TotalFibua]+...

I have a command button which prints a series of reports to CutePDF. This work fine but each time a pdf file is created, a box appears asking me where I want to save it. Is there a way of adding a line to my code which does this automatically? The code I have looks like this: Private Sub...

I have a report which is 3 pages long. My printer properties do not offer me the option of printing in reverse order so I was wondering if it is possible to reverse the print order (i.e. Page 3, then page 2 and finally page 1) by adding some coding to the report. Any help would be much...

The report which utilises the code below is based on a query which returns up to four records, the top two teams competing for Honours Only (HO) and the top two who are not HO. If there is only one team competing as HO, the query will return only three records and if there are no teams...

I have a report which lists winners of a competition (txtUnit) in the order of their scores (position), with Position 4 being the highest score and Position 1 the lowest. A label (lblPlacing) shows either "Winner" or "Second Place" depending on the position. The problem is compounded by the...

In a particular shooting competition teams shoot for prizes (NH) or as “Honours Only” (HO). In my published prize list, I need to show the winners and second place, for the award of trophies, but also the HO teams if they either win the competition of come second. An example of the final...

The following code selects the top 2 from a query: SELECT TOP 2 QryFibuaTeam_Crosstab.TxtUnit, QryFibuaTeam_Crosstab.Honours_Only, QryFibuaTeam_Crosstab.Total, ([8]+[9]+[10]+[11]) AS Practice1, ([12]+[13]+[14]+[15]) AS Practice2, QryFibuaTeam_Crosstab.[8], QryFibuaTeam_Crosstab.[12]...

The following crosstab query lists a set of results based on a total score: TRANSFORM Sum(QryFibuaComb_Team.Score) AS SumOfScore SELECT QryFibuaTeam.TxtUnit, QryFibuaTeam.TotalFibua AS Total, QryFibuaTeam.Honours_Only, TblBisleyYear.BisleyYear FROM (TblBisleyYear INNER JOIN QryFibuaTeam ON...

I have a form with a Sub Form (SubFrmScores1) which is linked to the form using the field [LngCompetitorNo] in both Child and Master links. I also have a combo box which is used to select a record in the Master form, using the following code: Private Sub Combo36_AfterUpdate() ' Find the...

I have a table with three fields - CompetitorNumber, EventRef and Score. For each competitor there are a number of event references, against which a score is added from a form. There are currently 200 competitors and I need to add five extra events. To do this long hand means making 1000 key...

I have a form which displays information for personnel based on whether a field ([position]) contains the word "Argosy". I would like users to be able to stop personnel details from being displayed by setting the [position] field to null (i.e. removing "Argosy"). I have tried using a check box...

When I created my first database I was woefully ignorant of the Access naming conventions. Hence I now have tables such a "Master Address List" which have spaces between the words. As I have learned more and developed the database, the names of the objects have been entered correctly. I would...

I am running Microsoft Office 2003 with SP3 on a Windows XP PC. My Access database opens with a Menu Form on which there a number of command buttons. All of them work fine except for one which has an intermittent problem. When I click on it, the programme thinks for a few seconds and then up...

I have three tables - Master Address List, Surveyor Details and TblPassportDetails (Names were created before I learned more about databases). Each of these contains different pieces of information about a particular person, with the Master Address List containing details of all the company's...

I am trying to improve my knowledge of Visual Basic, using various programming guides, all of which refer to "starting visual basic" and selecting "Standard.EXE". My computer is running Windows XP and Office 2003, and I can only seem to open VB from within an application such as Access or Excel...

I am running Office XP on an old laptop which is running on Windows 98. An Access Database opens at start-up and I would like either that application or Win98 to pop-up a reminder message every Friday, reminding the user to run the Back-Up. The message needs to remain alive until specifically...

I have a form which displays four records. Each record has two fields, the practice number of the competiton and the number of hits on a target or, in some cases, the score. For each practice there is a maximum number of hits or a maximum score. In use, it has been found that the person...

I have a small number of .jpg images (total about 1.2mb) that I would like to import into a table for use with a form which displays the appropriate photo for each record. The reason for storing them in a table and not creating a link to another folder is that the database has to be a portable...

I am trying to run the following code to select a photo to display in a form. The code is called by a command button on the form. Sub getFileName() ' Displays the Office File Open dialog to choose a file name ' for the current trophy record. If the user selects a file ' display...