Search results

Actually, whilst I appreciate your offer of help, that didn't work anyway, as the right-hand sides of the pages are not printing in your version, so it's cutting off the pages. I think Access should tell people where the margins REALLY are, not some imaginary half-arsed 'margin' that doesn't...

Thanks for trying for me! You do seem to have got rid of the surplus right-hand margins, how did you do that? It still prints on far too many pages (14 when completed), I'm starting to wonder if my basic design is flawed. Perhaps I need to break it up into sections or something.

Thanks for those tips, I appreciate the ideas, but they aren't the key problem. The central problem is that some pages are being printed that just show a thin sliver of right hand margin. This appears to be because it thinks that some pages have elements overflowing the right margin, yet when...

Looking at it some more, it's almost as if there's an invisible 'something' in the report that's causing print preview to display bits of the right hand margin on new, mainly blank pages. Nothing seems to change it doing that. Bizarre.

How would I utilise it to reduce the number of pages please? I don't know how to reduce the subreport sizes, they contain a lot of information.

The report called "DraftCJP" in the attached database prints out on loads of pages, many blank, even though in Design View it looks like it is within the margins and it is in Landscape mode. In Print Preview without data it comes to 8 pages, when it should be 2 or 3. I've tried various things...

Oh gosh, how bloomin' obvious. :banghead: Thanks so much! :D

Trying to upload the DB as a zip. Please see attached.

I've tried all kinds of things now. The target form opens from the same query but no matter what I try, I can't get the form to open on the same query as the report row. Sigh. The DB is too big to attach - can I just upload forms, queries and tables somehow? EDIT: See next post - I've uploaded...

Interestingly, this kind of works, but only loads the form with the row number as the ItemID, not the actual ItemID. Public Function GetItemID(Loc) Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("qryCAFAReportList") If rst.RecordCount = 0 Then GetItemID = 0 Else With rst...

You mention a 'where' condition - is there some more code in your solution that determines what row it sits in?

By "RONum" there, do you mean a specific rowcount property in the report? My equivalent is DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID and that doesn't work, ItemID is the autonumber field and appears in the recordset, but the View buttons down the page only load the ItemID from...

Yes, it's in Report mode. I think the problem seems to be that the ItemID is not based on the rowcount, it just loads the first one from the recordset. It sounds like I need some code for the button that does something like this: For the current row... Load the ItemID based on that row in the...

I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row. I tried the VBA code like this on the View button on click method...

Hi, I have a report called JobPlans which loads from a query. That query contains a column JobID from a table about jobs. (JobDetails) Inside that report I want to display a list box, with its rowsource as a different query. I'm trying to display items linked to jobs. There's a join table for...

I have a form that I want to open on a new record (with an Autonumber-based ID string that is a calculated field) and this uses a hidden field in the form when it opens to spawn a new record, ready to be related to some additional items in a join table. The user selects those from a list box. I...

Afternoon all. :) I have a list box (List25) that is generated from a query (qryThisBox). One of the fields in that query uses the criteria [Forms]![MyForm]![SelectedField] to filter. I also have combo boxes in the form that List25 displays in. Unfortunately, I want to requery the list box in...

Ahh, all very interesting indeed, thanks a lot! I didn't realise for example that simply closing the form saves the record. Is there a property that stops that happening? I am interested in what you said about regular Access users expecting not to have to click a 'save' button. I am dealing...

Yes, I've begun to realise that. Out of interest, what's the reason for using Form's beforeupdate rather than OnClick please? I'm using this kind of code now, which seems to work well, but it made me wonder what was wrong with On Click. Private Sub SaveAdd_Click() Dim txtMessage As String '...

Hi, just a quick additional question about the syntax. I tried using Return false in the function as in your example. That throws an error. So I tried Validation = False as the last line in the function. That works, but it doesn't trap the error state properly, it continues to throw a False even...