Search results

Greetings, I have a main form called HouseHold and a subform called Applicants. In my subform (Applicants) I have a field called AppType with drop down PREGNANT, CHILD, POST PARTUM. And another field in (Applicants) subform called AppStatus, with drop down NEW, DSS, REDETERM. I’m using...

Hi, I’m trying to design a report to look like the attached word document. The difficulty I’m facing is: 1. How to calculate the percentage (%) and Average # of days 2. How to get a total of all applicants (Children, Male, Female) each month? (All Applicants in Jan, All Applicants in Feb, etc...

Hello, I have a crosstab query based report, which I would like it to be similar to the attached word document. 1. Is it possible to make every other row to shade in a report (like the attached word document ) in Access 2000? 2. How do you add graph/chart or percent based on the result of...

Greetings, I have a main form called HouseHold and a subform called Applicants. For every HouseHold there can be more than one applicant (one-to-many relation). I’m trying to force users to first enter HouseHold information before they enter applicant’s info. If they try, then a Message...

Calculations Pat , Thanks for your reply, In the main form I choose text box from the toolbox and right click on the unbound object, properties, Data tab, type in DCount () in the control source. I got #Name? error. Just to clarify, NumOfApp field is in my main form (HouseHold) and records I...

Greetings, I have a field called NumOfApp in the main form and will be automatically field in, depending on how many applicants there are in the subform. I had 3 records in the subform and it was working fine, until I went to the table and deleted one record, compact and repaired it, but NumOf...

Greetings, I was trying to design a query based report to indicate the member of applicants whose case are denied each month and what % are denied within 10 business days, average # of days etc. How do I go about designing the crosstab query? Thanks, Dan

Greetings, I have two combo boxes AppStatus (with drop down NEW, REDETERM etc) & EligStatus (with drop down ELIG, DENIED etc) depending on what the user selects from each field, EligDays = the difference between two fields. I'm new for programming. How do I get the result, (work days) not...

Greetings, I posted this before, and left out some information. I’m using Access 2000 and my questions: 1. I have a main form called Household and a subform called Applicants. In the main form I have a field called NumOfApp. I would like NumOfApp to be automatically filled depending on...

Greetings, 1. I have a main form called Household and a subform called Applicants. In the main form I have NumOfApp field, where I would like to automatically be filled depending on how many people applied in the Applicants form. 2. Also, I have DateReceived and DateDue fields in the...

Greetings, I have the following fields: AppStatus (with combo boxes New, Redeterm etc.), DateRecieved and DateDue. If New is selected from AppStatus drop down, I want DateDue field to be automatically 10 business days from the date application was received (DateDue= AppRecieved + 9). Can...

I have a field CovType with combo boxes PO1, PO2…P14. I like to design a report to indicate the total number of PO1, PO2, PO3….for each month (Jan. Feb. Mar. etc.) and the total count for the whole year. How can this be accomplished and do I need to design a query first. Thanks,

I have a field called AppStatus with a combo box (NEW, REDET etc.) and another field name EligStatus with dropdown (ELIG, DENIED, REACT etc.) Calculations for EligDays: If NEW from AppStatus and ELIG from EligStatus is selected, then EligDays = AppRec – EligDate If NEW from AppStatus and...

Hi, I have a field called AppStatus with combo boxes (NEW, DSS, REDET etc.) field called EAPP with a data type Y/N. The only time EAPP checked yes is when the user select NEW or REDET. How can this be accomplished and where exactly? Thanks, DD

I have an eligibility tracker database designed in access 2000. The employees have to process the applications within 10 business days. 1. How do you determine business days, weekends and holidays? 2. If I have the following fields: AppStatus, EligDay, EligDate, AppReceived, Reassess etc...

Hi, I have created a Data Access Page in access 2000, did some test and works fine. However, when I send a link to myself or others to open it, it opens somewhere in the body of the page and you have to scroll up to the top of the page (heading) to start filling out the survey. Is there a way...

Hello, I have access database that I'm ready to deploy. It is anonymous "Diversity Survey" database. Using our intranet we were thinking to send the employees e-mail with a link/short cut when they click, will take them directly to the survey database anonymously. I'm not familiar with ASP...