Search results

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

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

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

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

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

Hi all, I'm currently trying to fix a database that hasn't been working properly and have come unstuck trying to run a report between 2 dates. Basically, each report shows a date (DayDate) and belongs to a certain Contract (Contract). I have developed a form with a combo box (cboContract)...

Hi all, I'm relatively new to Access and need a little help with a combobox and subform. My form is called Contact Register. The form contains a combobox that has two columns showing the Company Name and Division and a subform that I want to show the Contact details of each person relating to...

I'm a beginner at Access and I can't seem to find the correct answer on any other forum online. I have a number of tables, forms and queries set up, it's just the very basic that is stuffing me up. To break it down, I have two tables 1. CompanyRegister - contains 2 fields CompanyID (Auto No...