Search results

Hello - I'm tying to do a mass update adding notes to our Access 2007 database, but I'm running into an issue - I am matching an empyee ID worksheets up with our master table in access 2007. i would like to add a note that say: Date: Batch update: subj is part of upgrade project. subj has...

Hi Brian - when i enter Expr1:([comments] & " vbNewLine & "4/8/2011: DOB updated" ) I'm getting an error "The expression you entered contains invalid syntax" but when i enter: Expr1: ([comments] & "4/8/2011: DOB updated.") & Chr$(13) & Chr$(10) the comments does get added but not a...

Hi David - how do i make sure that the comments (text) is started on a new line? i want to make a break at the end of the comments and then added my comments.. right now i have it Expr1: ([comments] & "4/8/2011: DOB updated.") & Chr$(13) & Chr$(10) this is adding the comments at the...

Thanks Brian and David for the respond! I test it out and it works great! - i have a question thou - will this work if i need to update 200 thousands records? i would like to double check and make sure that the comments was added at the end of the comments textbox and that there is a break...

Hi all - I just updated a field in our master database with people DOB that matches their emp ID - I need to do a mass update in the comment field that say "Updated on 4-4-2011" but does not delete the the current comment that is already there in the comment field - i'm not sure how to go about...

Hello - I working of a store procedure in access and i'm tying to update 3 addition fields to a table called tblapplicant. I already added the fields in the tbleapplicant - but when i modify the procedure the 3 new fields which [CVS SOB],[CVS COB] and [PLACE OF BIRTH], would not update into...

Hi gemma-the-husky Thanks! yes it's a bit strange how things are created but table1 is reading from one form and table2 is reading from another form - we are in the process of standarizing these forms so it's just a process so that we can update the tables with the information - before table2...

hello - I have table 1 and table 2 - both tables have the same fields however in table 1 they have state of birth, city of birth and place of birth - and table 2 have the fields but it's all blank - i would like to update or insert the state of birth, city of birth and place of birth from...

Hi Brianwarnock - Thank you, I just sort of play with the dateadd realize i am using the Dateuse within the datedd so that's just going to work... i havent figure out how to get the criteria to work... any suggestion?

oK - So i gave it a try and got an error about a comma?? "Syntax error (comma) in query expression IF............." this is what i have... TEST: IIf([TYPE]="CCB" OR [TYPE]="CCB-PR" OR [Status]="S" OR[Status]="NC",DateAdd("m",-6,("yyyy",10,[DateUse])))

Hi - is there a way i can nest an IF statement with 4 criteria? in my access2007 i have a field called dateuse => DateUse: IIf([DATE1] Is Null,[Date2],IIf([DATE1]>[Date2],[DATE1],IIf([DATE1]<[Date2],[Date2],[DATE1]))) Then i have a another field called Type => CCB CCB-PR SSB SSB-V then i...

Hi - I have a table with 2 different dates fields - and i can't get it to show me me the date I would like to get the query to run something like this -- IF Date1 is GREATER then date2 use date1 IF date1 is LESS then date2 use date2 if there is no date1 use date2 right now it's only...

Hi - was reading this and i am having the same issue but i am using access2007 - where can i go to have the form automati open when the user click on the mdb? and can we hide the tbls and query as well?

Hello - I'm not sure if i am going about this the correct way... I have a table with 2 different date fields - 10years date and 5years date - i would like to combine the 2 fiels to one and call it ALLdate: so this is wha i would like to have the final result to look like Field:10yrs date...

BTW - sorry if i am asking a stupid question... i am a NEWBIE at access...

hi boblarson First off THANK YOU for the quick respond! when i enter the information in my "criteria" i am getting an error message "The experssion you entered has a vaalid. (dot) or ! operator or invalid parenthese. You may have entered an invalid identifier or typed parentheses follwing...

Hello - I have a query appending to a table called tblCompDate In the query I would like my tblCompDate to show me a column called Date_Report and in the Date_Report column I would like it to use Completion_date PLUS 10years THEN minus 6Months to be the output of the date. so for...

Thanks a bunch! going to test it out now

how can I set the Date function for user to enter a date to generate the data? i have a make-table query - and in that query each day we have to change the date (, #3/4/2011# AS CAP_DATE) to yesterday date is there a way we can have the query or set it to read yesterday date? and if it's...

Hello - I'm tying to INSERT information from HRM table into HRM_final table and i am getting an error asking me to enter a Parameter value. I'm still very new at this access stuff - any help/suggestion? DoCmd.RunSQL "INSERT INTO HRM_final SELECT HRM.SSBN, HRM.title, HRM[ORG code] FROM...