Search results

  1. C

    Is genius born or made?

    There is a good book about this topic. It is called Outliers by Malcom Gladwell. If you have audible give it a listen.
  2. C

    WiFi repeater

    The primary drawback of a wireless repeater is that it effectively halves the bandwidth for any computers connecting to it, rather than the primary router. The reason for this is that the repeater receives the signal, processes the signal (which takes time) and then rebroadcasts the signal – and...
  3. C

    Sum on a report

    I have some fields on my report that get totaled in the date footer, but i want to have a grand total at the bottom of the page is this possible.
  4. C

    Help with tables In a Form

    Thank You for all of your help
  5. C

    Help with tables In a Form

    That worked!, Lets say I want the search box to filter other other attributes along with the contentNum
  6. C

    Help with tables In a Form

    syntax error when i do it like this: Me.Trackertbl_subform1.Form.Filter = "[ContentNum]='" & Me.Text2* & "'" Me.Trackertbl_subform1.Form.FilterOn = True
  7. C

    Help with tables In a Form

    I put this in the 'after click update' on the search button and it worked: Me.Trackertbl_subform1.Form.Filter = "[ContentNum]='" & Me.Text2 & "'" Me.Trackertbl_subform1.Form.FilterOn = True but how would i do it if i wanted it to make LIKE not just = this didnt work...
  8. C

    Help with tables In a Form

    Would I put that in the 'after update event' for the search box,
  9. C

    Help with tables In a Form

    Now i would like to use this search button to put what ever i search on top of the list in the table.
  10. C

    Help with tables In a Form

    like this: update got this error with that: Got it with this: DoCmd.OpenForm "NewErrorfrm", acNormal, , "[ContentNum] = '" & Me![ContentNum] & "'" Thanks for the help
  11. C

    Help with tables In a Form

    I would like to be able to click on these sub form records and have it open up a Editing_record form with the record that was clicked showing. Editing_record form:
  12. C

    Sum of a Report

    Works Great thanks
  13. C

    Sum of a Report

    =Sum(IIf([Job Type]="JL" or "JLS",1,0)) something like that
  14. C

    Sum of a Report

    Thanks that works , how would i count the total if i want 'JL' and 'JLS' totaled.
  15. C

    Sum of a Report

    But i want to just count the records with [Job Type] 'JL' not all the the records
  16. C

    Sum of a Report

    What would i put as a field name in After the IF True statement i just want to count all the JL in that row in the report =Count(IF([Job Type]="JL"),COUNT,DoNothing) Or =IF([Job Type]="JL"),COUNT,DoNothing)
  17. C

    Sum of a Report

    I would like to count just the total of 'JL' in each row. right now i can only to get it to sum the total. Any help would be appreciated.
  18. C

    Connecting to a Google Sheet

    I would recommend exporting all your access tables to excel spreadsheets. Then from there you can import those excel spreadsheets into Google spreadsheets. Good luck,
  19. C

    Form is passing a '0" to Report when combo box is left blank on form

    do the three fields that are doing this all have the same field type
  20. C

    Form is passing a '0" to Report when combo box is left blank on form

    I would recommend trying to set a default for those fields in the form as a space (" "):go to property box and set a default
Top Bottom