Recent content by ray705

That is basically what I have done before. I was hoping there was a better solution.

I have posted an example of the report in the first post. The second section of 'code' is the report.

Apparently Access uses a different process when updating multiple records than when it is working with a single record. With multiple records it probably uses a transaction type update. We may wish it otherwise, but it does make sense that they would suppress custom code when updating multiple...

Yes, the file is .txt format. No, the file is multiple pages. The current file I have is 17 pages.

Every couple of years I have a project that makes me wish I was back on a mainframe. I long for the days of COBOL and the ability to redefine a record in any number of ways. For those who only know PC programming here is what I want to be able to do. In COBOL, you could tell the compiler to...

Take a look at the attached and see if it is what you need.

I don’t remember where I found this, Microsoft site I think. Option Compare Database Option Explicit Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String lpTitle As String dwX As Long dwY As Long dwXSize As Long...

If that's not vba then what is it?

Sounds like maybe you need some sub-reports within your main report.

I think what you want is the KeepTogether property of the Detail section set to True.

This is what I had in mind… Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) If Me![HoursWorkedSubReport].Report.HasData = False Then Me![lblNonH].Visible = False Else Me![lblNonH].Visible = True End If Exit Sub End Sub

Try something along this line: This is for OtherValue numeric. DoCmd.OpenReport "rapPersonMedAllt", acViewNormal, , "PID=" & PID & " AND anotherField = " & OtherValue This is for OtherValue alpha. DoCmd.OpenReport "rapPersonMedAllt", acViewNormal, , "PID=" & PID & " AND anotherField = '" &...

Here's a 97 version.

Look at the attached report layout. The detail section has the Visible property set to no to suppress your detail records. Look at the Control Source of the fields in the Report Footer to see how to calculate your totals.

What Ken is trying to say is don't use three fields when all you need is one. Put the code in the OnFormat event and concatenate your static text with your variable field data into an unbound field - or even in the Caption of a label type field.