Recent content by godknow

Thanks this works ...

Any way to do this

Can you explain with an example ... I don't understand " You should be able to filter the underlying query

currently i have to open my report and export manually to save report as pdf. This is my code to open for specific user : DoCmd.OpenReport "myreport", acViewPreview, , "[User_ID] = " & Me.User_ID now I want to output my report to pdf automatically to a certain location. how do i filter with...

Thanks, this helped me ...

Thank you.

got it working

i want avoid it and send my value automatically to generate report based on userid.

i tried that, but still it is not working. DoCmd.OpenReport "USERReport", acViewPreview, , "[UserID] = " & Me.UserID Image one is Form Image two is Asking for parameter to show the report after click the button. Image three is the query that will be used by report. Plzz help me with this...

i am trying to put a button and clicking it will send the recordsource as parameter to the report. the report is generated using query which needs userid as parameter. please guide me through VBA code for it. here is what i have so far DoCmd.OpenReport " USERReport ", acViewPreview, , "...

thanks got it worked finally.

i didn't got that

OK got it. But i would be helpful to know if that person is completed the the task or not by looking at the completed check box. Is there any better way to know, if the person is completed or not?

so how would i write a query

Based on Multiple check boxes change the value of Main check box(completed) i have a table with fields Name | ID | Completed (true or false check box) | check box 1 | check box 2 | check Box 3 | now what i want to do is, if the check box 1,2,3 are true, change the value to true in completed...