Search results

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

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

So in the control I have to code the checks for the controls in IF statements? As an example: IF IsNull Forms!frm_CustomerEntry!FirstName Then MsgBox("Please Enter A First Name") ElseIF IsNull Forms!frm_CustomerEntry!:LastName Then MsgBox("Please Enter A Last Name"...

I have 5 or 6 controls with the Validation Rule Is Not Null. Normally if the user navigated to a new record the db prompts the Validation Text associated with the Null Control. I have the form in Data Entry Mode and have disabled the navigation bars, close button and record selectors. What I...

So the acSaveYes bypasses the required fields? So how should I have handled the event?

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

Here it is... and surprise the DLookup No longer works... ARGHHHHHH. I understand that cleaning sewers is a rewarding career... wonder if it too late to change???? The Form is frm_NewOrderEntry2. It is meant to be opened on creating a new customer record with frm_NewCustomerEntry. The...

will enter some dummy data and post shortly

I Currently use Dlookup in 1 other context. To set Point of Time Values for Products in Order Details ie. To store the price of an item at the time it was purchased so that the record is unaffected by future markups of the same product. In the above case I will be using the Value in an IF...

Should I be considering an alternate method???

Have I mentioned you have the patience of a saint???? I was completely oblivious to the fact that you can do a DLookup (which I use elsewhere in my data base with a query. I really appreciate the way you have helped me understand what is being done. I have implemented most of your ideas in a...

Tried the DSum Function even using the expression builder I get a NAME? Error. ARGHHHHHH...

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

Thanks Again!

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

Thank you very much. That's Perfect.

The Form frm_NewOrderEntry has 3 Tabs. 1. tabOrderDetails Contains a SubForm sfrm_OrderDetails 2. tabPayments Contains a SubForm sfrm_PaymentDetails 3. tabDelivery Contains a SubForm sfrm_DeliveryDetails

Proficient is such a relevant term... LOL ComboBoxes...I use them have repeated and ongoing arguments with them. Concatenation... I use in some of my queries. Truthfully my exposure to access is only about 2 months now. I am an MBA wearing a developer's hat for what was supposed to be a...

tbl_Customer PK=ID --> tbl_Orders FK=Customer_ID tbl_Orders PK=ID ---> tbl_OrderDetails FK=Order_ID tbl_DeliveryDetails FK=Order_ID So there is no direct relationship between tbl_DeliveryDetails and tbl_Customers. Argh... why does Stout taste so good???

Sorry its early here an I had 5 too many pints at the pub last night. Here is the goal. I have to generate an invoice off of this order. So..... 1. I Need to the user to enter a delivery address for the product. Which will be used on the invoice and on a Delivery Report. 2. Each...