Search results

I'm unsure of what you mean by the new selection? All I can get to show regardless of the selection I make is Company1 (in the combo box), Dept1 (in the first unbound text box) and Address1 (in the second text box).

Apologies John, I haven't explained myself clearly enough. My combo box has four companies details listed in it. For example Company1, Dept1, Address1 Company2, Dept2, Address2 Company3, Dept3, Address3 Company4, Dept4, Address4. When I go to select, say Company3, Dept3, Address3, my combo...

Hi all, I'm having some issues with a combo box selection. I know I've had this issue before but I can't for the life of me remember how I've solved it. My form is frmContacts, it's record source is tblContacts. tblContacts has the following columns - CompanyName (PK), ContactName (PK)...

Hi everyone. I have a report that shows the costs incurred by resources on particular projects. The report is firstly grouped at the project level, and then at the resource level. Each resource is classified as either Plant or Labour, and the costs incurred (based on this split) are listed...

All good. Problem solved. Added in a few extra steps to get the query working

It currently looks like this... SELECT qryIncurredCosts.Contract, qryIncurredCosts.ContractDesc, qryIncurredCosts.Contractor, qryIncurredCosts.Representative, qryIncurredCosts.AwardDate, qryIncurredCosts.DayworkNo, qryIncurredCosts.DayDate, qryIncurredCosts.FacilityCode, qryIncurredCosts.Item...

I have a contractor timesheet system in which timesheets are manually entered and reports are run based on these. What I want to do is be able to show on a report the Week to Date costs inccured. In a query, I have assigned each timesheet entry a Week No (1-52), Year No and Month No. What I...

Never mind. I went back and changed my subform record source to be a table not a query. Works fine, just makes it a bit more awkward

I sort of get where you're going with that but I'm unsure of how to change it. This database is 10 years old and may have worked at some point but I'm just going through and fixing it currently. In the form, the user needs to select the applicable contract. The subform will have a combo box...

So I posted this in another thread because I thought something was wrong with my form. I've worked out it's actually my queries. I have a query called qryCurrent Resources that lists all of the resources and their IDs from each Contractor. The SQL Code is as follows. SELECT...

I have found my issue - the query that the subform is based on is non-updateable. This query is made up of two tables and another query (qryCurrent Resources). It's this query (qryCurrent Resources) that is also non-updateable and I'm assuming causing all the problems. The SQL code is as...

I have a pre-existing access form that I am trying to get working again. It's fairly basic - the user selects the Contract No from the drop down menu and all of the resources and their allocated rates are displayed for that Contract in a subform. My issue is that the subform will not display...

My bad. Thank you. Works like a charm!

It's saying that the Database cannot find the object Me. This is the code I put in the after Update of the combo box on the main form Me.sfrmDayworkDatailsEntry.Form.txtResourceID.Requery

I'm trying to fix an old database that has a few broken bits and pieces. I have a form set up that has, on the main form (frmDayworkEntry) a combo box (cboContract) that the user selects the applicable contract from. Then, the subform below (sfrmDaywaorkDetailsEntry) has a combobox...

Thanks guys. It's working now but it was due to the fact it was based on company ID not Division ID. In the database, companies can be listed more than once because they have divisions that are specific to them. All good!!

Also, this is the AfterUpdate code I'm running Private Sub cboResourceFind_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.RecordsetClone rs.FindFirst "[Company ID] = '" & Me![cboResourceFind] & "'" Me.Bookmark = rs.Bookmark End Sub...

Thanks for that. I've got it under control now. I sort of changed it up a bit and I now have a text box with a combo box/button next to it. The combo box/button selects the company ID, division ID, company name and division. But this has created another drama. There are 3 options to select from...

Okay so, I have a main form that has a combo box in which you select the company and division (one combo box, two columns) for which you want to enter data. The record source for the main form is the query that gives the two columns. I then have a subform beneath and what I want to happen...

Legend!!!!