Search results

Hi All, I have been using a the below code on double click to open a form to a specific record: Private Sub Internal_Unit_Code_DblClick(Cancel As Integer) DoCmd.OpenForm "AdminPrecedentDetails", , , "[External Unit Code] = '" & Me.External_Unit_Code & "'" End Sub This was working fine...

Hi theDBguy, My apologies, yes it opens a pop up form. In regards to the below, where would I put this code ?

Hi all, I am hoping this is possible and someone can help me with a code (or macro). I have a checkbox set up in a form, when the checkbox gets ticked it brings up a subform which needs to be completed. However, if the button is ticked and the subform is not complete or the user changes their...

Thank you all so much for your Assistance. I do have one other question to ask. I have a combo box set up with a list in it and once the correct detail is selected it puts it into a text box. Is there a code that i can do so they are able to double click a detail, it adds it to the text box...

Hi JHB, Thank you so much for your assistance. You are not going to believe what was stopping mine from opening. At work we have Laptop docks and then 2 screens attached. IT let us know that when we press shutdown the laptop only goes to sleep. At the advise from a lady from work after reading...

Hi JHB, Please find attached a copy of my database with dummy data. I still can not figure out why it is not opening. Essay_Tee - Excuse my ignorance, I typed in the Debug.Print Statement - what is this supposed to do ? thank you everyone for your help.

Hi Essay_Tee & The_Doc_Man, Thank you both for your assistance. I definitely have the event procedure attached to the relevant textbox control. Please see screen shot attached. I believe I also have the correct code against it, and cannot see that there is any other code sitting in the...

Hi The_Doc_Man, Thank you so much for your response again. I have spent all day trying to figure out where I have gone wrong, and using the code above that worked, my double click event is now not even working at all. Is there anyway I could send you a copy of my database to have a look at and...

Hi The_Doc_Man, So we had it working perfectly, and then made another error in our database. We have had to rebuild the query and the subform, and now when we put the code in dblClick event, nothing is coming up at all when we double click. What are we doing wrong

Hi The_Doc_man, Thank you so much, that worked perfectly, you have no idea how many hours I have spent trying to fix that. Thank you

Hi Steve, Yes my field names have spaces in them, so I have therefore entered the brackets. In regards to the brackets in the 'Me.' part of the code, do I put the opening bracker before Me. or after the Me. ? I have tried the following: Private Sub Internal_Unit_Code_DblClick(Cancel As...

Hi Steve, Thank you very much for your reply. I tried the following: Private Sub Internal_Unit_Code_DblClick(Cancel As Integer) DoCmd.OpenForm "PrecedentDetails", , , "[Internal Unit Code] = " & Me.Internal_Unit_Code End Sub and now when I double Click I am getting a Enter Parameter Value...

Hi All, I am in desperate need of some help. I am fairly new to creating access databases, I have a Search page that filters the results in a Subform below, and from this form I would like to double click on the code and have it open the details of that particular Code. I have added the below...