Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    DC Metro, District Of Columbia, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    blog-like editable call log (access 2007)

    I have a customer asking for a phone call logging app. I want to use (żor do I not?) Access to have a dropdown list for the tech; time/date stamp; other dropdowns or info fields; and the comments box. This log entry will be viewable by all the techs. It will be editable by all the techs adding work log notations as needed. The log will be a daily log of all calls for each day and at each EOD the log will go into a month archive log. I also need this log app to be on our web (sigh). I am open to all [useful] <img src=/S/grin.gif border=0 alt=grin width=15 height=15> suggestions and or advice. BTW, does Access allow this type of on-the-fly/blogging type of action? TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: blog-like editable call log (access 2007)

    Access is not the ideal application for something that needs to live on a website. I'd either explore dedicated blogging software (which probably uses MySQL), or other web-specific software.

    For a (non-web) Access solution, you could use a memo field (let's say memLog) to contain the text, and an unbound text box txtNew for entering new entries, with a command button cmdAdd to add the new entry:

    Private Sub cmdAdd_Click()
    If IsNull(Me.txtNew) Then
    MsgBox "No text entered.", vbExclamation
    Me.txtNew.SetFocus
    Exit Sub
    End If
    Me.txtLog = Format(Now, "mm/dd/yyyy h:mm AM/PM") & vbCrLf & vbCrLf & Me.txtNew
    End Sub

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Location
    DC Metro, District Of Columbia, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: blog-like editable call log (access 2007)

    Thank you, Hans. I will try the Access solution and see if they can use it as is. If not, I will try to get a COTS package my IA people will sanction/approve for the network.
    JL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •