Search results

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...

hi better you may attach the db and give you exact requirement to help you

Hi, better insert to text fields as date and add a button in form. make a query, and in the criteira, refer this fields like ">=[forms]![form1].[txtdt1] And <=[forms]![form1].[txtdt2]" where txtdt1 and txtdt2 are the textfields name and open the report using command button enjoy

hi, why dont you send db with specimen date for analysis and rectification. normaly there should not be any prob or data selection may a problem. pls verify.

hi, Structre of your tables and linking is not clear from your statement. i would suggest you to send the same of db itself for a clear solution

hi, may be you can found with a datediff function whether he is more than 90 days from date of joining and total number of days from date of joining and filter as per your requirement