Recent content by Pusher

  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... :(
Top Bottom