Results 1 to 4 of 4

Thread: Solved: Hello all, a little help needed if possible...

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jan 2009
    Posts
    22
    Location

    Solved: Hello all, a little help needed if possible...

    To clarify a point before we begin, I don't want you to do this for me, but rather point out where I might learn to do this myself...

    I'm new to the forums, and as much as I am searching, each answer is having me ask twice as many questions. If there is a link, or reference somewhere else that provides the answer i'm looking for, then that would be fantastic, but some insight would be a great start if you can help...

    I have a particular requirement and what i'm wanting to do is use a form to add the following rather than input directly into a spreadsheet...

    A1 = ID number i.e. 1, 2, 3 // automatic on new record being added
    B1 = Timestamp // automatic as above

    C1 = Name of caller
    D1 = Address

    button which adds current record to the customer list and start a new record

    Ok, here is the more difficult bit, I need to see a filtered set of rows (records) in the form (a subform? is this right?) that allows me to select any record that has been added already and update them accordingly. I'll be eventually looking into colouring the backgrounds of the row depending on it's current activity...

    E1 = Current Timestamp // on a button click, i.e. when a call is responded to..
    F1 = Current Timestamp // on a button click, i.e. when a call is complete..

    With these two record additions / edits above, I'll be refering to two more buttons to change it's status....

    Reading all this, I realise that this may be a tall order and I might not get all the answers i'm looking for. To be honest, i would love to know how to do all this myself so links would of course be preferred.

    I'm looking at the vbax userformexample form that I got hold of from a link I was given. This gives me a little look into how things are done. I just don't understand how to adapt it to my needs.

    Many many thanks for giving this some attention and I hope to hear from you soon.

    All the best

    Insomnai
    Last edited by insomnai; 01-11-2009 at 07:50 AM.

Posting Permissions

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