Search results

Marianne, thank you for your help. I figured out how to code the click open command for 1 work type option by the code: If Forms![Task List]![Task Type] = "Project" Then DoCmd.OpenForm ("Project List") End If. Works like a charm. I have two more different work type, "Trouble...

Marianne, thank you for your help. I figured out how to code the click open command for 1 work type option by the code: If Forms![Task List]![Task Type] = "Project" Then DoCmd.OpenForm ("Project List") End If. Works like a charm. I have two more different work type, "Trouble...

Sorry I fixed it. Code was off. I did type it in vb just had to change the syntax a bit. I appreciate your help. Just for viewing here is the code that does work: If Forms![Task List]![Task Type] = "Project" Then DoCmd.OpenForm ("Project List") End If I thought it should be that easy.

I have a MS sample database with a form named Task List that tracks daily task summary in table view. The first field reads either open if there is data for that record or new if data is null. When u click open, it opens the Task Detail form. Ive added a form to track Projects to this...

I have a "Problem Report" form with an ID#. On this form I have a control button that opens a "Field Problem Report" form. How do I make the "Field Problem Report" form open and autofill the "Problem Report ID#" field with the Problem Report's ID# so I dont have to enter it manually?

I have a form that calculates daily cash register totals. One subtotal is for cash [Cash_Tot], based on quantities of denominations. Second subtotal is a control referencing an embedded subform's footer total for check amounts. Summing both controls give me a daily total. Im trying to...

I use a Daily Cash Register Input form to sum cash and checks that works great daily. How do i get the sum calculated control [Total Cash] and the referenced control to a subform calculated control [Total Checks] to show on a query so that I may do a monthly income report? In short, how do i...

Thanks for your help neileg. After reading my post I couldn't really understand what I was asking for myself so let me try again. I want Form2 [Problem Description] to lookup Form 1 [Problem Description] if: [SPR No] on Form 2 has an entry, if not: then I want to allow for manual entry of...

I have 2 Work Order forms that I am trying to pass data with in to. Form 1 is named SPR_frm where: 1. SPR No (ID# for relating) is set to auto-increment. 2. Problem location is entered from a drop down selection combo box control. 3. Problem description is entered in text control. Form 2 is...