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

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

Hello colleagues, I'm struggling with Combo Box and Not In List event. I want to be able to "add new record of First Name and Last Name if it is not in the list. Here is the picture of how my form looks: I have two tables: "Patients" and "Visit" - these are related as one to many(one patient...

Can Someone fix this code please? Highlighted in RED. Basically it just gets the values from the ComboBox.. The thing is, it "gets" the values of First And Last Name correctly only when the Name ANd Last Name are equal lenght for instance: if the name is John Elli, everything is OK. If the Last...

Hello, Access Users! Situation: I have Simply two tables - Patients and PatiensInfo. Also I have two forms with the same names. So I use ComboBox in order to add not existing record. Everything seems ok, but here is a NotInList code: Private Sub PatientLook_NotInList(NewData As String...