Recent content by circlestech

  1. C

    Delivery Costs & Location Form?

    Hello Shane, Both DeliveryCost & DeliveryLocation are in the same table what code would i require putting the afterupdate to make this work? Thanks Ben
  2. C

    Delivery Costs & Location Form?

    Hello, I'm setting up a delivery cost and location form. What i need this form to do is say i select Guildford for delivery i need the delivery cost text box below to say £12.50 without manually looking up the costs for that area and if it was Farnham then £24.00. What is the easiest way of...
  3. C

    Block If Without End If?

    I think i'm getting to the stage where i need to get some who knows what there doing to check over my database and make changes to it to make it all work correctly. I've only started VBA a bit this month.
  4. C

    Block If Without End If?

    Hello, Thanks for the above code! How does this code look: It's for a mail order form Option Compare Database Private Sub btnCardStartDate_Click() Me.CustomerCardStartDate = PopUpCalendar(Me.CustomerCardStartDate) End Sub Private Sub btnCardExpiryDate_Click() Me.CustomerCardExpiryDate =...
  5. C

    Block If Without End If?

    Required Fields What i would like now is that when a shop assistant is filling out an order form i would like it to verify the fields with friendly messages i've tried it in the table and changing the fields to required but the messages are less than friendly. Is there some code i can add to...
  6. C

    Block If Without End If?

    Hello, I finally got it sorted here's the updated code: Private Sub Form_Load() If frmOyezstrakerCustomerMailOrderSub!CustomerCardType.Enabled Then Me.CustomerAddress.Enabled = True If frmOyezstrakerCustomerMailOrderSub!CustomerCardType.Enabled Then Me.CustomerPostCode.Enabled = True...
  7. C

    Block If Without End If?

    Hello, What i'm trying to do is When a shop member starts a new order and they want to review old orders if there arn't any i want a message saying no orders found and for the form to close? Any Ideas on how to change that last bit of code to allow this? Thanks Ben
  8. C

    Block If Without End If?

    I have had a fiddle with no luck do you think someone could do the corrected version. I'm still very new to VBA. Thanks
  9. C

    Block If Without End If?

    Where Do they go? Thanks
  10. C

    Block If Without End If?

    Hello, I'm pulling my hair out i now getting Block if without end if and it's showing a problem with my formload part. Here's the code: Private Sub Form_Load() If frmOyezstrakerCustomerMailOrderSub!CustomerCardType.Enabled = False Then Me.CustomerAddress.Enabled = False If...
See more
Back
Top Bottom