Search results

Yes, it is set to dynaset.

Hi all, I have a command button on a form which appends details on the form to 3 tables - tblchargebacks tblChargebackDetails tblChargeBackCustomers When I make a new form with these as the underlying tables I cannot enter data into the form, I can only display it. When I try to enter info...

Thank you! I used the code in the control source of the [shipping] field, this works a treat.

Hi Ken, Yes it is (can't you tell!). I deleted the function and just put the code in the Subform_Exit, this works only intermittently. Do I need to put the code somewhere else? Thanks for your help.

Hi, I don't understand, I am trying to return a value of either £0.00 or £5.00 in the [Shipping] field. How else should I do it?

Problem continues Hi Ken, Tried that, same result.

Hi everyone, I have the following function: Private Function TradeShippingCalc() If [OrderSubtotal] >= 86 Then [Shipping] = 0 Else: Me![Shipping] = 5 End If End Function When I call this function - Private Sub TradeOrderSubform_Exit(Cancel As Integer) Call TradeShippingCalc End Sub It only...

Calculation problem solved Thanks Pat, Worked a treat - Bridge players obviously do know all the tricks! Thanks again.

calculation problem continues Hi Popeye, Thanks for your reply. Unfortunately, it didn't work. When the field is calculated on the form £0.00 flashes for just a second and then the field goes blank.

Hi everyone, I have a calculated field on a form which adds together two currency calculated fields from two other forms. This works fine as long as there are values in both of the fields I am adding together, the problem comes when one of the fields has no value. If there is no data in one...

Hi everyone, I have a combo box from which you can select customer details. My problem is this - If you select a customer from the list it fills in the customer details automatically, however if you then change your mind and select a different customer from the list you get this error...

Thanks Mike - worked a treat!

Thanks Ken - again! Do you know of a way to put a command button onto a form that allows the user to input the current date by clicking it?

Hi everyone, I currently have a form with a date field, the control source for which is set to =Now(). This shows the current date, which is what I wanted, however, the date field is automatically updated every day with the new date, so that all records show todays date even though the record...

Thanks for your concern! I'm not sure what I did, I messed around with the syntax for a while and hey presto. Thanks anyway.

Sum problem continues Hey guys thanks for your replies, I tried both and get this #Name? Help!

Hi all, I currently have a form which has within it an order details subform, what expression should I use on the main form to create a total price for the order when the price of each item is in the subform? Thanx

Combo Box Thanks for your reply. I need to see the customer details on the form so that this information can be printed with the order.

Hi everyone, I have a combo box which looks up customers in my customers table and fills in the customer details on my orders form. However, the customer information that it enters on the form isn't saved, each time I select a different customer from the combo box that customer's details appear...

Hi all, I'm trying to build an inventory form that will automatically reduce the UnitsOnHand total by the quantity ordered. Any tips on code to do this would be greatly appreciated!!