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 :)
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!
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
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.
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.
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
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]
Thank you! My (two) database users asked for this and now, thanks to you, I can deliver!
Sweet you're welcome
Will thank you for every great video umake. Love from Nairobi Kenya 🇰🇪
You are so welcome! Love back at ya from Florida.
Your videos are the best!
Glad you like them!
Hi, can i use this same method to open another form from a record in a subform, instead of the main form?
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 :)
Easier to just make a button to copy whatever fields you wanted.
Awesome tips. Thank you!
Glad it was helpful!
Great video, but when I try the "On Double Click" command, I get the error message: "Data type mismatch in criteria expression."
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!
You've got something wrong in your query. 599cd.com/ErrorMessages
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!
Your If/Then statement is not formed correctly.
If STUFF Then
do stuff
Else
do other stuff
End If
It looks like you want the DoCmd down a line below the If.
I would like to apply a double click to open a record from a search list selection. i cant seem to figure that out.
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
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.
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.
@@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.
i had the same issue. i fixed it by clicking the subform and clearing the "Link Parent Field" and "Link Child Field" parameters.
Thanks..! Very Well
Welcome!!
Thank you
You're welcome
It doesn't work in my case. I used the same code and when I double click it says "Enter Parameter Value".
599cd.com/EPV
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
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]
Looks OK to me. Try removing the spaces just for the heck of it.