plog's latest activity

  • P
    plog replied to the thread 2 queries in one form.
    Words aren't going to work to explain this. We either need a sample database and precise instructions as to what you need where. Or we...
  • P
    plog replied to the thread Clear out data.
    Yeah, when building a house just slop some concrete in a hole, throw in some rebar and build on top of it. In a year or two--after...
  • P
    plog reacted to MajP's post in the thread Clear out data with Like Like.
    Something sounds very concerning. Unless you are building a commercial grade ERP I highly doubt this database is properly normalized...
  • P
    plog reacted to cheekybuddha's post in the thread Conditional Formatting with Like Like.
    @xavier.batlle 's suggestion in Post #3 will not work either (both "#1" and "#2" will be returned since they satisfy the other half of...
  • P
    plog replied to the thread Resurrecting old threads?.
    Agree with Isaac. If anything the warning should be to responders--people intending to provide advice to questions asked years ago.
  • P
    plog reacted to Isaac's post in the thread Resurrecting old threads? with Like Like.
    Is resurrecting old threads a bad thing? Especially if the poster has intelligently found a follow-up question to the exact subject...
  • P
    plog replied to the thread Solved Method of selecting specific records.
    1. The recordsource doesn't need to be a query, it only needs to be based on orders. 2. Order id probably doesn't need to be shown on...
  • P
    plog reacted to cheekybuddha's post in the thread syntax error with null values with Like Like.
    Yes - you are creating an SQL statement, so you need to explicitly put 'NULL' in there. Setting a field to the same value it is already...
  • P
    plog replied to the thread Solved Method of selecting specific records.
    You really haven't given us a great view into the ultimate aim of what you are really trying to accomplish. You've taken a few steps...
  • P
    plog replied to the thread Combined Queries.
    I would do a UNION that feeds a cross tab: 1. Make a simple query for each status. Be sure that all 3 queries have the same SELECT...
  • P
    plog replied to the thread Solved Select Last Record.
    With DMax() https://www.techonthenet.com/access/functions/domain/dmax.php
  • P
    plog replied to the thread Run Reports using VBA or Local table.
    I need better specifics to help you. My gut tells me a table might be the way to go after some revisions to your reports. But what...
  • P
    plog replied to the thread Run Reports using VBA or Local table.
    Maybe TABLE: the table would have fields: rptArea, rptName , strdisplayName , Reports(strReportName).Caption, Docmd.OpenReport...
  • P
    plog replied to the thread Television episode tracker.
    I think season would just be a numeric field in the episode table. If you have other pieces of data that go with a season but not an...
  • P
    plog replied to the thread Solved Inner Join Table Query Not Run properly.
    1. Non-null "Nulls". Your eyes cannot be trusted to see a null value. Just because it looks like there is no data in a field, doesn't...
Show older items
Back
Top Bottom