If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Button to open record details on continuous form with summaries
I've a continous form which shows a list of all records (to be precise, it
shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#2
|
|||
|
|||
Button to open record details on continuous form with summaries
What exactly do you mean by selecting it? You should have to click te button
once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#3
|
|||
|
|||
Button to open record details on continuous form with summarie
With "selecting" I mean that the focus is on an item in the record.
Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#4
|
|||
|
|||
Button to open record details on continuous form with summarie
Ok, as I read it your record state is "Dirty" is that what you mean? In that
case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#5
|
|||
|
|||
Button to open record details on continuous form with summarie
No, as far as my Access-knowledge goes, the record is not dirty: The
continuous form shows "search results", and gives a summary of the records which are found. These summaries are not editable. The problem is that when the "show details..."-button behind a specific record is pushed for the first time, the button does not function as a button, but just as a part of the record: you can click anywhere in the record to select it: on the button, but also on the text in the summary. Only when the record is already selected, the button functions as a button. "Maurice" wrote: Ok, as I read it your record state is "Dirty" is that what you mean? In that case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#6
|
|||
|
|||
Button to open record details on continuous form with summarie
Hmm, that's weird. Sorry to say that but you wrote that you have a continuous
form with a button on it. When I have a continuous form with a button on it, it behaves just the way you would expect it. This doesn't help you much I know but i'm just trying to figure out what can be possibly different in what i'mdoing here. So let me try to recap: you have a continuous form with textboxes on it for your recordset right. I presume a Excel like layout with rows and at the end of the row you have the button which takes you to the detailsform right? Just for the sake of it try adding another button next to it using the wizard which just opens an arbitrary form. If this opens with just one click replace the code from this button with the code from your button. -- Maurice Ausum "Sietske" wrote: No, as far as my Access-knowledge goes, the record is not dirty: The continuous form shows "search results", and gives a summary of the records which are found. These summaries are not editable. The problem is that when the "show details..."-button behind a specific record is pushed for the first time, the button does not function as a button, but just as a part of the record: you can click anywhere in the record to select it: on the button, but also on the text in the summary. Only when the record is already selected, the button functions as a button. "Maurice" wrote: Ok, as I read it your record state is "Dirty" is that what you mean? In that case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#7
|
|||
|
|||
Button to open record details on continuous form with summarie
Hi Maurice, I just wanted to inform you that I succeeded in making the button
work. It is probably not the most "correct" solution, but it works. To solve the problem of the details button, I replaced the event "On Click" by the event "On Focus". When the focus is on the button (which automatically happens when the button is clicked once), the event takes place and the record is opened. However, thank you for your time to help me! A problem becomes already half as bad when there is someone who cares about it too :-) Best regards, Sietske "Maurice" wrote: Hmm, that's weird. Sorry to say that but you wrote that you have a continuous form with a button on it. When I have a continuous form with a button on it, it behaves just the way you would expect it. This doesn't help you much I know but i'm just trying to figure out what can be possibly different in what i'mdoing here. So let me try to recap: you have a continuous form with textboxes on it for your recordset right. I presume a Excel like layout with rows and at the end of the row you have the button which takes you to the detailsform right? Just for the sake of it try adding another button next to it using the wizard which just opens an arbitrary form. If this opens with just one click replace the code from this button with the code from your button. -- Maurice Ausum "Sietske" wrote: No, as far as my Access-knowledge goes, the record is not dirty: The continuous form shows "search results", and gives a summary of the records which are found. These summaries are not editable. The problem is that when the "show details..."-button behind a specific record is pushed for the first time, the button does not function as a button, but just as a part of the record: you can click anywhere in the record to select it: on the button, but also on the text in the summary. Only when the record is already selected, the button functions as a button. "Maurice" wrote: Ok, as I read it your record state is "Dirty" is that what you mean? In that case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#8
|
|||
|
|||
Button to open record details on continuous form with summarie
Sietske,
Glad to hear you found a solution. Good luck building apps.. -- Maurice Ausum "Sietske" wrote: Hi Maurice, I just wanted to inform you that I succeeded in making the button work. It is probably not the most "correct" solution, but it works. To solve the problem of the details button, I replaced the event "On Click" by the event "On Focus". When the focus is on the button (which automatically happens when the button is clicked once), the event takes place and the record is opened. However, thank you for your time to help me! A problem becomes already half as bad when there is someone who cares about it too :-) Best regards, Sietske "Maurice" wrote: Hmm, that's weird. Sorry to say that but you wrote that you have a continuous form with a button on it. When I have a continuous form with a button on it, it behaves just the way you would expect it. This doesn't help you much I know but i'm just trying to figure out what can be possibly different in what i'mdoing here. So let me try to recap: you have a continuous form with textboxes on it for your recordset right. I presume a Excel like layout with rows and at the end of the row you have the button which takes you to the detailsform right? Just for the sake of it try adding another button next to it using the wizard which just opens an arbitrary form. If this opens with just one click replace the code from this button with the code from your button. -- Maurice Ausum "Sietske" wrote: No, as far as my Access-knowledge goes, the record is not dirty: The continuous form shows "search results", and gives a summary of the records which are found. These summaries are not editable. The problem is that when the "show details..."-button behind a specific record is pushed for the first time, the button does not function as a button, but just as a part of the record: you can click anywhere in the record to select it: on the button, but also on the text in the summary. Only when the record is already selected, the button functions as a button. "Maurice" wrote: Ok, as I read it your record state is "Dirty" is that what you mean? In that case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#9
|
|||
|
|||
Button to open record details on continuous form with summarie
Sietske,
What is the command you used off your "View Details" button. I'm trying to do the same thing, and my "view details" button is just not working! "Maurice" wrote: Sietske, Glad to hear you found a solution. Good luck building apps.. -- Maurice Ausum "Sietske" wrote: Hi Maurice, I just wanted to inform you that I succeeded in making the button work. It is probably not the most "correct" solution, but it works. To solve the problem of the details button, I replaced the event "On Click" by the event "On Focus". When the focus is on the button (which automatically happens when the button is clicked once), the event takes place and the record is opened. However, thank you for your time to help me! A problem becomes already half as bad when there is someone who cares about it too :-) Best regards, Sietske "Maurice" wrote: Hmm, that's weird. Sorry to say that but you wrote that you have a continuous form with a button on it. When I have a continuous form with a button on it, it behaves just the way you would expect it. This doesn't help you much I know but i'm just trying to figure out what can be possibly different in what i'mdoing here. So let me try to recap: you have a continuous form with textboxes on it for your recordset right. I presume a Excel like layout with rows and at the end of the row you have the button which takes you to the detailsform right? Just for the sake of it try adding another button next to it using the wizard which just opens an arbitrary form. If this opens with just one click replace the code from this button with the code from your button. -- Maurice Ausum "Sietske" wrote: No, as far as my Access-knowledge goes, the record is not dirty: The continuous form shows "search results", and gives a summary of the records which are found. These summaries are not editable. The problem is that when the "show details..."-button behind a specific record is pushed for the first time, the button does not function as a button, but just as a part of the record: you can click anywhere in the record to select it: on the button, but also on the text in the summary. Only when the record is already selected, the button functions as a button. "Maurice" wrote: Ok, as I read it your record state is "Dirty" is that what you mean? In that case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
#10
|
|||
|
|||
Button to open record details on continuous form with summarie
Hi Skot,
I'm sorry for my late response, didn't spot your question until now. I hope it helps a bit, still. Please let me know If you succeeded, so that others can benefit from your findings too. What I did, was the following: On the View Details-button I did NOT use an OnClick event, but only a GotFocus event. It looks like this: Private Sub btnViewDetails_GotFocus() On Error GoTo Err_btnViewDetails_GotFocus Dim strDocName As String Dim strWhere As String strDocName = "frmNameOfFormWithDetails" strWhere = "[Id_FormWithDetails]=" & Me!Id_FormWithDetails DoCmd.OpenForm strDocName, , , strWhere Me.NameOfAnyControlOutsideDetailsSectionOfForm.Set Focus Exit_btnViewDetails_GotFocus: Exit Sub Err_btnViewDetails_GotFocus: MsgBox "Error code " & Err.Number & ": " & Err.Description Resume Exit_btnViewDetails_GotFocus End Sub "Skot" wrote: Sietske, What is the command you used off your "View Details" button. I'm trying to do the same thing, and my "view details" button is just not working! "Maurice" wrote: Sietske, Glad to hear you found a solution. Good luck building apps.. -- Maurice Ausum "Sietske" wrote: Hi Maurice, I just wanted to inform you that I succeeded in making the button work. It is probably not the most "correct" solution, but it works. To solve the problem of the details button, I replaced the event "On Click" by the event "On Focus". When the focus is on the button (which automatically happens when the button is clicked once), the event takes place and the record is opened. However, thank you for your time to help me! A problem becomes already half as bad when there is someone who cares about it too :-) Best regards, Sietske "Maurice" wrote: Hmm, that's weird. Sorry to say that but you wrote that you have a continuous form with a button on it. When I have a continuous form with a button on it, it behaves just the way you would expect it. This doesn't help you much I know but i'm just trying to figure out what can be possibly different in what i'mdoing here. So let me try to recap: you have a continuous form with textboxes on it for your recordset right. I presume a Excel like layout with rows and at the end of the row you have the button which takes you to the detailsform right? Just for the sake of it try adding another button next to it using the wizard which just opens an arbitrary form. If this opens with just one click replace the code from this button with the code from your button. -- Maurice Ausum "Sietske" wrote: No, as far as my Access-knowledge goes, the record is not dirty: The continuous form shows "search results", and gives a summary of the records which are found. These summaries are not editable. The problem is that when the "show details..."-button behind a specific record is pushed for the first time, the button does not function as a button, but just as a part of the record: you can click anywhere in the record to select it: on the button, but also on the text in the summary. Only when the record is already selected, the button functions as a button. "Maurice" wrote: Ok, as I read it your record state is "Dirty" is that what you mean? In that case you can set me.dirty=false in the on click just before you open the form. hth -- Maurice Ausum "Sietske" wrote: With "selecting" I mean that the focus is on an item in the record. Literally: that you can see the Record Selector on the left pointing at the specific record that you want to watch in more detail. If that is the case, I can click the button of the specific record only once. Otherwise I have to click twice. It is not a toggle button. "Maurice" wrote: What exactly do you mean by selecting it? You should have to click te button once to open the form and view the details. Did you use a toggle button perhaps? -- Maurice Ausum "Sietske" wrote: I've a continous form which shows a list of all records (to be precise, it shows the results of a search query). In this list, a brief summary of each record is shown. To view details of each record, I have put a button "view details..." on the right side of each record which opens a form showing the entire record. My problem is: each "view details..." button has to be clicked twice to open the record. Once for selecting it, and once more to open it. How do I change this so that one click is enough? A possible solution is changing the buttons on the right of the record in a "select record" button, and put one button in the header of the screen, saying "open selected record". But I'd rather stick to the button I have. Is there an option like "OnMouseOver" or anything else I could use? |
Thread Tools | |
Display Modes | |
|
|