Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ODBCERRORKING

    prompt user to populate fields based on value in dropdown

    i have a field status code it is a dropdown list with certain codes called status_codes one of the list items is 61PM-Promised to pay i would like if the USER PICKS 61PM-Promised to pay THEN IT WILL MAKE THEM POPULATE OTHER FIELDS PROMISE _DATE,PROMISE AMOUNT,DUE_DATE
  2. ODBCERRORKING

    INSTALING OFFICE 2K ON 2000 SERVER TERMINAL SRVR

    IV ALREADY BEEN THERE SPORT THANKS YOU HAVE BEEN A GREAT HELP
  3. ODBCERRORKING

    INSTALING OFFICE 2K ON 2000 SERVER TERMINAL SRVR

    HELP I AM INSTALLING OFFICE 2K FOR 2000 SERVER TERMINAL SERVER AND AM RECIVING AN ERROR MSG THAT STATES INCORRECT COMMAND LINE PARAMITERS V 2.00.2600.1183 "PORTIONS OF THIS SOFTWARE ARE BASED ON AN INDEPENDANT JPEG GROUP.HAS ANYBODY RAN IN TO THIS
  4. ODBCERRORKING

    zip code fix

    have already defined as text but there are still 4 digit zips all in need to do is some sort of update qry where if there are only 4 charecters put a 0 in front no?
  5. ODBCERRORKING

    zip code fix

    i have a field in access that is a zip code field i dont know if someone has dealt with this before but upon import it drops the zero at the beginging of the zip all iwant to do is an update qry ti say! if zip_code holds 4 characters put a zero in front can anone help!
  6. ODBCERRORKING

    stuck

    After Insert event I GOT LOST I DONT KNOW WHERE TO PUT THE CODE? WILL THIS WORK BECAUSE FOR INSTANCE THEY FILTER FOR A PARTICULAR RECORD THEY UPDATE CONSUMER INFO EXAMPLE NAME AND PHONE NUMBER THEN FORGET TO DISPOSITION THE CALL IM JUST CONCERNED NOT A PROGRAMER BUT AFTER THEY INSERT WHAT? IS MY...
  7. ODBCERRORKING

    append to noted field

    iv been saying that the whole time pro! programers are a diffrent breed. ok how much should i pay for that sort of funtioality where i click a button a prompt comes up and asks me to put in new note. then appends the new note. i am a data analyst clean data all day in which i was forced into my...
  8. ODBCERRORKING

    stuck

    DID NOT DO THIS YET BUT ALSO CAN I DISPLAY A MESSAGE TO THE USER LIKE THIS? STATUS NEEDS TO BE UPDATED!
  9. ODBCERRORKING

    append to noted field

    SELECT T_Collection_Records.[Status Codes], T_Collection_Records.Notes FROM T_Collection_Records WHERE (((T_Collection_Records.[Status Codes])="SKT")) IS THIS THE CODE YOU WERE TALKING ABOUT POSTING ?
  10. ODBCERRORKING

    append to noted field

    ready to outsource should have no business even wasting your time still dont understand
  11. ODBCERRORKING

    stuck

    i have an access 2000 .mdb with a user form being used as the main user screen i have a field called status_codes on the userform that field is a dropdown box they click the correct status and currenly move on. the problem is the users r not coding this field and we dont know how its being...
  12. ODBCERRORKING

    append to noted field

    Sorruy about that just frustrated like i said not a programer this stuff just does not come easy to me what is this vbcrlf funtion that you are talking about? all i am trying to do is this run an update qry where a new note is gonna be appended to the notes field opposed to writing over it...
  13. ODBCERRORKING

    append to noted field

    THAT DID NOT WORK WHAT IS THIS vbcrlf ? ALL I WANT TO DO IS APPEND TO A NOTES FIELD AND PUT A SPACE BETWEEN THE OLD AND NEW NOTE BASED ON SOME CRITERIA. THIS IS AN ACCESS DATABASE WITH LINKED SQL TABLES BEING USED AS A DATASTORE. I AM NOT A PROGRAMMER HOW DO I AN UPDATE QRY IN ACCESS TO DO THIS...
  14. ODBCERRORKING

    append to noted field

    THAT WORKED GREAT BUT HOW DO I PUT A SPACE BETWEEN THE OL AND NEW NOTE I JUST UPDATED?
  15. ODBCERRORKING

    append to noted field

    is this an easy tasks can this be ran by a some sort of update qry? i have a field called notes on a user form that writes the field "notes" we are a billing agency i would like to know how to append a note to the users for that particlar day but if i update in that field it will...
  16. ODBCERRORKING

    not a valid bookmark!

    i am searching for a name in my table and i get not a valid bookmark message after finding out that there are #error in the table there are a least 10 records of this.does thos have somthing to do with it because i cant delete them and when i try i get the not a valid bookmark message is there...
  17. ODBCERRORKING

    Rookie trying a Delete tables Module

    Hello, i am looking to delete certain tables out of my database for the next run time.the tables that have to be deleted out of the database are IBMLOTUS_CEO_TEMP,IBM_CO_TEMP etc.. i would like to write some sort of code or process and put it behind a button in a form. where is the code written...
  18. ODBCERRORKING

    can passwords be assigned to a particular table in a database?

    i am trying to implement some kind of security to one of my table in access.is there any way to do that?
  19. ODBCERRORKING

    How do i get the melissa virus out of my machine

    How do i get the mellisa virus out of my machine?
  20. ODBCERRORKING

    Batch letters

    Hello, i an doing a little work for a Colletion co database I am trying to set up batch letters to run from a qry. i have the letter set up in a report which runs of a qry. everthing is fine with the letter but when i add the appropriate fields to the letter. the first page is fine i grabs all...

Part and Inventory Search

Back
Top