Recent content by stallams

Hi! This is my code and I am trying to write a report from the temporary file 'rsTempMem' I created. Please help me with the code. Option Compare Database Private Sub Display_Click() On Error GoTo Err_Display_Click Dim rst1 As ADODB.Recordset Dim rstTempMem As ADODB.Recordset Dim cn1 As...

Hi! So how can I send the selected information to the report. Thanks, Esti

Hi! Can I send a complete select to openreport DoCmd.OpenReport , "RepSubject", acPreview,, Select * from rstTempMem Thanks, Esti

Hi! I think I got the VB code correct by building a temporary file, but how do I send this temporary file to my report. (I bolded out where my problem is) Here's the code: Private Sub Display_Click() On Error GoTo Err_Display_Click Dim rst1 As ADODB.Recordset Dim rstTempMem As ADODB.Recordset...

Hi! I think I got the VB code correct by building a temporary file, but how do I send this temporary file to my report. (I bolded out where my problem is) Here's the code: Private Sub Display_Click() On Error GoTo Err_Display_Click Dim rst1 As ADODB.Recordset Dim rstTempMem As...

Thanks, I try

No I mean one report with all the records of the array Thanks, ST

HI! I am trying to set an array with certain database records and then print a report of those records. Do you know a different way I could do it. Thanks, ST

Hi! I am trying thru a while loop in a vb program behind the access report. I have a form where I enter txtSubject. I want to search for all the subjects in the database that have in them the txtSubject and then print them in a report. I am having a problem sending the string to the open...