How to Open a Form and Go To a New Record and a Specific Field in Microsoft Access

Поділитися
Вставка
  • Опубліковано 10 гру 2024

КОМЕНТАРІ • 27

  • @mikea8659
    @mikea8659 2 роки тому +2

    Couldn't be better timing, I'm coming to the end of my first database project for my business and needed this for a couple of forms that I wanted to open as a new entry but still be able to select existing records. Thank you 👍

    • @599CD
      @599CD  2 роки тому +1

      Glad it was helpful!

  • @gregskipa
    @gregskipa 2 роки тому +1

    I love your videos. Always informative, usually relevant, and whimsical enough not to put you to sleep. I keep waiting for the next Star Trek reference...

    • @599CD
      @599CD  2 роки тому

      Thanks. I'll do my best to make it so...

  • @petewarby7158
    @petewarby7158 Рік тому

    Endless learning, brilliant channel!!!

    • @599CD
      @599CD  11 місяців тому

      Thanks

  • @moodkn
    @moodkn 2 роки тому

    Very Helpful & Improving for Data Entery Video.
    Lot of thanks Sir!

    • @599CD
      @599CD  2 роки тому

      You are most welcome

  • @andrewgresham8675
    @andrewgresham8675 Рік тому

    Thanks - great courses and great tech help!

    • @599CD
      @599CD  11 місяців тому

      Welcome

  • @blaker3917
    @blaker3917 Рік тому

    First off, thank you tenfold for the help. We just discovered Microsoft Access for the company I work for, I was tasked with building a database that we can use, well, here I am a week in and a website membership and HOURS spent watching your videos!!!
    My question is, is there a way to go to a blank new 'VehicleF' I want a button on our menu to add a new vehicle to our fleet, then I can replicate this for trailers, heavy equipment and mowers too! I hope my question is detailed enough, I think you should understand what I am trying to achieve! :)

  • @cruzinsweetsntreats
    @cruzinsweetsntreats 2 роки тому

    This will help me with 2 logs that I hadn't been back to in a couple of weeks: mileage (critical for taxes) and refuel. I had stopped looking for a proper method to jump to the *end of record set* to continue it on. Of which, I have the default date for a new record, set to use the last record, so I can easily enter the older data by changing just the numerical day.

    • @599CD
      @599CD  2 роки тому +1

      Glad it helped!

    • @cruzinsweetsntreats
      @cruzinsweetsntreats 2 роки тому

      @@599CD it will, just a matter of *doing* it. 🤔🤪🤫😎

  • @johnschulte5820
    @johnschulte5820 2 роки тому

    These are always great stuff!

    • @599CD
      @599CD  2 роки тому

      Glad you think so!

  • @celestebird7049
    @celestebird7049 2 роки тому

    Thank you!!! I love your videos, you have helped me so much!

    • @599CD
      @599CD  2 роки тому +1

      I'm so glad!

  • @قناةمحمدالحكيم
    @قناةمحمدالحكيم 2 роки тому

    Dir Mrs Richard, l wait to your videos everyday. You have a good way to make every thing easy, please keep that way.
    I have question about your beginner level 2 please. Why you stopped ?! Sorry if I'm bothering you.

    • @599CD
      @599CD  2 роки тому

      Mrs. Richard? Oh no... I'm definitely a Mr. LOL - I'll be releasing videos from Beginner Level 3 soon.

  • @stephenbeswick2163
    @stephenbeswick2163 2 роки тому +1

    Hi Richard that was very interesting in this video great steve

    • @599CD
      @599CD  2 роки тому +1

      Glad you enjoyed it

  • @KeirBriscoe
    @KeirBriscoe 11 місяців тому

    Cant get this to work. The Single subform opens and looks like a new record can be entered. But Neither maintableID or the subtableID fields have data. So the new sub record is not linked to anything and generates an error when I try to close the subform. Ive gone over this tutorial many times and still no luck. Does this tutorial only work if the subform is continuous?

    • @599CD
      @599CD  11 місяців тому

      Shouldn't matter.

    • @KeirBriscoe
      @KeirBriscoe 11 місяців тому

      @@599CD I agree, however it does not work. The sub record created does not have the foriegn key of the parent record.

  • @javatea111
    @javatea111 Рік тому

    Hi there. I need help please. I need to select the new record on a subform where data will be filled in. My form is already. Any suggestions please. Thanks

    • @599CD
      @599CD  Рік тому

      599cd.com/ask