Page 3 of 5 FirstFirst 1 2 3 4 5 LastLast
Results 21 to 30 of 41

Thread: have order form in excel 2003 and want to link customer details to an address databas

  1. #21


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Appreciate it.

  2. #22
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Hi Adasca
    Yes, its the IFERROR function. 2003 has an equivalent IF(ISERROR( that does the same job, except that the formula is twice as long. This is because you have to enter it separately for true and false on the error test. The introduction of the IFERROR in 2007 was effectively amending bad programming as the the coding for true and false would never be different. I'll need to change to the other error function and resend. Based on what you could see before amending N5 did it look promising ?

    Herc

  3. #23
    Yes - I think its on the right track. I should have split the name into two cells though, one for 1st name and the other for surname if its not too late to do that.

    Thanks again

  4. #24
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Hi Andrew
    Regarding the names, the database has full name, and also first and last name (separately). If you want the separate names, you just need to modify the invoice template and then alter the formulae in it to pick up columns S and R instead of T.
    Ive altered the formulae to take out the IFERROR function, and it works OK on my XP box thats running Excel 2003.

    Hercules
    Attached Files Attached Files

  5. #25
    Thanks ever so - this is the sort of functionality I was after. But to make it perfect, is there a way for a dialogue box to open on the service invoice worksheet? So, for example, by typing the letter s for smith (say) in the name cell, the table with the choices beginning with s appears as a form on top of the service invoice worksheet rather than on the accessname sheet?

    Possible or difficult?

    I am ever so grateful for your help Herc.

    Best
    Andrew
    Sussex
    (ps semi-honorary Yorkshireman as I used to live in Grassington)

  6. #26
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Andrew
    I can't think of a way to do what you ask without redoing the whole thing as a VBA module, with your service invoice becoming a VBA form. Personally I wouldn't go this way to gain a small benefit unless you have someone to provide VBA application support to update your system in the future.
    You could have everything on one worksheet, and place the extract table next to the Service Invoice template, but that doesn't do what you are really asking for.
    The closest is probably a drop down list that you could place on the template, but this would offer you a full list from the database rather than filtering as you enter. I think what you have is probably as good as I can get it.

    Best regards

    Herc
    (A Lancastrian living in Yorkshire, actually) ))

  7. #27
    Hi Herc

    Apologies for not getting back before now as I have been away from this. My database has over 3000 entries and when I tried amending the formula to change the range I managed to break the template. I have managed to replace your entries with mine (for the first 50 or so) but still get a funny with the first record coming up as record no 3 even if it is a completely different number. Any thoughts? I have included the spraedsheet so you can see what I have done. Of course, when I get it all working I would need to finally transfer the code to the first page and have I39 as the entrybox.

    Thanks again

    Andrew
    ps - The border near Skipton has moved backwards and forwards from Lancs over the centuries I gather

  8. #28
    Hi Herc

    Apologies for not getting back before now as I have been away from this. My database has over 3000 entries and when I tried amending the formula to change the range I managed to break the template. I have managed to replace your entries with mine (for the first 50 or so) but still get a funny with the first record coming up as record no 3 even if it is a completely different number. Any thoughts? I have included the spraedsheet so you can see what I have done. Of course, when I get it all working I would need to finally transfer the code to the first page and have I39 as the entrybox.

    Thanks again

    Andrew
    ps - The border near Skipton has moved backwards and forwards from Lancs over the centuries I gather
    Last edited by Ken Puls; 2013-05-05 at 06:21 PM. Reason: Attachement removed at user's request

  9. #29
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    I hope you haven't posted genuine phone numbers in that example
    Hope that helps

    Roy

  10. #30
    Quote Originally Posted by royUK View Post
    I hope you haven't posted genuine phone numbers in that example
    Thank you for your advice. The numbers do not relate to the individuals but it would be better to remove them. CAn you please advise how I can remove the attachment from the thread?

    Andrew

Page 3 of 5 FirstFirst 1 2 3 4 5 LastLast

Posting Permissions

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