Search results

  1. V

    Using Combo box selection to open form and goto record

    Sussed this now, it was because i wasn't telling it which form the field was on.:D
  2. V

    Using Combo box selection to open form and goto record

    Lovely, thanks very much! one more question. I have a yes/no field in the records that i would like to set to false when the record is opened. I have tried to append "FollowUpReq = False" but that doesnt seem to work. hes is the full code: Private Sub Combo9_AfterUpdate() Dim strWhereCondition...
  3. V

    Using Combo box selection to open form and goto record

    Hi all, I'm sure this question has been asked a million times on this forum but i am really struggling to navigate around to find my answer. I have a combo box called Combo9 in form NavigationF, the combo box displays the results of FollowUpQ Query. What I would like to do is when the user...
  4. V

    Add future dates on button click

    Hi all, I am very new to Access and have virtually no experience with vb, I'm trying to build a customer database with some forms that enable myself and a couple of others to keep track of customer contact. As you can see from the screenshot I have designed my form with 5 buttons at the bottom...
  5. V

    Go to end of field and insert new line and date

    Yes, thank you Pr2-eugin, the new code works much better, my only small gripe now would be that all text in the field is selected following inserting the date, so if i begin typing it overwrites it, is there a way to deselect the previous contents so i just get a blinking cursor following the...
  6. V

    Go to end of field and insert new line and date

    Hi CJ, thanks for your reply, field is indeed memo. I'm very new to this and I'm afraid i don't understand what normalising is and what the benefits are? If there is a separate record for each contact event, wont that make the database massive? or is that a dumb question? I had originally wanted...
  7. V

    Go to end of field and insert new line and date

    Ok, thanks. That code works a little better, it no longer overwrites what was there previously but it still adds the date immediately after what was written last. Is there a way to add a new line before it inserts the date? I have no code other that what you have just given me, with the...
  8. V

    Go to end of field and insert new line and date

    Hi all, sorry if this has already been asked, I've had a quick skim through the previous posts but have been unable to find a post that answers my question. I have set up a customer database for our small electronics company and i have built a form called contact history. In the form i show a...
  9. V

    New Member

    Hi all, I'm Anthony, a novice when it comes to Access and VB, I have been asked to come up with a company customer database for our small electronics manufacture company in Ipswich (UK) I look forward to badgering you with silly questions! (sorry) :D
Back
Top Bottom