Page 2 of 2 FirstFirst 12
Results 16 to 25 of 25
  1. #16
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Sorry, I think I attached the wrong db. Try this one:
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  2. #17
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    Can LIST BOX as an object filter for me all previous inputs of the current report I am working on?
    Click image for larger version. 

Name:	Can LIST BOX as an object filter for me previous inputs of the current report I am working on.jpg 
Views:	13 
Size:	150.5 KB 
ID:	23703

  3. #18
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Can LIST BOX as an object filter for me all previous inputs of the current report I am working on?
    Yes, that's what the list box that I place on the form does now but at the moment it only shows those records where the "IS REPORT OK" field is null or equal to "No"
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #19
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    Great!!! It works!!! Thank you so so much...

    Please, if you have a Paypal account send it to me, I would like to send you 20 USD to have a drink.. If not, find something on eBay.com for the same amount and send me your postal address so I will buy it and send it to you..

    my e-mail is vazdajic@@@@@gmail.com

    Thanks once again!!!!!!!!!!


  5. #20
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Quote Originally Posted by vazdajic View Post
    Great!!! It works!!! Thank you so so much...

    Please, if you have a Paypal account send it to me, I would like to send you 20 USD to have a drink.. If not, find something on eBay.com for the same amount and send me your postal address so I will buy it and send it to you..

    my e-mail is vazdajic@@@@@gmail.com

    Thanks once again!!!!!!!!!!

    I'm glad that you have your db working as required now.

    Thank you for your kind words and your offer of 20 USD. The help I offer here and in other forums is made without charge. I just try to help when and where I can as so many others have and still do help me.

    Should you feel in the future that you would like me to do some consultancy work for you, I would be happy to oblige. Just send me a private message in the first instance.
    However, I feel that whatever your needs, they could probably be fulfilled free of charge by asking for help here.

    Thanks, once again for your kind words and gesture.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #21
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    In that case, while you are offering additional help, please make this work for me as well... I would like to see YES reports as well..

    Thank you so much..


    Click image for larger version. 

Name:	YES TO SEE AS WELL.jpg 
Views:	9 
Size:	186.8 KB 
ID:	23716
    Attached Thumbnails Attached Thumbnails YES TO SEE AS WELL.jpg  

  7. #22
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Is this what you require
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #23
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    YEEEEESSSSS it works!

    Thanks Bob.. I am so so grateful... Today I have said at least 20 people about you being so helpful.. Not so many people are willing to help like you do. Thank you once again... I will recommend YOU and this forum whenever someone will ask for MS Access advice..

  9. #24
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    Glad to help. Can you see the HOW it works though. The point of helping is to try to teach others about about how things work and can be done so that they become more capable themselves
    Post back if you need any help in understanding the HOW
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  10. #25
    vazdajic is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    95
    Yeah, now I see!

    Thank you for starting a fire in myself (this sounds gay but never mind ).

    I have two days of Access experience and slowly I get to see how things function here. On a college I have had FORTRAN for two semesters and I took a course in Actionscript 2.0 so I have little bit of experience in figuring out how programming works. Plus, with the help I get on this FORUM and the help I can expect here in the future, this whole Access story makes sense! Since yesterday I have had 10 Excel tables full of conditional formatting, IFs, COUNTIFs, VLOOKUPs etc. on 20000+ rows x at least 13 columns.. You can imagine how slow filtering was.. Now, based on the database you helped me to create I already have two queries (one that displays me all reports in the database, one for displaying reports per Engineer between two selected dates). I am able now to find double reports via querie (not via Excel using =COUNTIF($A$2:$A$28,A2)=$H$2 etc.)

    Thanks to your help I am much faster today in every way of data input then I was just two days ago in Excel...

    Next step I'm about to take is to add more tables and to establish relations between those..

    This is how it looks like now.. Thanks for everything..
    Click image for larger version. 

Name:	Final look of a database.jpg 
Views:	9 
Size:	213.2 KB 
ID:	23718

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Count Checked boxes on report
    By BLFOSTER in forum Reports
    Replies: 2
    Last Post: 06-22-2015, 09:33 AM
  2. Print Checkbox on report only if checked
    By azhar2006 in forum Reports
    Replies: 5
    Last Post: 10-26-2014, 11:59 PM
  3. Replies: 2
    Last Post: 05-21-2014, 06:16 AM
  4. Replies: 6
    Last Post: 12-05-2013, 09:55 AM
  5. Replies: 10
    Last Post: 08-25-2012, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums