Search results

  1. H

    Change records back color in continious form

    Hello guys! I have continious view form based on table. For each record here is a field "not available" represented by check box. What I would like to make is that when I click on this check box, whole line of the current record (all fields of current record) changes it's back color until this...
  2. H

    how to manage 60 controls in single form?

    Hi folks! I have stopped at this quite problem - I have a form where I should place 60 buttons so user can access them easy and quick. Each button must have a caption up to 50 symbols. These buttons must work a a filter. If I make it so, then almost half of the form is filled with butons and...
  3. H

    Check box with "Select All" option....

    Hy! I have a form based on query with lots of fields where one of them is a chech box field. Also I have a single check box (without control source) in form's header. What I want is that when I select this single check box, all check boxes for all the records in the form turns to value = 1...
  4. H

    This must be easy but I don't know how...

    Hi there! I have such problem: I have form "frmFilteredData" based on query "qryDataFilter" where one field (date) has criteria: Is Not Null And Between [Forms]![frmPerfPlanDialog]![beginning date] And [Forms]![frmPerfPlanDialog]![ending date] And I have another form "frmPerfPlanDialog" with...
  5. H

    Button works every other time???

    I placed a button on my form with this code in OnClick event. When I click it, message box appears. But when I click "Yes" button in this msg box, it works every other time. Why? What I am doing wrong? Private Sub Command22_Click() Dim Msg, Style, Title, Response Msg = "This is my message"...
  6. H

    Append and delete data at the same time???

    I have two tables - one for played performances, other for possible performances. Also I made a form based on table "PossiblePerformances" where I added a yes/no control which works as a criteria - if false (which is default) then performance is not yet played, if true it is played and must be...
  7. H

    Can I place fields verticaly?

    Hello! Is it possible to rotate fields in reports design? By default they are horisontal, but I need them to be vertical, because I have to print addresses right onto envelopes.
  8. H

    Timer event problem

    Hi! I have problem with my timer event. When I click mouse button ok some key on keyboard my event stops, wen I release button or key it continues to run. Why it is so? What I have to change there? Here is my code: Option Compare Database Option Explicit Dim kaza, aaa As Long Dim sony As...
Back
Top Bottom