Recent content by cnstarz

  1. C

    Cascade Update relationship w/out a required record

    Is there a way to enforce one-to-many relationship with cascading updates without requiring the related table to have a related record? For example, how can I get a one-to-many relationship on [tbl_Colors].[Color_Name] (one-side) and [tbl_Cars].[Color_Name] (many-side) without every record in...
  2. C

    Does a join query lock both sides of join, or just the side w/field being edited?

    Just played with a test query and, sure enough, turns out editing a tlb_Effects_Memo field locks records on both sides of the query -- even if there are no fields from tbl_Effects in the query. Currently, I have a custom zoombox that opens when you double-click on a field: Private Sub...
  3. C

    Does a join query lock both sides of join, or just the side w/field being edited?

    I've run into a problem with memo fields locking out the record and preventing saves, so I've decided to just place all memo fields from each table into their own tables. For example, all the memo fields for tbl_Effects are now in tbl_Effects_Memo. My question is, if I were to make the...
  4. C

    Query for records that possibly match other wildcarded records

    This is what I have so far (qry_Targets_Orphans in the .zip I attached in the OP): SELECT tbl_Targets.* FROM tbl_Targets LEFT JOIN jtb_Affected_Targets ON tbl_Targets.Target_ID = jtb_Affected_Targets.Child_Target_ID WHERE jtb_Affected_Targets.Child_Target_ID Is Null...
  5. C

    Query for records that possibly match other wildcarded records

    Thanks jdraw, I know how to use LIKE, but I'm wanting to query ALL records where the Target Name is LIKE other Target Names in the same table. IE: baduser@baduser.com would be returned if there was a Target Name *@*baduser.com. Something like: LIKE [EXISTS (Select tbl_Targets.Target_Name From...
  6. C

    Query for records that possibly match other wildcarded records

    The Target_Name field is indexed, yes. I understand why splitting up the field into 2 fields might make sense, but it's just not a possibility right now (I was already looking into it before I even made this thread).
  7. C

    Query for records that possibly match other wildcarded records

    I appreciate that you tried to help, but you were rude with your response. I'm starting to see that most of the readers here aren't interested in just assisting with what's presented, regardless of how absent-minded it may appear to them, and would rather focus on the other small details of the...
  8. C

    Query for records that possibly match other wildcarded records

    I agree, we need to start whitelisting, and I've been preaching that for the last year, but that decision is far above my pay grade. This is an enterprise network consisting of over 500k mailboxes. We do utilize black hole lists, as well as white lists and various other ACLs. I appreciate...
  9. C

    Query for records that possibly match other wildcarded records

    Okay, let me run through a scenario. We will receive intel that there is a spearphishing campaign where actors from Country X are sending malicious emails with the following attributes: Subject: Your USAA Has Expired! Sender(s): bademail1@gmail.com bademail2@gmail.com bademail3@baddomain.com...
  10. C

    Query for records that possibly match other wildcarded records

    In this database, an email address is one piece of information. They are not company email addresses, they are external, 3rd party email addresses that we are wanting to implement blocks on (prevent inbound/outbound emails to/from said email addresses). Sometimes we'll need to block individual...
  11. C

    Query for records that possibly match other wildcarded records

    I have this database: As you can see, both of jtb_Affected_Target's foreign keys are linked to tbl_Targets.Target_ID. This allows me to relate targets from the same table as Children or Parents to other targets. Here is frm_Target (based on tbl_Targets): The subforms allow me to link...
  12. C

    Autobackup function for Backend

    You can create a table in the backend with one field called "KickUsers" where it's type is Yes/No. Then create a form in the front-end whose recordset is based on that table, and make the form hidden and load on Startup. Use the Form.OnTimer event to check if the "KickUsers" field is Yes. If...
  13. C

    Dcount->Run-time error '94'. Invalid use of Null.

    It might be worthwhile to look into creating a query instead and use Recordset.Recordcount or Count(*) instead of Dcount. Domain aggregate functions ignore null values and are generally slower than queries.
  14. C

    Using Joins vice Where-clause?

    I'm fairly proficient with Access (at least I like to think I am) and was reading Allen Brown's page on Optimizing Queries when I saw this statement: Could someone elaborate on this? How else would you create a multi-table query (ruling out subqueries) without the use of Joins? How would you...
  15. C

    Delete Query doesn't work in ACCDE version

    You can delete parent records provided you have cascade delete enabled in the relationships. It would delete the would-be child records automatically. That's why cascade delete exists, right? The thing is, the delete query works in the ACCDB version. It works. Just not in the ACCDE...
Top Bottom