Search results

Figured it out The subform that kept disappearing was based off the other subform, and when that didn't have any data, the query wouldn't work. I changed the structure of the form, put in an Update button and it works fine.

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

Wayne, Thanks for your advice. I already have a form where the user selects criteria for the query, so I'll just make begin and end date compulsory fields to fill in.

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

Thanks Jon, Thanks for your help - I knew I had something wrong but I couldn't figure it out. Once again someone on this forum has solved my problem. I really have to thank everyone for being generous with their knowledge of Access - this is a great forum.

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

Thanks Paul - I'll try the technique you suggested. The easy route may be the best option.

Thanks - another question Perfect - thanks so much. Here's another combo question. I actually want to use several combo boxes for the user to select the record/s they want to view. The combo boxes will be: DateImported (thanks it now works) PayPeriodEnd (use Select Distinct works like a...

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

Thanks Thanks for this. The button is on the main form and not the sub form so Me.Form.Requery worked!

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 think I've got it Rich, I went into the Query window, right clicked on the criteria that was causing all the problems and in the expression builder I navigated to the form, sub form and then the combo box...the syntax is: [Forms]![frmPayDetails]![Hours Breakdown test].[Form]![cboFaculty]...

Rich, I'm not sure what you mean...sorry very late here in LA and I'm pulling my hair out with this...how do I select the correct syntax????

I'm just trying to close the form - it's a pop up window for a bit more data entry, and I want a prompt so they close it and go back to the main form.

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

thanks thanks Wayne...i'm pulling my hair out here.....I'll look through the proper syntax for subforms and post a sample tomorrow - won't be until after 3pm LA time though. Thanks again...I really appreciate it. Good night....

so far Wayne, Now it's this code, but I still get data mismatch error. AAAAAAAAAAAGH!! SELECT ProjectID, ProjectName, FacultyID, CurrentProject FROM tbProject WHERE CurrentProject= -1 And FacultyID = " &Forms!Subhours!cboFaculty.Column(0) & " ORDER by ProjectName; It's really late here in...