Search results

Having slept on it I think dbguy is right in saying it’s going to be non-updateable. The sub query that returns a sum will prevent any field from being updateable. Not sure how I will deal with it but let’s say I drop that requirement. What I want to do sounds straightforward: For each...

Query and Sub Query Help Please Trying to get an updateable query working which draws totals from a sub query. I can't get the totals from qrysub_QtyDelivered into the main query Here's a screenshot of the sub query result set and the main query result with the missing result SELECT...

Thanks all, I think on balance I will leave the duplicated code in rather than tinker with it. I just put a note in the code to say, don't forget to update the sister code in the other module (you guessed I kept forgetting) MajP's code is bookmarked for future reference.

On my invoice/order form I have a sub form with a function ViewTransaction to open a pop-up form for that datasheet line. On the double-click event of every field in the datasheet I have: =ViewTransaction So double-clicking anywhere on the line opens the pop-up. On the host form I also have...

I'm not sure if you can get a total to display on your form when it shows many records from Actions. Consider designing a new main form for Actions which opens only a single record from the table. On this form you add controls (text fields) for the fields from Actions Table that you want to...

Have done some more research on the scrolling issue. I think the window can be scrolled using the Windows API which isn't something I want to build in to my application. The condition that I can't resolve is the one where the user has scrolled the last record of a recordset up to about half...

Thanks for the offer Vlad but uploading the db isn't something I want to do yet. zeroaccess, your suggestion is an option I'll be looking at. For the moment I have other things I must do so I'll have to put this on the 'needs attention' shelf. It's functional and usable(-ish) so that will...

PS just tested by doing the user edit and closing the pop-up form, then clicking Refresh on the ribbon and it too sends the datasheet scrolling.

Thanks Vlad. Two things happen: I put a msgbox to pause after the ctlMatchDsheet.SourceObject = "sfrmPaymentMatchDsheet". I get #Name? on all fields Then I get run time error 7951 on the next line, Set rs = ctlMatchDsheet.Form.RecordsetClone. Don't understand why. Let's just revist what I...

Just tested something. Deleted ALL records from table b and table c. Added a value in to the Match/Pay window, which causes a record to be inserted into table c. Did the me.refresh (on main form) I can see, briefly, the value that I keyed. Refreshing the main form seems to requery the sub form.

You *could* be right. It's my understanding that a refresh will show values that have changed in *existing* records. I don't need a requery for that, do I ? However this is complicated by the fact that the SQL datasource for this datasheet is on 3 tables, so a single datasheet line comprises...

Still haven't solved this but I think I'm getting close ... the issue was never about navigating back to the record but the fact that the datasheet was being refreshed like a requery and the record of interest was changing it's position within the sub form datasheet window. I think I need to be...

Yes I have. It doesn't stop the datasheet from scrolling, though. I want the edited record to remain in the position. Is there a way to say, navigate back to record x and position it 2 lines from the top of the datasheet window, I wonder. Either that or somehow prevent the requery. I have...

Still working on this. Here's my code wait msgbox: 'ctlMatchDsheet.Form.Refresh ' Does NOTHING MsgBox "about to me.refresh" ' not visible yet Me.Refresh ' visible for a brief moment then scrolls due to apparent requery MsgBox "me.refreshed" ' now we must navigate back ' create a clone...

I haven't quite figured out what's causing the apparent requery, but I suspect it's because when I take the user input for one of the fields in the query, I insert a new record in one of the tables that makes up the query. Navigating back to the relevant record isn't a big issue - I know how to...

I have a datasheet with a recordset/recordsource set to a non-updateable query. It's a query on several tables. The user wants to change one of the displayed values on one of the datasheet lines, so it's one field in one of the tables. So a pop-up window takes the user keyed value and the...

All working now thanks, last post was a big help

Thanks June7. I've got a working inner query with 'input' criteria of DocReference. I've got a working outer query with no reference to the inner query or tblAllocations (shown in post #1 Main Query) The working outer query is related on the PK/FK. However I do save DocReference in...

Adam, I would love to simplify it. I've had various incarnations of this query but none produces the correct result. What I want is: For a single record in tblCustsSupps Show me all related records in tblTransHeaders, with the total of all related records in tblTransLines, and the total of all...

Micron, it inserts a checked record into the selections table immediately when clicked, against an already existing transaction line. Which I wasn't expecting to happen automatically but as Pat has explained it's because the tables are joined. I did put a me.dirty=false in the checkbox click...