Search results

  1. C

    Code to check if query returns any records

    Thanks guys. Sure I will check this out.
  2. C

    Code to check if query returns any records

    I will gladly input something like that if it will increase reliability, if only you could supply me with proper synthax.....:o
  3. C

    Code to check if query returns any records

    Dave, you are gineus. It did the trick and works great. Another case solved. PS. Since you asked, those queries are append queries and they transfer some data from one of table to 3 different ones to have separate data for each week. It's pretty complicated to explain full process I'm doing...
  4. C

    Code to check if query returns any records

    Thanks KenHigg. It probably could, but I forgot to mention that I'm not so fluent with figuring out VB code, bigginer here :( Should probably go something like: Dim RCount As Long RCount = DCount("Qty_per_Sheet", "qry_qtypersheet_check","IS NULL") If RCount > 0 Then MsgBox "Some Part...
  5. C

    Code to check if query returns any records

    Hello there. I have a UNION query called qry_qtypersheet_check with two fields [Part_No] and [Qty_per_Sheet], it pulls data from 3 different quaries and show records WHERE Qty_per_Sheet IS NULL. For database to process information properly, every Part_No needs to have Qty_per_Sheet assigned...
  6. C

    Hello & Thanks

    Hello everybody. I just wanted to say HI as I'm new member of this community. :D I also wanted to say BIG THANKS to you all for wonderfull job you're doing as I found here solutions to many of my access problems.
Back
Top Bottom