Using the On Double Click Event in Microsoft Access to Open a Customer Record or Increment a Date

Поделиться
HTML-код
  • Опубликовано: 16 дек 2024

Комментарии • 34

  • @SceneoftheCrymes
    @SceneoftheCrymes Год назад

    Thank you! My (two) database users asked for this and now, thanks to you, I can deliver!

    • @599CD
      @599CD  11 месяцев назад

      Sweet you're welcome

  • @kensimba7868
    @kensimba7868 3 года назад

    Will thank you for every great video umake. Love from Nairobi Kenya 🇰🇪

    • @599CD
      @599CD  3 года назад

      You are so welcome! Love back at ya from Florida.

  • @JoseBenavides456
    @JoseBenavides456 2 года назад

    Your videos are the best!

    • @599CD
      @599CD  2 года назад

      Glad you like them!

  • @vkfloyd
    @vkfloyd 8 месяцев назад

    Hi, can i use this same method to open another form from a record in a subform, instead of the main form?

  • @CStrieker
    @CStrieker 2 года назад +1

    is there a way to apply the Dbl Click command to the full row/entry instead of just a single field in the row? i don't want to repeat the process for each field. Thanks :)

    • @599CD
      @599CD  2 года назад

      Easier to just make a button to copy whatever fields you wanted.

  • @fadlicardio3828
    @fadlicardio3828 3 года назад

    Awesome tips. Thank you!

    • @599CD
      @599CD  3 года назад

      Glad it was helpful!

  • @bryanclark2779
    @bryanclark2779 3 месяца назад

    Great video, but when I try the "On Double Click" command, I get the error message: "Data type mismatch in criteria expression."

  • @angiemaroney1769
    @angiemaroney1769 3 года назад +1

    I'm using the same code but I'm getting a "run-time error 3075 syntax error in query expression". What am I doing wrong??? Ugh!

    • @599CD
      @599CD  3 года назад

      You've got something wrong in your query. 599cd.com/ErrorMessages

  • @justincollins4332
    @justincollins4332 2 года назад

    I keep getting the following error:
    Run-time error '3075':
    Syntax error (missing operator) in query expression 'CaseID='.
    This is my code:
    If IsNull(CaseID) Then Exit Sub DoCmd.OpenForm "MyOpenCaseF", , , "CaseID=" & CaseID
    I can't see what I'm doing wrong. Anything in particular I should check?
    TIA!

    • @599CD
      @599CD  2 года назад

      Your If/Then statement is not formed correctly.

    • @599CD
      @599CD  2 года назад

      If STUFF Then
      do stuff
      Else
      do other stuff
      End If

    • @599CD
      @599CD  2 года назад

      It looks like you want the DoCmd down a line below the If.

  • @cassidyhruska2790
    @cassidyhruska2790 2 года назад

    I would like to apply a double click to open a record from a search list selection. i cant seem to figure that out.

    • @599CD
      @599CD  2 года назад

      I get a ton of questions every day, and I don't have time to answer them all here on RUclips. Feel free to submit your question on my website at: 599cd.com/AskYT

  • @blakemandernach1070
    @blakemandernach1070 3 года назад

    Is there a way to jump to the record on the specified form but not have the records filter? I want to remove the navigation buttons on my forms and it also removes the filter button. I want to easily jump to these records but then be able to still go through all of the records. I see that on the ribbon you can remove the filter but it takes me back to the first record instead of staying on the one I want.

    • @599CD
      @599CD  3 года назад +1

      Yeah, you could perform a Find operation, but prefer this method. I usually turn off the nav buttons too and prefer people scroll thru records on my Customer List form which is continuous.

    • @blakemandernach1070
      @blakemandernach1070 3 года назад

      @@599CD Thanks for the info. I ended up just using a find button for now. I don't know why I didn't think of this earlier.

    • @CStrieker
      @CStrieker 2 года назад

      i had the same issue. i fixed it by clicking the subform and clearing the "Link Parent Field" and "Link Child Field" parameters.

  • @moodkn
    @moodkn 2 года назад

    Thanks..! Very Well

    • @599CD
      @599CD  2 года назад

      Welcome!!

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi2255 2 года назад

    Thank you

    • @599CD
      @599CD  2 года назад

      You're welcome

  • @sandeepsingh-fc8lk
    @sandeepsingh-fc8lk 2 года назад

    It doesn't work in my case. I used the same code and when I double click it says "Enter Parameter Value".

    • @599CD
      @599CD  2 года назад

      599cd.com/EPV

    • @halkawtmohammed3445
      @halkawtmohammed3445 7 месяцев назад

      you can rewrite the code like this it will work (If IsNull(Code) Then Exit Sub
      DoCmd.OpenForm "City Form", , , "[Code]='" & Code & "'" ) change the code and City form to your actual database names

  • @Nick28865
    @Nick28865 2 года назад

    Hello, how do I get this to stop giving me the the error, " the form name '[Bid Request Tracker Form]' is misspelled or refers to a form that doesn't exist. I know I have spaces in the form name but I thought the brackets would address that. any help would be appreciated.
    Private Sub Project_Name_Click()
    If IsNull([Project]) Then Exit Sub
    DoCmd.OpenForm "[Bid Request Tracker Form]", , , "[Project Name]=" & [Project Name]

    • @599CD
      @599CD  2 года назад

      Looks OK to me. Try removing the spaces just for the heck of it.