Replies

You are correct, but there are some other things being done when they are entered into the class which is why I did it this way, I might have to change it to main subform, depending which issue is more significant to the person doing data entry.
Thanks

It is pretty primitive but t works.

On Error GoTo Err_Command2_Click

Dim stDocName As String
Dim x As Integer
x = 1
stDocName = “repStudentInfo”
DoCmd.OpenReport stDocName, acPreview
Do Until x = 20
DoCmd.PrintOut acPages, x, x
x = x + 1
Loop
Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

The form opens in data entry so it does not show the existing records. When I enter a student in the form, the after update code pulls the class from the unbound combo box and enters the class in the underlying table. I want to get to a data entry form each time I choose a different class in the unbound combo box

I have two databases with large amounts of pictures one in 2003 and one in 2007. The one in 2007 works perfectly fine. The 2003 one I had the same problem as you, so I set the printout of the report to print in sequence each page, opening and closing the report between each page and that solved the problem.

thanks. Will try to figure out whay that is true when I can think

Sorry her it is as an mdb

I had tried that and I get no records even though the two parts of the query work. Still no records. attached is the back end zipped if that helps
Thanks

I had tried that and it would not work. I get an error 2448 “you cannot assign a value to this object”. The error is on “rpt.Recordset = rst”

What am I missing?

This is the code I wrote:

Private Sub Command35_Click()
Dim rst As Recordset
Dim rpt As Report
Set rst = Me.RecordsetClone
DoCmd.OpenReport “report1”, acViewDesign
Set rpt = Screen.ActiveReport
rpt.Recordset = rst
DoCmd.OpenReport “report1”, acViewPreview
End Sub

If the form is still open, is there a way to save the recordset of that moment into a variable that could serve as the recordset of a report that I would open in design view from a command button on the form, before I close the form?

Thanks. I know I can use that, but it is a form that is data entry and then I want to print a report of just the records entered at that session. So it is not a matter of filtering, but choosing somehow those records that were now entered. I could keep a list of the recordID as they are entered and then filter the report on those ID #’s but that seems a bit of a kludge unless there is no other way.
If you have any other ideas, I would be grateful (and not dead )

I’ve been through them andwas hoping someone had made life easier for me. Guess I will jut have to work hard

As far as I can see-the really hard work- writing code or macros for custom buttons it does not do. All it does is allow you to move around the existing MS buttons and even create new groups but only based on those.

Thanks to both of you

Thanks. I tried all the options aside from changing to BMP on the fly since I was not sure how he was doing it, but none helped. I think I will just use irfanview to knock down the images to a managable size and then it works.
Thanks

I tried an expirement and used smaller images and it worked fine. Does anyone know the formula for how many images multiplie by what size goes overboard? Does it depend on my RAM nd computer?
Thanks