Search results

  1. M

    Open a tabbed Subform to a New Record

    Thank you in advance for your assistance. Here is the broad strokes of my challenge. I have a sales database that handles POS transactions. Within the program the user can select a customer from a standard search form. This form passes the primary key for a TABLE tbl_Customers to a NEW FORM...
  2. M

    Locking a record in a Subform

    Hello and thank you in advance for your assistance. I have a FORM frm_Layaway that allows a customer to put an item on hold with partial payment. The Payment tab contains a SUBFORM sfrm_PaymentDetails that displays the payments in continuous form view (This allowed the sales person to process...
  3. M

    Close Button Question

    Here I thought I understood this command... Thanks again for your help. In my database I want to move the user through forms passing some information along and closing the previous form. As an example I have a Form frm_NewCustomerEntry with a button cmdNewOrder that has in its OnClick Event...
  4. M

    Placing Query Results in a control on a subform.

    Thanks for the help... Brain must still be saturated with the Stout from last night (2 Nights in a row = Brain Dead) I have a Form called frm_NewOrderEntry2 with 3 tab controls with subforms sfrm_NewOrderDetails, sfrm_Payments and sfrm_DeliveryDetails. I have a Query qry_OrderTotal that...
  5. M

    Enabling a control and moving to a new tab in vba

    Thanks for your assistance. I have a parent form frm_NewOrderEntry with 3 Subforms on tabs. I would like to enable each tab after the user confirms they have completed filling the information. I assume I will set the Locked Property to True for the tab controls when the form opens. I would...
  6. M

    What is the best way to retrieve indirectly related data in a subform

    Thanks to all of you for your ongoing assistance Here is what I want to do. I have a fairly standard order management hierarchy. Tables: tbl_Customers: Primary Key= ID tbl_Orders: Primary Key = ID Foreign Keys: Customer_ID tbl_DeliveryDetails: Primary Key = ID...
  7. M

    Trouble with Syntax for DSum in Form

    Thanks in advance your your assistance. I am working on a Order Management Database. In this Database I have a form frm_NewOrders that is bound to a table tbl_Orders with the Primary Key Order_ID. I have within that form a subform called frm_NewOrderDetails Subform that is Bound to a table...
  8. M

    DLookup Runtime Error

    Thank you in advance for your assistance. I am a relative Access 2007 Newbie and am having a problem with a form I created. This is a variation on a Order Database. I have a table Products with a field RetailPrice that gets its value from a table BoxStyle from a field BoxStyleRetailPrice in...
Back
Top Bottom