Search results

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...

Help please on sub query syntax. I've been tweaking this for ages, read the Allen Browne stuff etc. etc. but still can't get it right. I am trying to insert the sub query into the FROM clause. I need the summed value qValueAllocated. The main query is also a group sum of n records from a...

OK I have the solution I need. Thanks to Micron for seeding an idea. I modified my tblSelectLines to include the check box field, so now I have an actual record to save the check box state. Thanks to Pat for spotting the query totals error (fixed) and for further help. The query is further...

It's worth a lot Pat although it's now late so I'll need to come back to it and study it. I've fixed the query (don't know why I had Group By in there) and Micron has seeded an idea so I'm hopeful I can get this working. I'll report back.