Search results

Hi Minty, I actually solved like this: Private Sub txtSomeTextBox_Click() Dim strListResult As String Me.txtSomeTextBox = Me.ListSearch.Column(0) & " - " & Me.ListSearch.Column(1) DoCmd.RunCommand acCmdCopy End Sub And it works nice. Just used a textbox, and when I click on it, it...

HI Minty, Hard coded in the query editor it works, just like this "#AA" I will work now on the button to see if I get it into the clipboard. I don't have to use copy like in excel? Greetings.

Hi all, I made a search tab where I use SQL query to populate a listbox with what I type in a text box. I works great, but if there is text that starts with a "#" then it will not show this example: #AA. I need to copy the first and second row into clipboard to paste it into a word document...

Hi all, At the end I just put the combobox straight in the main form. The user selects the option and the data is placed in the table and vissible in the subform. Then I just empty the combobox: Private Sub Combo786_Click() Dim stDocName As String DoCmd.GoToControl ("frm_step1_contact")...

Hi all, I made it partially work like this: the button on the main form opens a stand alone form that has the combobox in it. When I select one option, the click event triggers the below code: Private Sub Combo0_Click() Dim stDocName As String Dim Combo0 As String stDocName =...

I tried to have it on the form that pops up with the choice for phone contact outcome. Still no luck (it does not find the form with the controls) this what I got so far: Option Compare Database Private Sub Combo0_Click() Dim stDocName As String Dim Combo0 As String stDocName =...

Hi, I created the on click action, but on the small popup fomr. when the user clicks on one the combobox to select one, it will remember the choice and a debug.print will show the selected text, but I can get it to be passed on the table. Actually this table is a separate table that is used in a...

Hi all, I'm trying to capture a call outcome to our database. When the user calls the client, she/he needs to click on a button to pop up a form where she/he can select one of the 3 outcome of the phone call (like made contact, made no contact, call postponed). once the user selects an option...

OK, I found it, it is set, but the damn thing does not let the function work to show details for the selected record id, it just sticks there. Greetings.

ok, I did not try that one, will give it a try if I can find the setting Greetings.

Hi, I will give it a try. Thanks a lot. Greetings.

yes, I did with below code and without having the last part it works: 'Private Sub Form_Open(Cancel As Integer) 'Me.OrderBy = "end_date_working_on" 'Me.OrderByOn = True 'End Sub the empty dates are up, but it breaks the funcionality on the: Private Sub request_id_Click() DoCmd.OpenForm...

Hi Minty, It does the trick with the first code, but then it breaks the second code to open in the form the selected record id. Is there any way I can put thes order by? Greetings.

Hi all, I'm trying to filter a form in datasheet view to display a column called "end_date_working_on" to be on top the ones that have no date. It should be when the forms open up. I tried this code: 'Private Sub Form_Open(Cancel As Integer) 'Me.OrderBy = "end_date_working_on" 'Me.OrderByOn =...

Hi, I should have mentioned that the updates on the tabales are done by a different team that runs an update query and then change the updates acording to the data in the main system. It is done in the mornings and the users don't have access to the tables. I added your code to the on load form...

Hi, I meant that when the forms open, the function will check the status and update if necesery. If it needs to be changed manually and the status was changed in the morning directly in the table, then when the forms open the new status is there but not added those dates into the columns...

Hi Static, Can I use this also in a function so it trigers when it is changed in the table? Greetings.

Hi all, I have a 2 columns that needs to be filled in with a date. recently the status changed, but this should not impact the rest of the idea. If there is a status already filled in, and the user changes to "Approved - Awaiting Consent" or "Approved - Awaiting Documents" then it should fill...

Hi MarkK, Those dates are captured each on his on column. I still have problems with the function to fill in the date based on the status, but will open a new thread for that one. Greetings.

Hi MarkK, I managed to kind of solve it. I added a second column to the database. now I have to date fields to capture the [stop_status] and the [status_go_on] When a status is changed to "Awaiting Documentation" the first date is filled in. When the next status is changed to "Documention...