Search results

Hi all, I have a form with a button that is used to create or open a folder. It works OK when I use English names, but when I use Polish names with the characters, it simply does not work and opens my folder instead. Any clue how this could be solved? Private Sub btn_cv_candidate_Click()...

hi all, I actually solved this by combining both of your suggestions :-) Greetings.

Hi Ridders, I tried that one, but it puts all into one line (with spaces). If I have like below: point 1 point 2 point 3 It will put it like this: point 1 point 2 point 3 I can't use it like that. the invitation needs to have the points from the meeting and things will be hard to read that...

Hi all, I have the below code to copy from a textbox into another one but only as text (no formatting). I need to use the text for an invitation in Outlook as the invitation will not work with rich text format in the body created with vba. Me.acctions.SetFocus DoCmd.RunCommand acCmdCopy...

Hi all, Closing this one as I have partially solved, but still struggle with the past values as text. I will ask the question per separated. Greetings.

Hi all, At the end it is not needed to set the appointment in some one else calendar :-) Now I face a different problem. I needed to add a text box that would contain the minutes from the meeting. They wanted to have text formatting and I did set the text box to Memo and rich text format. This...

Hi all, I'm trying to make the below code work to add a reminder for another user in outlook. I use the appointment part. I works really nice on my outlook, but does not work on others Microsoft outlook exchange. Any clue where I go wrong? Option Compare Database Private Sub AddAppt_Click()...

Hi CJ London, yea, finally I went that way. I added the code to the click event in the cell of the data sheet and it does the trick. The cell then triggers the data appears in a list box that I have to show the sub data. Always nice to have great people like you in this great forum :-)...

Hi all, I was wondering if it is possible to click on individual parts of a list box selection. In the below code, I run a query from a button that is on top of a list box row headers. Would it be possible to click on one of the columns and have the same effect? After several hours of google...

hi all, I managed to solve it :-) Private Sub Command85_Click() ' next case button Dim stDocName As String Dim sSQL As String Dim sSQL2 As String Dim stLinkCriteria As String Dim Das_Record_id As String Dim rst As DAO.Recordset Dim longRecordId As String...

hi The_Doc_Man, I managed to make it work with your code :-) It is really great and I had really no clue this was possible like that and that is why I was using to create table and then use that to update. I still have a little thing that I did not manage to fix. It is about showing the...

hi Jdraw, sorry for my bad information :-( All analyst will press the button and then it should assign them the oldest case available. The criteria is: checker field with empty checker name, and empty checker date and the field status date the oldest. so it should get the top 1 of the list...

Hi all, I need to assign a case to an analyst with a certain criteria. To avoid that the analyst will just take the easy cases, he will need to press a button that will assign the case to him. The criteria for this is that quality check date is empty ,checker name is empty and the last status...

Thank you both, I will give it a try :-) Greetings.

Hi all, I have the below code to save the emails in a folder and insert the email into a database so all users can read the emails from a shared email box without the need to have a huge .pst file that only one person at the time can have open. All works fine, except a few emails that could...

Hi Ridders, Thanks a lot, it is working nice now. the only thing I totally forgot about is, that the users will actually first enter 3 fields with data and then copy the new dates to the record. If I have already 3 records (branch nr and account nr, name), then, the dates will be placed in a...

Ok, I got closer. Now it enters the date, but it twist the date into a different format. Can I set some how the date format to be dd/mm/yyyy in the code below? 'push the button to duplicate the dates in the sheet thing Private Sub btn_duplicate_dates_Click() Dim db As DAO.Database Set...

ok, I got a little bit further, just the dates are no correct now. I go some where wrong: Private Sub btn_duplicate_dates_Click() Dim db As DAO.Database Set db = CurrentDb Dim rs As DAO.Recordset Dim rst As DAO.Recordset Dim StrSQL As String Dim from_date As String...

Hi Ridders, Thanks for the tip, this is a good one :-) Greetings.

Hi all, I have a main form where there is a subform in datasheet view. the first 2 fields are date fields. This is part of a function to get data from a client based on a start and end date and. When we used the tool in Excel, when you had multiple clients with the same date range, you could...