Search results

  1. M

    Solved find missing date gaps

    Sorry for the lack of tables again, must remember to add them back if i split em. but yes works a charm, again thanks :)
  2. M

    Solved find missing date gaps

    i know solved but have one last question in this regard could the query you made, be altered also to look at dates missing based on today's date as I'm a bit behind in work and haven't been updating it on time, but still says missing only up to 21/6/20 but today's the 3/7/20 and i haven't...
  3. M

    Solved find missing date gaps

    and it looks epic
  4. M

    Solved find missing date gaps

    sir that is a very elegant solution, much better than mine, thank you and to all who put in there ideas
  5. M

    Solved find missing date gaps

    SELECT DISTINCT Main.Dt, DtChecker.Dt FROM Main RIGHT JOIN DtChecker ON Main.Dt = DtChecker.Dt WHERE Main.Dt Is Null ORDER BY Main.Dt; works and shows me the missing dates as seen here
  6. M

    Solved find missing date gaps

    oopss let me re attach the tables, sorry query working on is Query 1
  7. M

    Solved find missing date gaps

    ok but like you will have to read it on my phone on break as looks like blocked on works PC, boo
  8. M

    Solved find missing date gaps

    OK, but again how would that work ? sorry if im being daft see current DB, but the pdfs wont open sorry as on shared drive here at work
  9. M

    Solved find missing date gaps

    so have a front end which is just used to find and open a PDF file, bit quicker and better looking then searching through file upon file. but have come upon a question that I'm sure can be answered by you smart lot, have searched here but didn't find anything on the subject. but what i would...
  10. M

    Solved If a record is null

    i have read it at least three times and im not sure i understand would you mind showing what you mean just use my previous attached db
  11. M

    Solved If a record is null

    sorry i have read that one again, so you would have an extra text box which had "NO IMAGE" also for current code see attached
  12. M

    Solved If a record is null

    but one last thing, if i put in the coverimage part of the table "NoImage", which is the name of the image in the gallery for when i have no image yet, for the rest of my records all it shows is the NoImage even if i had an image, why ??
  13. M

    Solved If a record is null

    smart and done try half life
  14. M

    Solved If a record is null

    I did and thanks for the Nz idea
  15. M

    Solved If a record is null

    like this Private Sub cmbWho_AfterUpdate() Me.txtPlatform = DLookup("[Platform]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Platform Me.txtYear = DLookup("[Released]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Release Year Me.txtRegion =...
  16. M

    Solved If a record is null

    tried that with a blank image but then it just kept showing the same blank image even though have one image for 688 attack sub
  17. M

    Solved If a record is null

    Hi Folks trying to get a picture to display, pictures will be held in the DB in a gallery. If no image present then just want it to display the text like shown in attached image and also one with no image but when i do try search for one with no image, get the ol' invalid use of null error...
  18. M

    New Project - But Invalid use of Null doing me in

    have tried that but not with much success as you can see if you check it out, file attached it puts the 100 in but then faults and points to the new bit of code, maybe got it wrong way round
  19. M

    New Project - But Invalid use of Null doing me in

    cheers on top of that i guess i could also have one which is not null, for the answers in the actual table and then wouldn't need lines of code for that as well ??
  20. M

    New Project - But Invalid use of Null doing me in

    this is code to check for the score which has a null check '---check for value of result If Not IsNull(DLookup("Answers", "tblQuestionChoices", "Answers = Team1Guess1.value ")) Then Team1Score.Value = DLookup("Score", "tblQuestionChoices", "Answers = Team1Guess1.value ") Else...
Top Bottom