Recent content by manf01

strDocName = "InvoiceReport" DoCmd.OpenReport strDocName,acViewNormal, "Invoices Filter" I have used the above function, now i am getting the required print out of recent record

Thanks Remou i have corrected it but still in vain Can you please have a look on the code ? Private Sub Print_Click() On Error GoTo Err_Print_Click DoCmd.OpenReport "InvoiceReport", acViewPreview, , _ "[InvoiceID]=Forms!InvoiceForm!InvoiceID" Exit_Print_Click: Exit Sub...

In taking a print out of recent record on the Form i have used a bit different way but i am getting an error in it. DoCmd.OpenReport "InvoiceReport", asViewPreview "[InvoiceID]=Forms!InvoiceForm!InvoiceID" Anyone can correct me ? Thanks a lot.

Thanks a lot Zameer, Its working properly

Hi programmers, i have tried to use the provided code to get the print of the recent record on the form but i am just getting the copies of all records, Can anyone suggest me how to get print of recent record. I will be thankful to you Dim stDocName As String Dim strWhere As String...

Thanks a lot PHV.

Hi Harleyquinn, It did helped me, Thanks a lot. I want to get the whole Total as well. Is it possible ? Thanks,

Thanks PHV, I dont know why, but i am just getting an empty table, Same code is given as under: Can you please check it ? It will be a great help. SELECT Calculation.Project_Nr, Sum(IIf(Month([Date])=1,Charges,0)) AS Jan, Sum(IIf(Month([Date])=2,Charges,0)) AS Feb...

Hi All, I need a help here, it looks easier but i got stuck here. For example i have a table(actually its a large data table) with project numbers between 10 and 14 which were entered on different dates with different Amount of Charges. ID Project_Nr Charges Date 1 10 130,00 01.01.2005...

Thanks a lot Zameer, It was a great help. Now i will try to work on it to send the present recod for print a report.

This is code of both functions but i have a problem with second function Private Sub cboProjectNr_AfterUpdate() On Error Resume Next Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String cboProjectNr.SetFocus If cboAPNummer.Value > 0 Then strSQL =...

First code is working properly, for the second code i have a Problem. Should i create a new table my self ? i have created one with same Fields as in my main table on the form but i am getting Just ID number in my new table not the other field values. Any Idea ? Thanks

Thanks a lot ZmrAbdulla, I have just checked your reply, i will try it and will let you know.

Hi All, This is my second post here, you helpers are doing a great job. We appreciate it. Thanks a lot. I got a problem related to the forms now. I need to print a report, I this case I have for example 2 tables( mainform and subform), one is self created and other one is a linked table(linked...

Hi Crowley, Sorry for late reply because I was not in the office. I have tried it and its working. In my case I have added the desired fields in ( about the primary key it exists which is on Package Number ) INSERT INTO NewTable( fields name, ….,…..,……,) SELECT fields name,……,……..,………. And...