Recent content by bballhermit

No, I do not have any lookups in my actual tables. I am querying from the form to pull in the table data. Any other ideas? Thanks.

Thanks for the responses. None of the three criteria are text, however, I do not believe. They are all autonumbers.

Thanks for the tutorial! Hmm. Now, I get a datatype mismatch. Here is my code: Any ideas? Now, my combo boxes are all unbound as they are a filter system that are have a requery action anytime any of the combo boxes are updated. Would that affect it? If so, how could I fix it. Thanks.

I am trying to write a function to populate text boxes with hours based on filter combo boxes on the form. My function code is below. The line Set rst = db.OpenRecordset("SELECT * FROM [tblAssignments] WHERE (([tblAssignments].[YearID]=[Forms]![frmEmployeeAssignment]![cmboYear]) AND...

I have a project staffing form that displays employee's assignments to a specific project in a listbox. I have an "edit" form that launches when the user clicks a button. How can I pass in the information of which employee record is currently selected in the listbox to the new form that is...

Ok. Thanks.

Ok, thanks. The issue I'm having is that my sums need to account for multiple fields of data horizontally within one record, as well as fields all the way down. Can I do some sort of horizontal summation within the dsum command?

I have a project staffing form that displays employee records and their hours for each month of the selected year on the selected project (filtered by combo boxes) in a listbox. Also on the form, I want to have a couple text boxes that display the total number of hours and the total cost for the...

Ok, thanks. I'll give that a shot.

Yes, you did mention that before, and I am definitely open to eliminating this link/table, however that's the only way I know how to store and access the amount of business hours in any given month.

I am trying to design a form/subform combo as described here: The main form has combo boxes selecting the contract, task order, project, and year as filters. In the subform, then, I want to have all employees that have hours assigned to that project in that year to be displayed. The subform I...

Thanks, so when you say default are you referring to setting its property to disabled, or doing that in the code somehow? Thanks. I'm real new to Access.

I have a form with a list box containing employee information. I have a button on the form that runs a command which deletes the currently selected employee. When no record is selected in the list box, I want the delete button to be disabled. To do this, I have the following function called in...

Nevermind, I figured it out. I just had to do something like... "WHERE tblEmployees.EmployeeID =" Thanks.

hmm, ok, could you expand more on the hide functionality for me? does the hide apply to a whole record? does that then trickle down through relationships in other tables? say i have a project that is related to a specific contract. if i hide the contract, will the project be hidden too? could...