Search results

  1. L

    emailing a single page from report

    1. our work orders are only one page. it is not for customers. Because were are a manufactoring plant that makes food containers, we have audits that require documention that when problem arise that not only was the problem fixed but the place has been cleaned and in running order. supervisor...
  2. L

    emailing a single page from report

    I have a database that is strictly for generating and printing work orders. Our supervisors use it to print new work orders on the fly. normally that is fine. I have the Vb to print that specific work order what I need to create is a VB that would allow other people to create a work order that...
  3. L

    issues with IIF expression

    I just want to thank both of you for the tips. the NZ worked great. obviously i am not that expierenced with access. lol the Database that my job had me create is a bit crazy. but anyways thank you so much i learn a lot everytime i post here:-) Much Mahalo
  4. L

    issues with IIF expression

    figured out myself Training Dates: IIf(IsNull([Training Date]),[Training Datex],[Training Date])
  5. L

    issues with IIF expression

    sorry meant Training Dates: IIf([Training Date]=Null,[Training Datex],[Training Date])
  6. L

    issues with IIF expression

    gonna try to keep this simple. i have 3 columns Training Datex Training Date Training Dates Datex either displays a blank or 00/00/0000 (based on a previous query) Date display the training date if it was done. also could display a blank if no training has been done. if there is...
  7. L

    create a macro to export to an excel file using the current date as a name

    thanks i am gonna try it and let you know
  8. L

    create a macro to export to an excel file using the current date as a name

    pretty much the title says it all. i want to create a macro or VB that would export to an excel file and name the file the current date. if anyone can point me in the right direction i would greatly appreciate it Mahalo Nui Loa
  9. L

    Displaying a lack of data.

    Just wanted to thank you again. just tried it and thats exactly what i needed. Also learned something new so thats great also. ALOHA SIMI
  10. L

    Displaying a lack of data.

    thank for the suggestions, I will try it out and let you know the results. Thanks again. I really do appreciate it. ALOHA
  11. L

    Displaying a lack of data.

    Not sure the title is the best way to describe my problem. lol Well i have only been working on Access for a few months. The database i am working on keeps track when employee have been trained in a certain SOP document. I have a table for employees names and info, a table for SOP names and...
Back
Top Bottom