Setting Up & Running Reports | Forum profile

You shouldn't have to relink unless the MDB files or tables change names or locations. -- Duane Hookom Microsoft Access MVP "AGOKP4" wrote: Thanks for your reply. In order to create this linkage, do I need to update each time I receive new data? "Duane Hookom" wrote: It isn't clear what you want to do with the 3 different databases or the reports. You can link to tables in all three MDBs from...

Pedro wrote: I've made a simple report but with just the objects on the footer section. 12 lines each one with 13 objects, like an anual report. So far so good. It shows me all the way i want. But i would like to add 8 lines more with another 13 objects per line. The weird thing is that, it adds my first page in blank. Completly in blank. Nothing. the 2nd page with the results and 3rd page also good. But there's a first page in...

If you need to open a database in exclusive mode. == If the database is open Close it, leave Access open. If nothing is open, then open Access (not your database application). == Select Open from the menu == In the dialog, find you database and single click on it == Click on the little down arrow on the side of the Open button and select Open Exclusive. This will open the database application in Exclusive mode, as long as no one else has it...

Try this -- =IIf(([CompletionDate] Is Null And [TargetDate]Date()) OR ([TargetDate][CompletionDate]),"Overdue","OK") -- Build a little, test a little. "echofuzz" wrote: Hi, all. I'm having issues with an IIF statement in an audit database report. I have a [TargetDate] and a [CompletionDate]. I need to be able to return "Overdue" if the there is no [CompletionDate]...

When I close my report, some of my code that controls the left margin for odd-even pages runs many times before the report actually exits - it's in some kind of loop but does eventually close. The code in my report is as follows: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page = 1 Then MoveMargin = 360 ElseIf Me.Page Mod 2 = 0 Then MoveMargin = -360 Else MoveMargin = 360 End If ChangeMargins End...

Thank you for the additional information. However, you may not find many people here willing to risk opening a file from someone with whom they are not familiar. Also, if this is a homework assignment, you may not find many people here willing to do your homework for you. What have you already tried? -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention...

Can anyone out there tell me if I can make the appearance of a footer conditional upon whether or not there is null data in a particular field? For example, a field in my table is called "Staff_Section." Some records contain a staff_section while others do not. For sections that do not have a staff_section identified, I do not want their numbers to be summed in the Staff_Section footer. For records that have a staff_section,...

Duane in my understanding report will take value from query and query will take value from table. So if we do not have a calculated field in query how can we link it. I also refer to your previous email Nov 13 saying 5 set of subreport. OK I will try again to make it only one subreport. But if you still have a rather easy one I appreciate. The problem because we have to choose in combo box the year of service, then it will show, for the last...

Cam wrote: I have a form with Multiple fields filter based on and event procedure where I can filter multiple combo fields. I would like to print a report after the filtered fields, but not sure how to like what is the control source etc.. Any help is appreciated. Here is my sample form filter event procedure. Private Sub cmdFilter_Click() Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.cboMach) Then strWhere = strWhere &...

Then it may be in driver issue. When you export a report, Access uses the printer driver metrics to calculate the layout (including the space required to display a text box.) Assuming you have set Can Grow to Yes for both the text box and the section of the report, a faulty printer driver could cause the space to grow inadequately. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -...