Recent content by larshgf

I have been working with this problem and found a solution for scrolling down and up is like this: Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long) If Screen.ActiveControl.Name = "name of your TextBox here" Then If Count > 0 Then SendKeys "{DOWN 2}" ElseIf Count...

Hi, I want to be able to scroll text in an unbound TextBox using the Scroll Wheel on the mouse. If I create this event-handler the Scroll Wheel will make the courser go down and in this way indirectly scroll the text in the TextBox: Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal...

Hi neileg, Thank you for your access db example. As I mentioned this solution can be used but it is not what I want. In the meantime I have solved the problem using this code in the Change eventhandler in my Combobox called "myselctor". I am choosing a patient in my combobox and in a big...

Thank you for your answers. I fixed the problem by changing my codeline from this: MyRecordSet.Open "[Journalnotat] WHERE (((Stamkort.[cpr-nr]) Like [forms]![Stamkort].[myselector] ORDER BY [Dato] DESC" To this one: MyRecordSet.Open "[Journalnotat] WHERE [cpr-nr] = '" &...

Does anybody know why I get an error message on this SQL statement for a RecordSet ? MyRecordSet.Open "[Journalnotat] WHERE (((Stamkort.[cpr-nr]) Like [forms]![Stamkort].[myselector] ORDER BY [Dato] DESC"

Thank you Neileg! Right now I do in fact use subforms for my journals and in this way I have the induvidual journal notes "stacked" upon each other with the date and the diagnosis to the left of the notes. It is not datasheet but all the same i have sort of 3 columns (1: date, 2: diagnosis, 3...

"My first solution has been af subform on the journal-tabsheet. But because it will look better I would like to do it like this:" Thank you MaxMangion but as I wrote I have used this solution and I would like the other solution because I want all journal text with headers (date & diagnosis) in...

Hi gurus! I have a problem which I hope can be solved in this forum: I have a Form (Frm_Patient) based on a table (Tbl_Patient) containing basic data on patients in my clinic (name, address, telephone, patient_ID etc). I also have a table (Tbl_Journal) containing journal data (date...

Hi, I have a database with a table containing basic data for patients (name, adress etc) and a table containing journal text (date, diagnosis, memo for notes). I have made a form/subform where the form contains the basic data for the patient and the subform contains date, diagnosis and memo for...