Search results

Yes, assuming you already have your line numbers control set up. Add the Page Break underneath your line item controls -- then in the OnFormat event of the section holding your controls and pagebreak, add the following. If Me.txtLineNums.Value = 15 Then Me.PageBreak.Visible = True...

You might also want to take a look at this login example: http://www.utteraccess.com/forum/index.php?showtopic=2023081

Open up the report and start to 'comment out' any event code, especially looking at any event code in OnFormat. Do it step by step, comment out a portion of code, then try Preview > Export > PDF -- keep doing that until the report is coming up blank or exports. I think eventually you'll come to...

I bought an earlier version about 8 years ago, it's useless. Just look at a couple of the current reviews http://www.amazon.com/Building-Accounting-Systems-Using-Access/dp/1111530998 In the past I've always enjoyed Alison Balters books, but they might be a bit out of date. Regards Melt

Hi burrina, Sorry, that is not what I'm looking for. I'm looking for a generic word/pdf doc that outlines the support details of a Access database support contract. All the legaleze stuff. Regards Melt

Hi all, Does anyone have a basic database support contract document/template that they would care to share please, or any links to one? Thanks Melt

Thanks a lot JHB -- nice piece of work! Regards Melt

Thanks for the replies. JHB, that won't work as I need the ServiceType Ascending, which will still leave the Add/Edit value at the top of the list. Regards Melt

In a query I'm trying to return a list of rows sorted by ServiceType Ascending and then the last item in the list should be a row called "Add Edit Value" (see screenshot). If I 'ORDER BY 2' then the "Add/Edit" row appears at the top which is not what i want. My SQL: SELECT '' As ServiceTypeID...

I don't know of any way to know what page a sub-total or total might be printed on -- as a workaround, I'd suggest allowing your users to decide if a value or group should be printed, after they've previewed the report. Beside your report button place a checkbox that the user can click to hide...

Hi, If it's just a couple of small bitmaps then it's better to embed those as OLE objects, than write your if statement in the OnFormat event of the Detail Section of the report. If you need to use a lot of photos, then it's better linking externally to those -- attached is a small demo for...

This post should help: http://www.access-programmers.co.uk/forums/showthread.php?t=223130

Michael, I think you might need to use a 'stringbuilder' function to create the data and get it to stay formatted. Here's a function I use to create and format addresses on my reports: Public Function acbMakeLine(varValue As Variant) On Error GoTo Error_Handler If IsNull(varValue) Then...

I don't have any sample databases, but, attached is a screenshot of one form I have in my db that allows users to set some options before they view a report... it might give you a few ideas. A 'date-range' picker is very useful for users, instead of having them enter dates manually for...

You've probably got this sorted already Rob, but heres some code that I use. The user clicks a command button on the form and the following code open up a report, set the recordsource, saves it, then opens the report. Regards Melt On Error GoTo Err_cmdOrdersReport_Click Dim stDocName As...

Hi all, Usually when you set a default value in a form, the user can remove the value and leave the textbox blank if they want. However, in Access 2010 when my user removes the defaults value and clicks into another textbox, Access 2010 puts the dafault value back into textbox, which is...

My last question on this forum was answered by David, my condolences to David's family. Regards Melt

Thanks DCrake, got it sorted now.:)

Hi all, How do i create a variable that will be visible to all Forms after it is created? At the top of my module I have: 'globalvarable to hold the line-item count for each section on the order form Global varHardware, varSupport, varEng As Integer My function is: Public Sub...

Hi vbaInet, No, not suppress the page header if the sub has data, suppress the page header on the page that has the sub-data, only. Using .HasData method turns the page header off for all the pages, which is not what I want. Thanks for the reply Regards Melt