Search results

My Admissions table and Residents table is a 1 to Many relationship. I really can't make a subform because I have to much data on the form. No place to put the subform, which also contains a bunch of fields.

Hello All, I'm working on a database for a local youth shelter. I have a form where I enter the youths info (name, age, date of birth.stuff like that). This info will remain constant for the youth (except the age) That way if the youth end up back in the shelter they don't have to reenter this...

I guess I don't know. I created one form for entering the data whan the child is admitted. When the child is discharged they don't need the info from the admitted form. So I created 2 different forms.

Let me expalin in detail. I have tblAdmissions ADate Days Lot of other stuff tblDischarge DDate Lot of other stuff Other Tables Bunch of other stuff and I have a frmadmission. This is a tab form and each tab is basically from a different table. On one of the tabs I have the ADate and a...

What's wrong with this Private Sub DDate_Click() Me!DDate = Date End Sub I want it so that on click it enters todays date.

Does anyone have any suggestions on a GOOD, written in plain english (nonprgrammers language) reference book for access? Something that has sample codes, and explanations? YOU GUYS AND GALS ARE AWESOME!!! but not being of much access intelegence I feel guilty of asking 7000 basic and simple (to...

I tried putting in the control source of my field. I think part of my problem is that the [DDate] is in a different table/form then my [ADate]. I originally had it in the ON Click event. I knew that wasn't where I wanted it but I was trying it there to see if it would work. Since then I have...

This is what I have now IIf (IsNull(Forms![frmdischarge]![DDate])), DateDiff("d", [ADate], Date), DateDiff("d", [ADate], Forms![frmdischarge]![DDate]) but I keep getting errors can't find forms 'frmdischarge'. there is a frmdischarge and I've checked spelling several times. Any suggestion?

I get Compile error: Syntax error

I want to calculate the numbers of days from my [Date] field to todays date. BUT ONLY if there is no value in the [DDate] field. If there is a date in the [DDate] field then calculate the number of days between [Date] and [DDate] Thanks, Rick

Tay, I want to calculate the age of a person when he enters the shelter and I want to store that age. If the child is still in the shelter during his birthday I still want the admission form to reflect his age when he enterd the shelter not necessarily his current age.

I got the age to display the correct age. THANKS EVERYONE FOR YOUR HELP. But I noticed that it isn't saving the info it's just displaying it. How do I say after you calculate the age store those results here?

WOW!! OK Yes I guess there is the possiblilty of multiple cargivers but I don't think that really matters. I have a table (tblguardians) with in that there are several fields (examples.. FatherFirst (Fathers First Name), FatherAdd (Fathers Address), SMotherAdd (Step Mothers Address)...

Here is my scenario, I'm working on a database for a youth shelter. I have fields for Father, Mother, Step Father, and Step Mother. I also have a check box for each that would be checked for the primary caregiver. So if mom is the primary caregive I would check the box next to mom. Same thing...

Thanks David. I emailed you and sent along my 2 print screens

Dave here is what I did (see attachment print screens). Obviously I missed something. My attachments aren't going. Do you have an email address I can emails these to?

Thanks David I'll give it a try. I REALLY appreciate the thorough response I'm not an access expert and it's nice to get that little extra. Thanks again, Rick

I'm trying to calculate a persons age based on their birthdate. I did a search of this site and found several version on how to do this but I guess my question is where do I put the code? I want it so that I put in the birthdate in the bdate field and the age field is automatically calculated...

Private Sub Combo2_AfterUpdate() If Me.Category = "Vehicle" Then DoCmd.OpenForm "frmVehicle" ElseIf Me.Category = "Vehicle Parts" Then DoCmd.OpenForm "frmVehicle" Else DoCmd.OpenForm "frmEverything" End If End Sub If my category is either Vehicle or Vehicle parts then open...

I have a form with a Subform. On the form there is a drop down category field. I want the subform to change depending on the category that is picked. For instance on the form if you pick the category "Vehicle" then the "Vehicle SubForm" displays as the subform. If you pick "Electronics" then...