Recent content by crododo

Hi, I have this code: If Me.OpenArgs = "frmAddChecklist" Then Set ctlCombo = Forms!frmAddChecklist!cbDEPARTMENT ctlCombo.Requery End if And this code is done after I added new value to table, and now I want that new value to be used as default one, how can this be done...

Hi, I have this code that should change backgroundcolor in multiple items form based on a value of a field: Private Sub Form_Current() 'check if field on form called somefield is DVD If Me.TYPE.Value = "DVD" Then Detail.BackColor = vbRed 'DVD Else...

Dear Namlian, This is exactly what I need. Thanks, sometimes I get supprised how stupid things makes so much probblem ;) Thanks

Hi. I have this formula for counting age groups TOTAL 29 - 31: Count(IIf(DateDiff("yyyy";[DATE_OF_BIRTH];Date())>=29<=31;1)) But id does not work, if I use between 29 and 31 also do not work I need to get count (number) of all students that have 29,30 and 31 year of age, any idea where I am...

Hi, I am trying to find it for past few hours, but no luck so far ;( Any idea where I can find it? Thx

Hi, I have one table that has fields: [ID] [STUDENT_NAME] [BIRTH_DATE] [GENDER] and I neet to get in qry where students will be counted by age and gender For example: younger then 15 tolal: 20 male: 5 female: 15 15-18 years tolal: 34 male: 12 female: 22 Can this be done in single queri or...

Hi, I do knot understan where dio I put like? Thx

Hi, I have one table in my access, and out of that I need to show a queri that will show only following resoult in 2 comolms ID (same as original table) SCHOOL_YEAR (all the students that are: 1 year and 1 year (repeat) as 1 year 2 year and 1 year (repeat) as 2 year 3 year and 1 year (repeat)...

Hi, Thanks for anwesr When I manualy enter date as #08/13/2013# it filters OK, but when I use inbuild calendar I get and error. How do I format resoult from calendar to be displaed as data mm/dd/yyyy but also a question How can I know in my table is date stored as dd/mm/yyyy od mm/dd/yyyy...

Hi, It there is one thing I have in programing it is date conversions... I have this line of code: If Not filterDate.Value = vbNull Then strCounter = strCounter + 1 If strCounter > 1 Then strChosen = strChosen & "AND " strChosen = strChosen &...

This is exactly what I need, thanks a lot!

Hi, Thanks for your anwser, my mistake I did not explain in more details. Table tblSchoolWorkingDays has two field one is [DATE] and another is [ID], this [ID] is autoincrecement number and after I add new [DATE] in this table I need to store value of this new [ID] number in a sting so I can...

Hi, I have this code in Access VBA and it is not working, I hope somebody can give me some help on this: Private Sub btnAddWorkingday_Click() Dim strSQL As String Dim strDate As Integer Dim lastID As Integer strSQL = "INSERT INTO tblSchoolWorkingDays (CALENDAR_DATE) VALUES...

Hi, I would like to print first label on paper in position example(1row, 2 colom) or (4row, 3colom) before he starts to make report I want it to say where the report should start, records are always the same and let say racord has value "BLACK-CAR" and that vak+lue should always be printed, the...

Hi, I am currently volontering in Uganda and labels are very expencive here so if I use for example first two rows and 1sticker in 3th row I would like to tell to report to start printing from 3th row second colom Any idea?