Search results

Hi all, I am hoping someone cal help me. I am aure this is simple but I cannot figure out how to do it. I have created a popup form that has a button 'Send for Review', when this button is clicked it opens an email, and then another popup (SentRevDetails) which prompts the user to put in the...

Hi all, I currently have a form setup for User Login into a specific part of my database. Staff are required to enter their staff ID and then their password. I have got this set up to the point where it takes them to the correct screen if their password and username are correct, and gives them...

Hi All, I have a form that has a search function and I would like to ensure the search does not show any results where the ‘assessed date’ is over 2 years old. I thought I put in the correct code, as it took of the results that were over 2 years old, however I have noticed now that anything...

Hi All, Hoping someone can help me again. I have a combo box on a form that has a code and a title. Once the selection has been made it puts the title of the selected code into a text box (automatically). There is also 'equivalents' to some of these units, and if the equivalent is stated in...

Hi All, I have written a code on a button to automatically put details from my database into an email. I had the code working, however I was not able to format any of it, and from research I believe it is because I did not have it in HTML format. I have changed my code to HTML, however now it...

Hi all, I have a code to open a new email which puts in the data I want it to. However i would like to be able to format certain Sections so they are bold. EG: Based on the code below I would like to format the "Internal Unit Code:" and "Internal Unit Title:" parts to Bold. Could someone...

Hi All, I have a "deactivation" tick box on one of my forms, when this box is ticked a sub form appears which requires you to put in the deactivation date etc. However, as sometimes this can be ticked by mistake or admin makes an error, if they press the exit button on the subform i would like...

Hi all, I am hoping someone can help as I am sure this is fairly simple but cannot seem to figure it out. I have a "Date assessed" Section that is in my original table. In one of my queries I only want it to show data that is older than 2 years from today's date, and my other query I would...

Hi All, I have a combo box set up and would like the user to be able to double click on a record which then populates the particular record into the relevant text box next to it. I would then like them to be able to double click on another record in the same combo box which would then populate...

Hi All, I have been using a the below code on double click to open a form to a specific record: Private Sub Internal_Unit_Code_DblClick(Cancel As Integer) DoCmd.OpenForm "AdminPrecedentDetails", , , "[External Unit Code] = '" & Me.External_Unit_Code & "'" End Sub This was working fine...

Hi all, I am hoping this is possible and someone can help me with a code (or macro). I have a checkbox set up in a form, when the checkbox gets ticked it brings up a subform which needs to be completed. However, if the button is ticked and the subform is not complete or the user changes their...

Hi All, I am in desperate need of some help. I am fairly new to creating access databases, I have a Search page that filters the results in a Subform below, and from this form I would like to double click on the code and have it open the details of that particular Code. I have added the below...