Search results

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

Thanks, lagbolt, could you please specify a tad more on that sql statement? I'm real new. So, I have a form with a listbox called lstEmployees pulling data from a table called tblEmployees. I want the delete command (called by a button on the form) to delete the currently selected record in the...

I have a situation where I have a table for employee information with a key ID for each employee as well as a table for subcontracting companies each with a key ID. I have a table with Assignments which assigns either an employee or a subcontracting company to a specific amount of hours in a...

Could you point me to how or explain to me how I could intercept this error? Thanks.

Could you describe that method more, or point me to a tutorial or reference on it? I'm really pretty new to Access... So, somehow just store temporarily the IDs of the records to delete in a queue, and if the user selects "save and close," then run the delete query, else clear the queue? Thanks.

I have several forms in my system that manage such things as employees, projects, contracts, etc. In each of these management forms, I want to have a delete query. However, I want to, instead of directly deleting a record, maybe make a backup copy in a temporary table. When the user leaves the...