Recent content by cthai

Thanks Duane! that works!

Hi 1DMF - thank you for the respond. when i do the sum in my report i'm not getting the total number of close cases...i added the code you references above to my query. when i try to sum it in the report =Sum([iClosed]) i get 3 rather then the total number of closed, sorry i'm not really good...

Hello - I have a report in Access 2008 and i have a call records and a field called Total, and another field called Status... in the total field i have numbers and in the status field i have [closed] and [open] i want to sum the total amount that was closed. how do i get the report to show me...

Hello - I have a database in Access 2007 with an Auto Number - "FY2011-01" each time we add a record the number at the end of FY2011-## change.. however now it's FY2012 I would like to start with FY2012-01 instead of FY2012-305 is there a way I can set the record to start at 01?

Hi PHV! Yes! how do I get that to POP UP in the record? like sort of a pop up message

Hi Skip, Sorry if I misunderstand the suggestion you ask. so i have [2Years: DateAdd("m",+24,[Date Case Closed])] in my query I would like a pop up on the front end that notify me when 2Years match the current date... and say " Date reach 2 years record need to be deleted"

Hi PHV- the date i have in is my query - 2Years: DateAdd("m",+24,[Date Case Closed])

Hello- How do I generate a pop up that tells me when a "Date Closed" have reach 2 years and need to be deleted. Currenly I have a date function that said "Date_Closed" I would like when the "Date_closed" reach 2 years from the date that a pop up will notify me to delete the record.

Thank you AceMan! I did Me.Determination_date.undo so that when they do enter the date it will undo the informations.

Hi Randy700! How do you lock or disable the text box? so the text box i would want to lock/disable would be the Determination_date - if txtDetermination is NULL then Determination_date can not be fill in.

Hi dhookom Thank you! I change First to FNAME and Last to LNAME. I'm not sure why there is 5 different tables... but that was how they were created. Now I have to go back to each table and change the name to FNAME and LNAME and relink all the fields. Thank you for ALL your help!

Hi, I have a form and we have a txtDetermination and a Determination_date - what happen is the user will enter the Determination_date but does not fill in the txtDetermination (this is a drop down, "Pass" or "Fail") is there a way that we can have a pop up message that tell the user "...

Hi dhookom - Each tables have different information - they would like to do a search to for all tables with the last name "Smith" and show the case ID - each case ID is a unique ID. below is my attemp to do the union SELECT InsiderTracker_Main.[Case ID], InsiderTracker_Main.Last...

Hello - I am trying to do a name search from a button. It works fine when I only have 1 table to search the last name by… however now I am ask to add 5 other tables to the search, is there a way I can have 1 button search through all 5 tables and show me anyone with the last name “Smith” I...

Hi BobRodes - If txtComments.Text = vbNullString Then there reason for this is the text bx (txtcomments) sometimes is blank and if it's blank then just drop in the notes...but if it's not blank then drop the notes at the end of the text box.