Search results

I have a form, with a multiselect listbox that is displaying data from a GROUP BY query, which itself pulls data from more than one (related) tables. What I want to be able to do, is for selected listbox entries find the matching records in one of the tables used in the query and run an update...

I have a listbox on a form that is based off a grouped query. For example: Listbox: lstRequestedSoftwareAmalgamated Query: qRequestedSoftwareAmalgamated, with the following fields grouped: Title (group by) Version (group by) ConfigInfo (group by) [other grouped fields...] Locations (count of...

I have a unbound form to add data into a table. I have an ADD button which then adds in the field data on the form into the relevent table (these form fields are lookups to other tables, so the data that will be appended will be all ID numbers). I have a query called qRequestDuplicateCheck...

Not sure if this is best here or in Theory and practice of database design? It's causing me massive problems on forms so here unless mods think otherwise. ------------------------------ I have had an issue with orphaned records today and I'm, first, massively panicked, and then I'm hoping...

I'm going to detail the structure I have, the question is after (highlighted) I have a main form (well, almost, it's inside the navigation subform....): fSoftwareItem. This is unbound and houses 3 subforms that are linked to each other, in 1:M relationship as ordered below. These forms are...

Further to a previous thread... and valuble advice from Minty about being able to have a subform of a continuous form (in the footer)... I have a continuous form (fLocation) based off a query (Record Source: SELECT * FROM qLocation) which in turn is based off a table (tLocation, which has...

I hope some people will be so kind to help me with a form I'm having huge trouble with. I've attached a stripped back database (removed non-related tables and other forms and filled with test data that doesn't represent RL). There are two forms here, both continuous: fStaff fLocation Both...

I needing a continuous form (fLocation, based off tLocation) which users add records directly on. Fields are: IDLocation FIDBuilding (FK, to tBuilding.IDBuilding) --- cboFIDBuilding / txtFIDBuilding Room FIDUsage (FK, to tUsage.IDUSage) --- cboFIDUsage / txtFIDUsage FIDFaculty (FK, to...

I have a continious form (fStaff, based off tStaff) that has the following fields: IDStaff (autonumber) Firstname Surname FIDRole (FK to tRole.IDRole), cboFIDRole Ex (Yes/No), CheckEx In the header of this form (fStaff) I have a checkbox (called CheckExFilter) If it's checked I want it...

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

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

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

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

My database has a few many to many relationships that are resolved with junction tables. I'm now building the forms. I have no problem on forms making the associations between records via the junction table if both sides of the M:M have records, but I can't figure out how to do the following...

Someone has asked me today to manipluate some data on a worksheet (from one of many spreadsheets the database I'm currently trying to create will be replacing) for a report. The data is not normalised in any way (so one massive worksheet). I've quickly imported the data and tried to split it...

Can someone point me in the right direction. I have the following relationships between 3 tables: tblSWVersion 1:M tblInstalls tblSWVersion 1:M tblPackage 1:M tblInstalls The table's fields are as follows, with example data: tblSWVersionIDSWVersion SWV1 SWV2 SWV3tblPackageIDPackage...

(This is related to my Are the relationships between my tables *totally* wrong? thread in the Tables forum if anyone wants more background - sorry I can't post links until I hit 10 posts and don't want to spam just to get to that point). Relevent to the problem below is the attached ERD, which...

Hello It's been a good number of years since I've been involved in databases so take me as a newbie. I'm hoping someone will have the Eureka moment that has failed me so far. I'm sorry that this is the 2nd post to the forum, I'm honestly trying not the be rude by jumping in with a HELPME-type...

Hello I’m currently based in the East Midlands, UK and working for an educational establishment. Until fairly recently I hadn’t worked on, or created, databases in anger for about 12 years but I’m now dipping my toes back in the water for a project whose data has been, so far, managed by a...