Search results

  1. GrahamUK33

    Adding a clickable link by using a Browse button

    I have added a browse button that inserts a link address to a file on our network. The only problem I have with it is that when the link is clicked on the file does not open up. When a website address is saved, it can be clicked on and the website will open up. I am wondering if there needs to...
  2. GrahamUK33

    Changing label colour on rollover

    Is it possible to change the colour of the text on a label on hoover, and then change colour back when mouse has moved away, or label has lost focus?
  3. GrahamUK33

    Select multiple checkboxes with a label

    I have a form with a number of checkboxes that can be selected independent of each other. As an additional feature, is there a simple way of adding a click event to lblTitle to select/deselect (tick/untick) all five checkboxes together? lblTitle chkCheckBox1 chkCheckBox2 chkCheckBox3...
  4. GrahamUK33

    Using =DCount to show the totals within a Report

    What I have is report that lists all the project names, below there is a total of the projects and under that is a grand total number of all the records under every project. What I am trying to achieve is having a total number of records for each project. Table tblProject – contains the...
  5. GrahamUK33

    Disable Design View from Report

    I have hidden the ribbon and database window adding the following code to the OnLoad event of a SplashScreen Access 2013 Form. DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.RunCommand acCmdWindowHide I would like to remove/disable the option to select 'Design View' (right-click menu) on a...
  6. GrahamUK33

    Count all records with the same project name

    I have a report with a record source coming from a query, within the query there is a field called ‘Project’. What I would like to do is count all records with the project called ‘Car’ and display that number in a textbox within the report. So far I have tried the following, neither of them...
  7. GrahamUK33

    Overlay text over a Hyperlink

    Can I overlay text from Field1 over a hyperlink that is in Field2 from a table/query, and then display within a text box on a report?
  8. GrahamUK33

    Form filter for a Report

    I am after some help creating a Form filter for a Report, I have Form frmReportFilter that opens rptTimmsReport in the background. On frmReportFilter is a Combo Box (cboProject) that filters the records on rptTimmsReport once a project has been selected and a Button (cmdApplyFilter) has been...
  9. GrahamUK33

    Report for multiple blank fields

    I have created a report with a query attached that basicaly shows every record in Surname order. What I would like to be able to do is only show the records where there is a blank field/fields. * Date 1, Date 2, Date 5 could be filled out while Date 3 and Date 4 blank * Date 2, Date 5 could be...
  10. GrahamUK33

    Showing a label based on date()

    MS Access 2002 (MS Office XP) I would like to make a label only visible (containing a warning) if a date (in a text box) is shown to be less than today’s date. Any ideas as to what code I will need and what event to put it on?
Top Bottom