Search results

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

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

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

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

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

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

I have a form for an administrator to manage task orders. It is composed of a list box and some text fields to modify the currently selected task order in the list box. There is also a button to delete the currently selected t.o. record. I have very similar forms for other things, such as...

I have some forms in my database that have the cancel command (which closes the current form and opens the parent form) set to "yes". Some work as expected when I press the escape key, but some return an "The OpenForm Action was Cancelled" error and terminate the session. Any ideas on what/where...

I am new to Access, so bear with me, please. I have the following database setup: tblMonths MonthID (unique ID for a specific month instance) Year (year of specific month instance) MonthNumber (1-12 representing actual month of specific month instance) Hours (working hours in specific month...

I have a login form that handles the "Enter" key always selecting the "Login" button. However, when incorrect credentials are provided, a pop-up is displayed notifying the user. When pressing "Enter" on the pop-up to select "Ok," the keypress is carried through to my login form, thus trying to...

I have developed a VBA check on launch of my Access 2007 database application to see if the linked back-end database is found. Something is wrong with my code, and now I am locked out from editing my database. When I open it, I get my vbCritial message box notifying me that the back-end db is...