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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by psaaccess

  1. psaaccess

    Runtime Error

    Hi,In our company we are using the Novell client Windows XP and the MS Access 2000 databases. We created Application Launchers and we've been adding access 2000 database shortcuts into the Launchers. We installed the MS Access 2000 & MS Access 97 runtime for users. The Launcher is pointing to...
  2. psaaccess

    Runtime error

    Hi, In our company we are using the Novell client Windows XP and the MS Access 2000 databases. We created Application Launchers and we’ve been adding access 2000 database shortcuts into the Launchers. We installed the MS Access 2000 & MS Access 97 runtime for users. The Launcher is pointing...
  3. psaaccess

    IIF statement on report column

    Hi majp, I tried PHV suggestion but it won't work. I am getting required values from table through query. After I got values I am running quesry that do sum of yes, NA scores than I am using IIF function on the report. So Please tell me, which way I can use solution?
  4. psaaccess

    IIF statement on report column

    Hi PHV, What is /2?
  5. psaaccess

    IIF statement on report column

    Hi MJP, Yes, How can I use that code in the report because total scores are coming from query. I wrote on the report control it won't work.
  6. psaaccess

    IIF statement on report column

    Yes, It has to be calculate 100% of yes answers and NA answers.
  7. psaaccess

    IIF statement on report column

    I created a report and user asked me to modify.I have data always like this or more yes =2 or NA = 2 or both of them 0 1.Totalyesscore =2 TotalNAscore=0 2.TotalYescore=0 TotalNAscore=2 3.TotalYesscore = 0 TotalNAscore = 0 I used IIF statement on report column to add and calculate %. Always...
  8. psaaccess

    get only names from table

    Hi dhookom, I used left() and instr() in query. It is not getting whole name. The field name is workername.
  9. psaaccess

    get only names from table

    My data is lastname firstname 1200-1500 and some of the records lastname and firstname only. I want to get only lastname and firstname without numbers Ex: 1record.abcd xyz 1200-1500 result is only: abcd xyz 2 record.abcd xyz Please help me.
  10. psaaccess

    Add two days for business days

    Hi, Patient request date is input field on the form. I wrote code on patient request date after update event. Any thoughts?
  11. psaaccess

    Add two days for business days

    pt request dt is user input field on the form.
  12. psaaccess

    Add two days for business days

    SkipVought, I submitted a question not for sharing purpose, Need a solution how to fix it. Please see below information that I submitted on this form. when I enter 07/02/2009 has to add 2 days including with 07/02/09 give out put date is 07/07/09. This excluded July 3rd holiday and saturday...
  13. psaaccess

    Add two days for business days

    TheAceMan1 and Harley, Thank you your reply I created the table and addedd the holidays. This is using for hospital. Every year this table need to update manually. Patient will submit his request and hopital authorities has to reply in 3days. So It has to add 2 days + patient request date...
  14. psaaccess

    Add two days for business days

    Hi all, On the form there is an input date field, after the update of the input field, the date field has to add days for that input date and give the next date excluding saturday,sunday's and holidays. example: The input date is 05/26/2009, it will display on the next field 05/28/2009. It...
  15. psaaccess

    count only weekdays and elminate holidays and weekends

    Hi MichaelRed, Can I put this function in input Date field after the update event or in the modules then can I call this function? please explain. Thank you,
See more

Part and Inventory Search

Back
Top