Search results

  1. A

    Button to Open New pop up, open email and close previous pop up

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

    VBA code for Password Change

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

    Adding a Date

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

    Combobox to text field input

    Hi DB_guy, Thank you for your suggestion. I have tried decompiling as suggested and unfortunately it hasn't worked :banghead:
  5. A

    Combobox to text field input

    Hi Arnelgp, thank you for the suggestion, however I have checked this and cannot see that there is an issue.
  6. A

    Combobox to text field input

    HI DB_guy, Thank you, I have done up a Dummy of my Database Quickly so I can explain what i was talking about. If you enter the 'database administration' part, then click on 'Add New Precedent'. Now if you Select an 'Internal Unit code', it will automatically enter the Internal Unit code...
  7. A

    Combobox to text field input

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

    Date Query

    Thank you Arnel GP and CJ_London both for your help. I have managed to get the code working for the dates within the last 2 years, however I am still having issues with the one that picks up only dates older than 2 years. I have put the attachments for the SQL, Datasheet and design view, so...
  9. A

    HTML Email

    Hi June7, I managed to change the font to the one I wanted :p:) Thanks again for all your help
  10. A

    HTML Email

    Hi June7, Thank you very much for your response. I had been trying to format it correctly with no luck (I am very new to this). Thank you so much for your assistance. I was wondering if you are also able to tell me where I would put the code to change the font that the email is in ? Thank you
  11. A

    Date Query

    Hi ArnelGP, I have tried this however when I open the query it is still showing all dates :confused:
  12. A

    HTML Email

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

    Date Query

    I still cannot manage to get this to work :mad: Below is my SQL, Could someone please let me know where I am going wrong before my head explodes :banghead: SELECT tblUnitEquivalence.UnitEquivalence_ID, tblUnitEquivalence.[Internal Unit Code], tblUnitInternal.[Internal Unit Title]...
  14. A

    Date Query

    Hi DB Guy and Bob, Thank you both for your answers, however I still cannot get this to work. I have put it in the Criteria part of the Query under the 'Date assessed' section and it still coming with dates from 2019 ? Any further suggestions or Something I'm missing ?
  15. A

    How to Bold part of Email.

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

    Code to untick box on exit

    Thank you very much. The data has not been entered Via a code already. Therefore if I put the IF Me.Dirty=False on the exit button of the subform what would be the next part of the code ? Then ?? Sorry I am fairly new to all this.
  17. A

    Code to untick box on exit

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

    Date Query

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

    Multiple Combo box selection

    Thank you TheDBguy you have just made my day!:)
  20. A

    Multiple Combo box selection

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