Search results

Hi, I have created a query to enable staff to report on monitoring reports for our grants and determine how many we have outstanding and how long organisations took to send in their monitoring etc. I need to be able to filter the query by our respective countries and also by status. However...

HI, I am trying to save myself the work of creating 2 reports and 2 separate queries for the sake of one field. On one of my forms, I have added a button to export a report of the information on the form. The report has a field 'ManagementDeliverability' which won't always be completed in the...

Hi, One user of my database is getting the error below when clicking a save button. The code behind the button sends an email and I wondered whether this was because the button had been clicked twice which would have caused the code to try running when it already was. However, I have tried to...

Hi, I have a control on a form which has an AfterUpdate event which should automatically update another control. See below: Private Sub Approval_AfterUpdate() On Error GoTo ErrorHandler 'Passes financial year ID to grant record based on approval date If Me.Recommendation = "Approval"...

Hi, I have 4 reports in my database which do not open when opened in report view. The queries the reports are based on have been updated but it was just the change of a field in one table to a field in another and the query works perfectly when run alone. The reports worked fine previously so...

Hi, I'm not quite sure whether what I want to do is possible but, here goes: I have a reporting form in my database which can be used to select a list of reports and the criteria for the reports. The example below will bring up all the grants our organisation has made in a specific geographic...

Hi, I have just split my database and created a .accde file to send out to users. However, when opening the .accde file the warning below pops up. When I click 'open' it takes me to the log in page which is fine but I'm trying to prevent users from having to click the message every time they...

Hi, Is it possible to use VBA to format a text box control as a hyperlink when only certain conditions are met? Here is a snip from a continuous form I have which lists the tasks assigned to a user: What I would like to do is only format the 4th column as a hyperlink when there is a number...

Hi, I have a simple select query which is the data source for a combo box. The values which show in the combo box are from column 2 (Country). The query results are below: At the moment, the combo shows all the instances of 'England'. Is there any way I can get the combo to show only one...

Hi, I have a mail merge query which allows me to pull all the information I need from one particular parent record on one table and add this to a word document. For each parent record there are up to 3 child records from another table that I also need to add to a table in the word document...

Hi I have a combobox on a reporting form which uses VBA in the On Load event to pull the values from the reports that I have in the database. Although the reports always show alphabetically from a - z in the navigation pane, they don't show in alphabetical order in the combobox. Is there any...

Hoping someone can help. I have a number of checklists in my database which I have built using the fab tutorials from Nifty Access. All my forms have the fields disabled until the user edits this record via the click of a command button. I've included this to prevent unintentional editing and...

Hi All, I am trying to add the facility for my users to import a CSV file via a button on a form. The code in the on click event of the button is: DoCmd.TransferText acImportDelim, "ImportTempT", _ "S:\IT\1 - Testing\CSVTestTwo.csv", True But I keep getting the run time error saying...

Hi All, I have a mailing list form in my database were I need to filter organisations by 4 geographical areas. i.e. UK region, local authority, constituency and combined authority. Sometimes I will need to search for and send emails to all organisations for a certain region or local authority...

Hi I'm having problems with a section of code which previously worked but I can't see why it isn't fully executing now. Here's the code: Private Sub SaveFirstAuth_Click() Dim OrgURN As String Dim GrantURN As String On Error GoTo ErrorHandler OrgURN = "Org URN " & Me.OrganisationURN GrantURN...

Hi I have the following code in most of my forms when exiting. Private Sub ExitComms_Click() On Error GoTo ErrorHandler Dim ctl As Control 'If record is changed do you want to save changes If Me.Dirty Then If MsgBox("Do you want to save changes?", vbYesNo + vbQuestion, _...

Hi, Hoping someone can help. I have the following code in my database which, when a payment is authorised, will send an automatic email to our finance team to say the payment needs to be made and will also attach the bank statement from a file directory. However, if the file doesn't exist/is...

Hi, I have the following code in the form load event of my reporting form: Dim NewValList As String NewValList = "" Dim obj As AccessObject For Each obj In CurrentProject.AllReports NewValList = NewValList + Chr(34) + obj.Name + Chr(34) + ";" Next obj Me!ReportCombo.RowSourceType = "Value...

Hi, I am using Albert Kallal's super easy word merge in my database. When I add templates I need to be able to restrict editing of the word document for document control purposes. However, this option isn't available when I add the template. Is this intended or should I be able to restrict...

Hi all, I'm hoping you can help. I have recently updated one of the forms in my database which has a tab control. Within 3 of those tabs I have subforms, one of which I have just added as part of the update. The tab control is quite high so usually you have to scroll down with the mouse...