Search results

I have an open form (frmPayDetails) that I enter in pay details, sometimes I need to keep that form open and swap to a different form (frmProject) to enter Project Details. I need to go back and forth frequently so I keep both forms open. My problem is this: FrmPayDetails has 2 subforms -...

Please Help - I have to get this database finished before I begin maternity leave, and this is the LAST hurdle. I have a report that is based on a query PayDetails from two main tables: tbPayPeriod, tbHours -this gives me 233 records. The query gives me the pay details: * PayID * StudentID *...

I have a report based on a query that gives pay period information - via a form the user can select different search options for the query eg. employee, financial year etc. In the Report header I want to display two dates: the date of the first pay period, and the last pay period in the query...

I have a form where I have a number of combo boxes and text boxes, what a user enters or selects will be the criteria for a query. I place the query criteria in an extra column with this structure Field: [FinancialYear]=[Forms]![PrintFacultyReports]![cboFinancialYear] Or...

I'm wanting to use a combo box to select the query criteria for opening a form. I want a combo box that gets it's values from the DateImported field in tbPayDetails. When you select a date, it uses that as the query criteria and returns all records from tbPayDetails that were imported on that...

I have a form based off a query. I have a button that I want the user to click when they've finished adding in new records in the sub form. This is to requery the main form so the SumofHours is recalculated (this is in the form's query). The on click for the button is Me.Requery which...

Ok, I don't know why this is happening... I have a sub form - the design layout and single form layout is faculty ID, Project ID, Hours, but the datasheet version of this very same form is reversed: it's Hours, Project ID, Faculty ID. Why oh why is the order reversed and what do I need to do to...

I'm new to VBA code. I have a button on a form that will save the record and close the form. So far I have this code, it works, but I know it doesn't have any error handling. Any input greatly appreciated. Private Sub cmdSave_Click() Set frm = Forms![frmhoursentry] If Me.Dirty =...

Ok, I posted this last night, and it still won't work. Does anyone have any ideas??? Please help. I have 2 cascading combo boxes that work on a form [frmSubhourstest]: cboFaculty and cboProject. They work fine with this code as the row source for cboProject: SELECT tbProject.ProjectID...

Ok, I created a form[frmSubhours] that has 2 cascading combo boxes (cboFaculty and cboProject). Everything works fine, thanks to previous posts about cascading combo boxes. But now I want this form to be a sub form on [frmPayDetails], and it won't work, I get an error message asking to enter...

Please help - new to Access and VBA. I've searched old posts but I still can't work this out. I have a sub form "Hours" based on the table Hours. This sub form appears within the "Pay" form. On the sub form I want 2 combo boxes: cboFaculty and cboProject. cboFaculty is bound to a query that...