Search results

Well, I've figured that one out (and the unselected list is a visual confirmation that the news records are created for the correct locations). It's now the selected list that's not working for me (see last two posts).

Ok, I'm using the debug.print which I thought would be helpful to work out the text to get the IDs of the fields I mentioned, then I can work out how to add them into the INSERT INTO loop: Dim intX As Integer For intX = 0 To Me.lstLocation.ListCount - 1 Debug.Print "tRequest ???:"...

Ok, just run the code above. Used the debrug.print to check that new record's PK value is returned (and it does, what else?! :)). Of course, my part of it fails to do anything (of course it does). I'm thinking it's something to do with the cycling through the lstLocation without them being...

I'm sorry for the tardiness of my response. I've been away over the Easter period and just got back into this. I now regret the break, I've forgotten everything :p I'm very grateful for your detailed response. However, I am slightly confused. I've been trying to implement this, but I can't, as...

I have a unbound form (called fBulkRequest) on which I'd like users to makes some selections and then click a button which then adds records to a table called tRequestDetail. I'm having trouble figuring out the syntax to do this: lstRequest (listbox), bound column (1) is IDRequest. I want to...

Sorry, yeah found that just after I posted. That is going to be so useful. I've rebuilt the form and it's all now working. Thanks for the help! Which is the better one to use, by the way. Which is considered to be better form?

sneuberg I don't get any window pop up. It's like it ignores the print.debug and just does the SELECT section. ???

I have a very simple query about the correct syntax for defining the RowSource of a listbox (lstRequest) based on a combo box value in the same form (fRequest.cboAcademicYear) Private Sub FilterRequest() Dim strREQUEST As String strREQUEST = "SELECT qRequest.IDRequest...

sneuberg, thank you! I'll give that a go. jdraw - I think my ERD is pretty sorted now thanks to MarkK's clarifying input (here).

No, I'd rather not.

Is there a way to prevent duplication of data across 3 fields in 2 tables? I have two tables: tRequest IDRequest (PK) FIDAcademicYear (FK from tAcademicYear) FIDRequestType (FK tRequestType) FIDSubject (FK from tSubject) RequestDate FIDStaff (FK tStaff) 1:M to: tRequestDetail IDRequestDetail...

I was close, but no cigar! There will be a list of software (tblVersion), but the software will be both software for which we have a deliverable (state: live) and software we have yet to make a deliverable (state: proposed) - and may or may not do so. They can propose software we don't have...

I should also say in both Package and Bundle there is a Status field, which select the build state it's at. This is to try to form work lists; what's to do, what's complete, etc. Status would be: 1. Unassigned (not yet built) 2. Assigned (not yet built, but assigned to a staff member to do the...

Software item = the installer. Package = action taken by us on a single installer to make it work with the deployment technology and, optionally, any configuration requirements. A software item may become one or more packages, as one subject may want it configured one way, another may want it...

Updated ERD attached. I'm still unclear how to link the bundle (the deliverable) to all this?

Or when you order food online, and they subsitute what you ordered for a similar item? Which is really annoying, but it kinda mirrors what may happen here?

I forsaw Request as being for 1 software item for 1 or more locations. So each request would be for 1 software, but I see where you're going..... At one point I did have a ERD that had RequestDetail having links from tblVersion, tblLocation and tblRequest but scraped it as that would take a lot...

Well I did say that the tblInstalls table name keeps changing. I'll change it back to tblRequestLocationJunction (or tblRequestDetail). That make it clearer how tblSubject, tblRequest throught to tblLocation works? The attached screenshot shows the rough function test of the relations on a form...

Hello I have a problem finalising my ERD for my database. The current diagram allows for the main volume of data-entry that is needed, but I’m struggling with the entities that will manipulate that data. I've started the forms & queries, but I'm stuck when trying to plan the...

Ignore me, spent all day failing with it, and now I've got it working. I just had a fit and deleted my previous attempts, recreated the frmLocation with subformRequirement and it auto populated the junction table. It was erroring over and over again, but now, after posting my stupidity, I've...