Search results

  1. E

    Blank query result to a textBox

    Hi there. I have four separate queries each producing a value named "Sum of Price" for a particular category of product. they are embedded into a subform of a booking form for with Master & child fields set accordingly. on the booking form I have a text box I want to show the total of all the...
    • edh
    • Thread
    • Replies: 2
    • Forum: Queries
  2. E

    Moving characters from one field to another

    I have been working with a database where to identify the category the organisation's members fall into they have been adding various characters to the end, some standard, some varying and completely indecipherable and for all intents useless, anyway I want to be able to use the info of what...
  3. E

    OpenForm WhereCondition based on field in current record

    Hi there , I have a form opening in datasheet view. When I double click on the ID field of a particular record I want it to open a form in form view on that record so this is what I came up with: Private Sub BookingNo_DblClick(Cancel As Integer) Dim strBookingNo As String strBookingNo =...
  4. E

    OpenForm...newRecord in subform

    I have another subform problem, Simply trying to move to a new record using a button control... but macro won't work and the syntax for doing this with a non-sub-form doesn't either. Hope you can help
    • edh
    • Thread
    • Replies: 3
    • Forum: Forms
  5. E

    Opening and editing as tabbed subform

    Hi there, I am building a database which has UI with a main booking form and the sub forms for the fine details, I have the sub forms on tabs and have a check box make the tabs visible when it is checked. I have set the sub form to take the parent form's Ref no through a lookup but when I tab...
Back
Top Bottom