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 Mike Lewis 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: *

  • Users: cthai
  • Order by date
  1. cthai

    Reporting sum

    Thanks Duane! that works!
  2. cthai

    Reporting sum

    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...
  3. cthai

    Reporting sum

    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...
  4. cthai

    Auto Number

    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?
  5. cthai

    Date question

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

    Date question

    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"
  7. cthai

    Date question

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

    Date question

    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.
  9. cthai

    If text box is Null

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

    If text box is Null

    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.
  11. cthai

    name search with multiple tables

    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!
  12. cthai

    If text box is Null

    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 "...
  13. cthai

    name search with multiple tables

    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...
  14. cthai

    name search with multiple tables

    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...
  15. cthai

    combo box when use show only number?

    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.
  16. cthai

    IF date is nulll

    thanks for all your help! i was able to figure out what parameter I need to set... some of the date range is NULL so it show up #ERROR# so what i end up doing is have it just give the date the user generate the report... when there is no data match. thanks again for the help!
  17. cthai

    combo box when use show only number?

    Hi -- SOrry yes it's me again... i am creating a button where it will input the data into a text box - everything works EXCEPT Me.txtIssueCategories this field is from a table and when i look in access the "Row Source" is from an SQL statement- when the button is click Me.txtIssueCategories...
  18. cthai

    .body ""Too Many Lines Continuation" Error"

    thanks ALL! i did not know that there was a limit to breaks... but now that i know.. i think i might need to stay away from it...
  19. cthai

    .body ""Too Many Lines Continuation" Error"

    Hello - i'm working access 2007 and creating an email with 4 attachement but i am getting an error message "Too Many Lines Continuation" the body of the email is pretty long and there are a few breaks in there... is there away i can get around this? .Body = "Dear " & vName & "," & vbCrLf &...
  20. cthai

    IF date is nulll

    Hi not sure if this is possible but can we show a date when the data is null? I have a [Begin Date] and [End Date] where a user is prompt to enter a range of date that they would like to see the report... however when there is no data for the date it just come back blank... i would like to...

Part and Inventory Search

Back
Top