I am the secretary of an athletics club and have the task of using membership data to compile groups of athletes.:eek:
One of the fields that I have available is the date of birth of every athlete. It is entered in the form dd/mm/yyyy.
I would like to be able to query the database and display the age of each athlete.
I would also like to be able to query the database so that I can compile groups of athletes grouped by their ages as at 01/09/yyyy
These groups would be: Under 11 years,
over 10 years but under 13 years,
over 12 years but under 15 years,
over 14 years but under 17 years under 20 years.
over 19 years.
I have some understanding of using SQL view in Access but my overall knowledge must be viewed as "novice".
If you are able to help me with this problem I would be extremely grateful (as would our club), and I would also be obliged if you could keep instructions simple.
Many thanks
John:)
I've a club database the records score for juniors on age groups that are set as of the 1st January each year. I would like to set this automatically from the date of birth. I have found some code that is very close to what I need apart from the fact it groups on the exact DOB resulting in changes to age group mid year.
'----------------------------Code Start-------------------------------- Public Function AgeGroup(dtmBirthDate As Date) As String Dim intAge As Integer 'Age Calculation intAge = DateDiff("yyyy", [dtmBirthDate], Now()) + _ Int(Format(Now(), "yyyy") < Format([dtmBirthDate], "yyyy")) Select Case intAge
I create a database through ms access and there have a birth date box and admission date. Another box for Age.I want to see the age in month or year figure in to the age box when I go next field. Which will be calculate from admission date to birth date.
I need to set a field so that only people that are 16 years old from the current date can enter their birthday into the field. I am assuming that it is a 365-day year. I know that i need to use the DATE() function and the number 5840 (16*365). I can't figure this one out, HELP PLEASE!
I have a "Client" table which has a "Date of Birth" field and the problem I am having is on in the data entry form the users type in "2/25" instead of "2/25/1965" on for the most part that's OK. But if the client DOB is 1930 or before then 2/25/2029 comes up. I have found that the date format is tied to the Windows Regional settings and we are working on a network that doesn't allow me to adjust the settings. I have tried to put a validation on the table for the field but then that makes it so you HAVE to enter something and can not leave that field blank if you want.
Hi i know it is simple but can someone tell me how to work out an age of someone using their date of birth and the date now please. thanks i cannot remember the formula.
This is my first post to this group. I am building a database for a charity event and need to calculate the age of a person based on the Date Of Birth field in the table and add that number to a separate column in the table. Also, need to calculate the age as of a certain date (the beginning of the event). Thank you for any help.
I am a novice trying to create a school access 2000 database, I have a table that contains a DateOfBirth field and want to convert this field into Age (automatically add a new field), so i can then create a form from it and filter the pupils by age.
Ive read post http://forums.aspfree.com/showthread.php?p=112241 which is exactly what I want to do, but it doesnt go into the basic s, like where I put this code to get the field to change.
I have a Date of Birth field in format DD/MM/YYYY and wish to set up 2 new fields one that calculates Age in Years and another that calculates Age in Months.
I have this code for calculating the age from birthdate but i want if there is years no months or days appear
Public Function CalcAge(Birthdate As Date) As String Dim intYears As Integer, intMonths As Integer, intDays As Integer intMonths = DateDiff("m", Birthdate, Date) intDays = DateDiff("d", DateAdd("m", intMonths, Birthdate), Date)
I have a [DOB] field with birth dates. I have another field [DOBExp] where I want to automatically calculate at date 15 days out, but exclude weekends and holidays. I have a separate table listing the holidays.
Would like a formula to use in my first table for this. Have no clue how to do this.
I don't seem to find any query formula in the forum where the age changes on the date of birth. I tried all the once I could find but all of them seem to calculate the age as of 1 January. I find it a bit strange that it doesn't work.
I got BirthDate and Date in the table I want to update the age column back in the history with an update query.
I have a table that imports data - including date of birth. the format is dd.mm.yyyy - the db keeps throwing up the error - Birthdate must be 8 digits. The only validation I have for the field is "<date()" to ensure that a future date is not entered.
I am creating a database with over 500 entries. One thing that would speed up the process of entering all of this data manually would be if I could type in the birth date and the age would be automatically calculated. Is there any way this can be done? It is all in the same table.
I have just started using Access 2010. I need to calculate student's ages from their date of birth to today's date. I have a column set up for the date of birth but can't figure out how to get this figure.
I get the following error when trying to compile code int an MDE: This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc). There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
There are only about 10 linked tables to SQL server, a decent amount of code but nothing that bad in the Access FE. Any ideas on how to solve this? As I understand it, the code will run faster when compiled?
I just recieved a access project from a client, apparantly it works fine on their machine. I FTPed it to my machine. Both are winXP.
Most of the app works fine except when I try to bring up one form. I get this error.
Compile Error Can't find Project or Library.
This is written in access 2000 and that is what I am running it on. I've checked windows update, my computer is up to date. That includes Office update.
I tried running this on a second box that I have, a win2000 server I get the same error.
It apprears something is not getting transfered, any Ideas?????
I tried to declare a variable to be type Database and when I compile the program it gives me an error Compile error "Use Defined type not defined" this is the code that I have written:
Public Sub NewX()
Dim mydb As database ******** here is were is giving me the error, I tried to declare this on several places but it does the same error********** Dim myrecord As Recordset
Set mydb = CurrentDb Set myrecord = mydb.openrecordset("log", dbopendynaset)
the rest of the code continues....... End Sub
Any help will be appreciated, I am trying to save the information on the database by clicking a coomand button .
I used "Option Explicit" at the beginning of a module. When I compiled the code, I received a Compile error that indicated the Set dbs = CurrentDb is not defined.
My Access 2000, created the dummy's way, has been perfectly happy with its query expressions. But when I create a module calling up these queries, I get Compile Error on many perfectly legal expressions such as Left([pfn],1). I've tried repairng the database but to no avail. What is going on, please?
Btw, DBicken, it's when I include your text concantenation code (Posting 6/21/06: "A whole lotta text/stitching") but I don't think it's your fault: it's just exposing it. I can't try your suggestion until I solve this problem.
hello to the experts is there any way or method to compile an access .mdb file to .exe and don't be the need to open it with the access programm? (eg. to a computer wirh no access installed)
All of a sudden none of my queries work properly- all the criteria and calcs i had in them have been deleted?! Basic codes do not work any more e.g >now() ;between 1 and 30 etc If i try and write a new query using the same expressions and code they just don't like it - YET they were working yesterday - very strange Can anyone help??
Does anyone happen to know to compile the different results obtained by passing a query a series of parameters?Say i have a query that returns the total work hours for an employee for a month, and the employee's name is passed to that query as a parameter.And i want to compile the data for all the employees (in a report or query) where the list of employee names to be passed are stored in another query.Just using Access 2000 with some VBA.Thanks for any help :)
