Search results

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...

Ok. I understood then. So now which approach is better you think: 1. To open a new entry form when NotInList or 2. To set focus text field "First Name" on the same form where combo box is ? For the 2 version the code is: Private Sub Combo19_NotInList(NewData As String, Response As Integer) On...

Thank you for your help. But is it possible to pass the FirstName and LastName(a new entry which is not in the list) to pass to the text fields "First Name" and "Last Name", so that I would not need to enter them again? I am not sure how to do that.

My ComboBox lists FirstName and LastName from the table "Patients". RowSource looks like this:

Thank you for the answer. Yeah I know what you mean. But I couldn't think of another approach to this. Do you have any ideas? If not, at least can you give me a hint or something how to make my method to work(just with the last name and first name) ? Thank you very much!

Please, someone!