Recent content by rammudali

Thank you,

Dear Friends I have a small issue and i dont know how to solve the same the issue is i am updating data from a cross tabquery and it works fine but if i selecte the records based on the dates (here Tdate) it is giving runtime error 3061, Too few parameters. expected 0. the code is as...

Dear Jdraw, Thanks for your reply. please note that I want to insert the worked hrs and allowance to a different table itself which is independent. i tried all ways i know but logic working but date increment is not working properly I would requst you to correct the code which will be a...

I am developing a time sheet module for a construction proj. date increment after first loop in "Do While nstdt <= nenddt " statement is not working properly and date comparison in "select case" statement is not working properly. And also is there any better method to make a time sheet...

put the criteria in query as you require form list / combobox . Then you may execute docmd in click event of command button

Hi better upload the db for the correct solution

hi, if we opening mdb in access2007 or 2010 or importing all tables, queries, reports, forms etc to 2007 or 2010 relationship is visible, from my experience. without seeing the refered the db, it is not right to comment any more and i am not an expert to that extent

hi I think so. if this is woking, you use the new one as master and other as backup

hi, click the combo/listbox then property then event tab then select event procedure on after update for opening code window. between "private sub...........end sub" put the code docmd.openreport"reportname". in the query you have to put "[Forms]![formname].[listboxname]" in criteria of...

hi you may use grouping. in this case name

hi try by making can shrink property in header/detail/footer to yes only. need not to use hasdata property

hi try to create once again. but dont forgot to do the same in a copy of orginal

hi use select case in after update property case issued 1 me.date.visible = true ete case issued 2 ur condition case issue 3 ur condition end select enjoy

hi, you can execute the docmd.openreport("reportname") on afterupdate property of the combo/listbox by refering this value in the criteria of field in the query

hi doj is date of joining, date is current date. in the query try datediff("d",[doj],[date]) and in the criteria <=270 will give you records of probation period + 6 months. further if you want to filter employees who have cleared probation with >=90 and <= 270 etc. and under probation with...