Search results

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...

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...

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...

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...

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...

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).

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...

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...

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...

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...

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...

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...

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.

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...

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...

I've also tried deleting via recordset.delete method, and I still cannot delete the record in the ACCDE version while I can in the ACCDB.

Yep, they are linked, but it works in ACCDB version, just not ACCDE version. Following up on my saved Delete Query experiment... I'm using a tempvar variable to store the record's Primary Key, but when VBA executes the query, I get a "Too few parameters" error. :banghead: Delete Query looks...

They're on the related record on the subform. Example: Parent Form is on record called "Shapes" Subform (in datasheet view) shows the following records: Square, Circle, Triangle, Rectangle User selects the "Square" record (highlighting the entire row) and hits the delete key on the keyboard...

I have a front-end database that I deploy as an ACCDE for the end-users. When a user deletes a record within a subform, it'll prompt and ask if they want to just "unlink" the child record from the parent record or if they want to permanently delete the child record. If they choose to delete...

Alternatively, you can also store it in TempVars: http://www.utteraccess.com/wiki/index.php/TempVars.