Search results

  1. Pusher

    Conditional Checkbox yes to no - no to yes

    Hi all, I have a problem with some checkboxes and conditions, I have a checkbox A and B – B is invisible and is automatically checked when A is checked (onclick event). I want this to be the case when A is 0 to 1 but not the case when it’s already checked and goes from 1 to 0. This happens on...
  2. Pusher

    Calculate the Day

    Hi all, I want to calculate the DAY (Friday, Thursday, ect.) form a text box containing a date. How do i do this? Thanks
  3. Pusher

    Textbox Date just from First to Last

    Hi all, I have an unbound textbox that I can enter the date. I want to make 2 buttons that will go thru the dates day by day forward (Button1) and back (Button2). I want that the last day in the DB (I have a constants that are the first/last day in...
  4. Pusher

    Counting query yes/no and is not null

    MonthName :) thanks
  5. Pusher

    Counting query yes/no and is not null

    That did it :) Only one thing - how can i make it read January, February an so on, and not 1 2 3 :)
  6. Pusher

    Counting query yes/no and is not null

    Hi all, I have a query that counts by month. It works fine when you count separately the yes/no field and is not null field but when I try to put them in the same query I get the same number in both counting fields. Is there a way for this to work? Thanks SELECT Month([DATUM_IZVESTAJA]) AS...
  7. Pusher

    Update Query on all records but the current

    Hi all, I want to make my update query work on all the records but my current record because i get the error that another user is changing the record in my form. I have a check box that is firing the update query. How do i change my query so i affect all the records but not the current one? Thanks
  8. Pusher

    On checkbox false run update query

    Hi all, I need to start an update query on deselect or unchecking a check box. I made a mechanism for auto checking this box if there is a result from another query – this query checks to se if there is another record that has this box checked. If there is, the new record has this box checked...
  9. Pusher

    Disable Design view

    So can some1 help me? :)
  10. Pusher

    Counting query with 3 yes/no fields

    Hi all, I want to make a count query – in my table I have 3 Yes/No fields. I want to make 1 query that will count them all and result is Field1-Count Field2-count Field3-count. How do I do this? Thanks
  11. Pusher

    Disable Design view

    access 2007
  12. Pusher

    Disable Design view

    Hi all, How do i disable design view on my report – i want to secure my reports so when in report view you cant get in to design view. Thanks
  13. Pusher

    List is cropping text

    Hi all, I made a List box that runs a query that gets Type and Details of a Location. I made a listbox the biggest i could because it will be used on an old computer with low resolution. When i get a Location with much Detail text it is croping my text and can’t see the rest of it. How can i...
  14. Pusher

    Open form if query has results

    Hi all, How do i make a form open on a event (on Load of another form) if a query has results?(the form that opens displays the results) If there is a need for it then it opens, if there is no results then it does nothing. Thanks
  15. Pusher

    Check box colors the form controls

    Where did you get this numbers? I cant find it... :(
  16. Pusher

    Check box colors the form controls

    When i check the box in the record i want it to flash - when i am on that record. On the other records i want nothing to happen.
  17. Pusher

    Check box colors the form controls

    Do i leave the other code or just the timer? I can't make it work for some reason :(
  18. Pusher

    Check box colors the form controls

    Thanks that did it :) What is the yellow color number and can it be made to FLASH somehow (Yellow and white) ?
  19. Pusher

    Check box colors the form controls

    Hi all, I need to color all my combo boxes and text boxes with the same color when i click a check box in a form. Can this be done? Thanks
  20. Pusher

    Change record from a blank form

    Hi all, How can i enter the parameters of a table record with a blank form? If i make a BLANK FORM and have a combo box that helps me find the specific record in a table, how can i than change something in that record. TABLE1 [ID|LOCATION|CHECKBOX] - Combo box [ID| LOCATION] in TABLE 1, id...
Top Bottom