Search results for query: *

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

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

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?

Hi PHV, What is /2?

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.

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

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

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

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.

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

pt request dt is user input field on the form.

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

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

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

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,

Hello Michaelred and dhokoom, Thanks for the reply I am new to the access 2000 and I tried the FAQ181-261: To Calculate the working days between two dates but I am getting the "compile error argument not optional" First I need to explain that on the form there is an input date field, after the...

Hi All, Need some help to count work days only and elminate weekends and holidays. Date is input field. Thanks,

I'm trying to get code or setting on the cursor stay original position. Each time when I update a record into my form, I need to run a Requery . But after the Requery runs, the record has goes to the first record of the sub form and I need to search for the record to continue. Are there...