Search results

thank you very much! you guys are really helpful

hello everyone I have two sheets: 1st sheet: includes the registered students (with their IDs and regions) from both first and second grade. 2nd sheet: includes list of all excellent students’ IDs who are at first grade. what do you think what is the formula that can I use to show me how...

it works (: THANK YOU VERY MUCH Appreciate all your help REALLY!!

just amazing!!! Thank you very very much I want to know HOW. did you use a code?! and is it possible to enter the ID number manually instead of double click coz I have a database with over 50,000 records

and what should I name the botton

thank you very much I will try another code as in attachment but what should I put in wherecondition and openargs

it means the first one: the name of the field which is (ID) the second one the name of the report which is (Class_A) Private Sub to_print_Click() Dim strDocName As String Dim strWhere As String strDocName = "rptSomeReport" strWhere = "[ID]=" & Me!Class_A DoCmd.OpenReport strDocName...

ya there is an error 2465 (cant find the field RunID) RunID is a number

Now I am opening the report - design view - Botton - (right click) properties - name : I write the name of the report - caption: I write the name of the command - from event- on click: [Event Procedure] then I press the botton next to it past this Dim strDocName As String Dim strWhere As...

Could you please explain how to do it using reports??

Thank you very much but is there another way. I couldn't get it

Hello everyone I have created a report but I want it to be filtered based on the primary key. So I can print single page with data that belongs to single primary key. Thank you and appreciate your help.

thank you I will try to convert it to report

hello I have created forms and now I want to print it. But I want to print it as a single form. I dont want all the forms to be printed. I only want to select a primary key then print the form that belongs to that primary key. I enter this code Dim strWhere As String If Me.Dirty...