Search results

I am building a simple sales record database for my wife who sells Watkins products. I have a main form that lists all her customers. I open an Order Entry form using an OpenArg to pass the CustomerID to the order form and insert that value in the CustID field. Everything works fine except...

I have an Events Detail form for viewing the details of an event or adding a new event to the calendar. On that form is a subform that shows the time and title of any events that are on the same date that is selected. I would like to be able to click on the time of any of the events shown in...

I have a form that has two subforms on it in datasheet view. One shows the training an employee should have based on there job assigment and the other form shows what they actually have. I have the subform that shows what they should have with an on click event that adds the training type to...

I have a Event Details dialog form to add new events. The form can be opened up from two different forms, the main Current Events list form and the Calendar view. I have the following code in the On Close event that syncs the Calendar with the new record. Private Sub Form_Close()...

I have a form that has two subforms. One subform shows the required training that an employee should have based on his job classification. The second form shows what training is currently assinged for that employee. I have it setup so that a user can click on any item in the first list that is...

Can you do an If Then expresion in query criteria"? If so How can I do what I need? I am building a Training Records Database I have a query setup (actually several for differnt reports) that shows if an Individual's training is past due. The query works fine on the original criteria of the...

I have a main Form and when I try to open certian other forms while it is open I get the message: "The table 'Training_List' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically." Is there away to build...

Hello, I have a split form that I want to open in dialog view but when I do it opens and fills the entire screen with the close button off screen. If I switch my form to form view then it will open up in dialog at the right size, about 4 inches by 4 inches. Am I missing a setting some where...

My company upgraded us this Fall to Microsoft 2007. I am building a database to track employee training and I have had several instances where form controls suddenly stopped working or just crashed Access totally. This morning it happened again. I am at the point where I am populating the...

Hello, I have a split form with the datasheet at the bottom. On my form I have a search box that I borrowed from Microsoft's Contact Management database template. The box searches on each of my fields so I can filter base on location or job classification, etc. The form is for setting up a...

I have a split form that is setup similar to the form in the Access Events templates. When the form opens up the first feild in the split form has the focus. When I try to use the down arrow key on the keyboard to go down through the records it will only go sideways left to right. I can go...

How do I macro to step to the next action after a conditional stop? I have a button to open a form to the record selected. I want a message box to show if no record is selected. In my macro I have: IsNull([employee_ID]) MSGBox StopMacro OpenForm SearchForRecord Close When the...

Hello, How can I have a Combo Box be invisible when a form opens up and then only become visible after the [Employee_ID] has a value? The combo box performs an important function of out inserting the required training records based on the employee's job classification. Everything works slick...

Hello I have a training records form/subform with a combo box that I created with the wizard to look up and go to specific records. The combo box works fine when I open the form directly. The problem I am having is when I open the form from my "Employees" form using a wizard created button to...

I have a database to track employee training and I've set up an append query to archive records of employees who quit. I have employee info in one table and training records in a second table. The field [Employee_ID] is the primary key in the "Employee" Table and I have an [Employee_ID] field in...

I am setting up a database to track employee training and I am not sure how to setup two queries that I need. One to search for training that is out of date and another for training that is coming due in the next 60 days. The fields I am looking at are [Training_Cycle] which can be Once...