Recent content by cluendo

Dear colleagues, Is it possible to pass the Access report to excel (by clicking a button) and do the following things automatically: If record contains groups, then group by category in the excel and sum the total price from [price] field in the Report, then from each group deduce specific...

Hello. Here is a nice example of pupup calendar. Everything works fine, except. When the text box is not bound to any table the date format is like this: d/mm/yyyy. I want to be like this DD/mm/yyyy. E.g. if it's the 1st day, the it shows like: 1/02/2012, but I need 01/02/2012. Maybe there is...

Thank you! I'm on the track now. I am almost done, but one thing is still not clear. Images how it looks now: Query: tables relationships: What do you actually mean by "In the Design View of the Query, Add a second copy of tblPeople and Link the new Copy to the Doctor Field." Is my...

Anyone ? :( sorry for impatience.

Thank you! But it's not completely clear to me, how I am going to select Which patient belongs to which doctor(s) ? So far I have "Patients" table one to many relationship to table "Visits". I've attached image to better see. Now I just need to be able to select the "tick box" on form and so...

Hello. I have one question for you guys. I am not sure how approach the problem I have so I hope someone will be able to help me. Here it is: I have one table for "Patients" (ID, Name, bla, bla, bla) I have another table "Visits" which is in one-to-many relationship with table "Patients", so...

Ok guys, somehow I figure it out myself. I will post my code today, to check if it is efficient and do not have logical problems (although it is working) :) vbaInet - big thanx for you, but don't go away yet! :)

Thank you. I'm working on it as well. I never thought that notinlist event is such a pain. :) or it's just me.

Here you go: http://www.mediafire.com/?54g7m5fcewgu1bo I made everything again, but still get same error. Check it if you have little time! Thank you!

Ok. I cannot save it as older version because I use "some new features" lol. But I'm working a new one, fresh one :) It will be here in 10 mins.

http://www.mediafire.com/?gzkz8saciywubx6 It 2010 access file. I do not know how to covert into older versions. Hope you will be able to open it.

Ok I deleted my macro and made a code for save and close button: Private Sub cmdSaveClose_Click() On Error GoTo Err_Saveclose_Click DoCmd.RunCommand acCmdSaveRecord DoCmd.Close Exit_Saveclose_Click: Exit Sub Err_Saveclose_Click: MsgBox Err.Description Resume Exit_Saveclose_Click End Sub...

Now I get the usual error when using requery: "Run-time error '2118'" "You must save the current field before you run Requery action" My save button have this macro:

Ok, but where to put the combo9.requery code? And as I said before, when I save and close the AddNew form, the NotInList event occurs again.

Ok, now my code looks like this: rivate Sub Combo19_NotInList(NewData As String, Response As Integer) On Error GoTo Err_Patient_ex_NotInList Dim intAnswer As Integer Dim Db As DAO.Database Dim Rs As DAO.Recordset intAnswer = MsgBox("New Patient detected. Do you want to add it to the...