Recent content by Jazmine88

  1. J

    Moving info from an unbound text box to a subform so it will be saved

    Thank you, I will try an insert query. At the moment it is only used by me until I can get it working but then I may see about letting other people have access to it as well so I may eventually add in a UserID.
  2. J

    Moving info from an unbound text box to a subform so it will be saved

    I have attached another screenshot so you can see what the form is doing. I have tried to achieve this with a bound form but it doesn't seem to work for some reason. I might have to start from scratch and try again. I have only been using Access for about a year or so and I think this is the...
  3. J

    Moving info from an unbound text box to a subform so it will be saved

    Thank you for your replies, I have included a screenshot of my form below: Basically, the user selects their Belt grade from the top drop down box and all the associated Korean terms can then be selected in the second drop down box and then they can see the answer in English in the third drop...
  4. J

    Moving info from an unbound text box to a subform so it will be saved

    The way I have set up the form is setting up all the controls as unbound and then doing VBA to make them work how I want, there may have been an easier way to do this but I wasn't sure how to manage it.
  5. J

    Moving info from an unbound text box to a subform so it will be saved

    Hi, I'm hoping someone can help, I am struggling with getting this to work. Basically I have a form with an unbound text box, in this text box I am putting in results from a test which I want to save so that when the form is opened again the information will still be there. I have tried doing...
  6. J

    DCount Help

    I will do, thank you 🙂
  7. J

    Hello

    😂😂yes it is difficult to make databases that can be used by non-techy people 😁
  8. J

    DCount Help

    Hi that’s great, thank you, I will try this so I can avoid hard coding 🙂
  9. J

    DCount Help

    Hi Minty This is great, thank you. I wanted to hard code the year in because I am doing separate text boxes for each year of meetings so I have now put in =DCount("ID","Meetings in 2021","Year([Date of Meeting]) = 2021") and it works!! I think I got a bit confused with the Year part as I was...
  10. J

    DCount Help

    Hi, thank you for your replies, I have tried using Year() as well in the code but it still comes back as a #Error
  11. J

    DCount Help

    Hi, I have been trying to put a DCount function into a textbox so it will count how many meetings have happened this year, so far I can have it count the total amount of meetings but when I add in the criteria it comes up with #Error. The syntax I am using is =DCount("ID","Meetings in...
  12. J

    Hello

    Hi everyone I am quite new to Access programming, well I say quite new, I have been building Access Databases for about a year or so to help my work teams productivity, I basically self taught myself and these types of forums have helped me loads when I get stuck with different functions. I...
Top Bottom