Search results

Morning Paul.. Apologies for not coming back to you last week. With a fresh head I've looked at the issue this morning, created a new form, listbox, query and started re-creating the scenario. I discovered that if I launched the form from the navigation pane the process was fine, however, if...

Cheers Paul.. Just tested it and it still seems to be returning a Null value.. It's failing at listID = Me.List1.Column(0, List1.ItemsSelected) now.. One point to note (whether this is valid, or means anything, I don't know) .. When clicking on a row in the "other" listbox, the row is...

Here we go.. (supplier name changed to ZZZZZ for conf. reasons) Row Type : Table/Query Row Source : SELECT qryCommitmentSummary.ID, qryCommitmentSummary.Type, qryCommitmentSummary.ShortDescription, qryCommitmentSummary.Property, qryCommitmentSummary.TotalContractAmount...

:( ?me.List1 Null

FormA Listbox -> DoubleClick -> Commitment Display/Edit Form (works) FormA "search" button -> FormB -> Select Property or Supplier from Combox box -> Search button -> FormC Listbox Rowsource amended and Form Launched. (this part works!) Private Sub Command5_Click() Dim SQLStr As String SQLStr...

Hello again Paul... It fails @ TCA = DLookup("TotalContractAmount", "tblCommitments", " ID=" & Me!List1 & "") Using the immediates window, ?me!List1 returns Null, whereas if I stick a break point into the "other" listbox and run the same query in immediates, I get the ID of the record I...

Morning.. I have two listboxes, both doing similar things (displaying commitments against properties/suppliers).. The first listbox is a list driven by a query and can be double clicked to launch a display/edit form.. This works without issue. The 2nd listbox within a form which is called...

To answer my own question... Yes.. Set RS = CurrentDb.OpenRecordset(" SELECT tblCommitments.* From tblCommitments Where ID = 42;", dbOpenDynaset) Hurrah! Thanks for your advice. Much appreciated.

I'll mull that one over then.. Uncertain how big this is going to become at this point.. Certainly not 10m, but 10k is conceivable.. As I'm on this voyage of discovery (and feeling a touch lazy), could I select "*" from tblcommitments where ID=42?

Friendly advice always gratefully received.. At what point are we calling the table "big"?

Cheers Mailman.. I've done some reading, googling and testing and come to a method which I think I'm going to adopt.. In simple testing I arrived at this... Sub test() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblCommitments", dbOpenDynaset) ID = 42 With rs .FindFirst...

I did wonder whether there was an ordering issue.. I think I've ended up chasing a method which, whilst initially was simple (the append query to add the row to the Archive table), is now not as simple as it could be! So.. Any recommended reading on Option 1? ;) I'll tinker with option 2...

If I wasn't working in a full blown Citrix environment........ :(

The form in question is frmCommitmentEdit Database is attached to this post.. Cheers.

Nope, they're pure and "simple".. ;)

If I've verified that qdf.parameters(17) (for example) contains the data that I'm interested in, is the rowsource verification still a requirement? Table is configured as per the screengrab attached.

Erm.. Simply because I searched for a method to achieve my results and the one I'm using was the first I fell upon! Type, Owner & Heading are all text values, represented in individual combo boxes.. (Other combo box values on the form are being carried across without issue. Property for...

Thanks for the advice Paul.. I don't wish to seem ungrateful, but that's not the issue I'm focusing on right now.. Stepping through the routine and querying the values of each qdf.parameter(x) displays the correct values (or at least, it appears to), but they seem to disappear between adding...

Morning folks, hope Access is being kind to you today.. I'm mid build on a commitments tracking (pseudo Purchase Order system) project, but seem to have run into an issue with a loop I'm building to allow users to edit commitments. The idea is that an edit form is launched, values amended...

Scrub that, I've had an extra cup of coffee and my brain has started working! It's simple when you stop and look at it