+ Reply to Thread
Results 1 to 11 of 11

Application Error 1004 on Search Update Function

  1. #1
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Application Error 1004 on Search Update Function

    Hi again,

    I have this code which was contributed by one of the guru's here however when this code runs it give the error message Application Error 1004 when doing search update. The code must detect that if the entered employee id is not on the list error message "Not Found in database" message should appear. Also if the user attempted to enter symbols or alpha characters it should prompt him a message that says "Please use Numerical Values Only". Please help.

    Please Login or Register  to view this content.

    Regards,

    Stoey

  2. #2
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Application Error 1004 on Search Update Function

    Any idea what am I missing here?

    Thanks,

    Stoey

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Application Error 1004 on Search Update Function

    I think you'd better use a combobox here, so that the user can't make 'mistakes':

    Please Login or Register  to view this content.



  4. #4
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Application Error 1004 on Search Update Function

    hi snb,

    first is i do appreciate your assistance and the solution you provided. well the reason for which I used a textbox is because I have more than 200 employee ids. so if i were to use a combobox, then there would be a long list when the user will click the drop down though I know that they can also manually enter the employee id with the use of combo box. another thing is that, if I were to use a combobox, most of the employee ids will be revealed...that i would like to keep as confidential to other employees...any other approach in mind?

    thanks,

    stoey

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Application Error 1004 on Search Update Function

    You don't need any of this using :

    application.username

    or

    environ("username")

    or

    createobject("wscript.network").username

  6. #6
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Application Error 1004 on Search Update Function

    oh pardon me but i dont get what do you mean by that...uhm well all what i trying to accomplish is that if the user enters an employee id which is not on the database then it would display a message that "employee id does not exist" something like that...im sorry if Im causing you pain here...but i do appreciate your ideas

  7. #7
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Application Error 1004 on Search Update Function

    anybody with other ideas?

    thanks,

    stoey

  8. #8
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Application Error 1004 on Search Update Function

    Why asking a user an employee id, if the user isn't allowed to know any ?

  9. #9
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Application Error 1004 on Search Update Function

    well obviously different users have different behaviors so with the current database im doing...i just want everything to not be displayed that is why i chose to use textbox and to manually enter the employee id...

  10. #10
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Application Error 1004 on Search Update Function

    Why not use an Inputbox, use the string value and do a search with the string?
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  11. #11
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    Re: Application Error 1004 on Search Update Function

    hi mordred,

    hmm..how do i do that? can you give me a macro if this is not too much for you to ask?

    thanks,

    stoey

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1