Recent content by Kuleesha

  1. K

    Linking access with outlook

    Managed to get it working with following code I found at another site : Public Function AddAppointmentP(ByVal BD As Date, ByVal Endo As String, ByVal PT As String, ByVal Hos As String, ByVal CN As Long) As Boolean Dim olApp As Outlook.Application Dim olAppt As Outlook.AppointmentItem Dim...
  2. K

    Linking access with outlook

    Actually it's not an error message I get with above code. Even with above code trying to direct the appointment into the private folder, the appoitment gets saved in the parent folder (calendar). Below is the folder structure I am using: The error threw up when I tried to place the private...
  3. K

    Linking access with outlook

    This didn't work. I tried modifying my code as follows but still get the same error messsage (object not found) Sub ShowCalendar() Dim olApp As Outlook.Application Dim olNs As NameSpace Dim olParent As Object On Error Resume Next Set olApp = GetObject(, "Outlook.Application")...
  4. K

    Correction - I have received an email but when I try to login with the link I get a message "An...

    Correction - I have received an email but when I try to login with the link I get a message "An error occured while confirming your account". I tried to register with senarathkuleeshakodisinghe@gmail.com also but have not received a confirmation email. Thanks
  5. K

    Hi I've been trying to register at utteraccess but never received an email. Could you please...

    Hi I've been trying to register at utteraccess but never received an email. Could you please help me. My email address skkodisinghe@gmail.com. Thanks
  6. K

    Linking access with outlook

    Thank you for this. I am actually trying to access the calender folders (not mail). I have a calendar called "private" under the calender folder and want to create appointments in this.
  7. K

    Linking access with outlook

    Thanks but I cannot figure out how to use this in my situation. I tried adding following code to the public function but i get an error that he object could not be found Dim Ol As Outlook.Application Dim appt As Outlook.AppointmentItem Dim Ns As Outlook.NameSpace Dim myDestFolder As...
  8. K

    Linking access with outlook

    Hi, I have a form which is used to give appointments. I need these appointments to show up in outlook calendar. I have successed partially by using following vba code in public function and then calling on this function in the VBA code of the form: Public Function AddAppointment(ByVal BD As...
  9. K

    Updating textbox populated by vba code

    Hi, I have a textbox on my form which is populated by VBA code. I want this details to be updated in a query as soon as I type in the data / by the time I move to the next textbox. A pop up form has to display the data in the query. I have placed the following code on the change event of the...
  10. K

    Subform not showing correct data

    Many Thanks Pat. I will go through the database that you have attached.
  11. K

    Subform not showing correct data

    Thanks for the advice. What I meant by personal use is I am the only one who is going to use it. I'm a practicing doctor and would like to track my patients with it. I will try to restructure my DB along your lines of thought
  12. K

    Subform not showing correct data

    I am in the process of developing my first database. This db is only for my personal use. I will try to explain my problem as best as possible. Since explanation only is propably not going to be enough, I am attaching my database with dummy data. Here's how the database works: Welcome screen...
  13. K

    Prevent duplication of records in the entry form

    Th Thank you for taking your time to help me. I am preparing this database only for my personal use. It's my first one. I have very rudimentary knowlege of VBA and actually up until one month back I had not even opened up access on my computer. :) Your advises are immensely helpful to me. I...
  14. K

    Prevent duplication of records in the entry form

    Thanks @Pat Hartman for the advise. I have put in the validation code to the on change event of the visit date field bit still end up wit hthe same problem. I have attached my database with dummy data to make it more clear. From Welcome I enter the relevant patient by double clicking on...
  15. K

    Manually adding data to a autopopulating text box

    Thanks guys. I ended up using an extra control as Gasman suggested.
Top Bottom