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
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
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?
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!
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...
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...
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 ?
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.