Recent content by xBirdman

Thanks Pat. The original PK's (multifield matching) were a mess, and created all kinds of errors when people entered erroneous case or sub-case numbers. I'm trying to 'fix' all of that as much as possible for the remainder of the anticipated lifespan of this database which is already a few years...

This worked this time, so I must have set something up the first time I ran it and thought I'd done it this way. I do have a follow-up question, for information only. This new table is the one side of a one:many relationship with another table, clientInfo. I had to add the foreign key field on...

Thanks for the responses fellows! I'll give these a run-through once I'm over the e-mail hurdle from being out for a week. I believe I tried both the suggested options above, but neither would work. It is highly probably I didn't ask SQL nicely enough... or precisely enough. Once I get some...

I have an historic table that should have been two (at least) because it mixes clients and cases. We have pulled all the clients, cleaned them as much as historic data allow, and deduplicated them. They are currently sitting in a spreadsheet. There is a second dataset that contains the links...

Thanks to everyone for input and suggestions. I was able to go directly to the server and use T-SQL to update all current nulls to 0. Next week I should be able to get the gate-keepers to run an update script which will set the default value to 0 for all future entries. Once the lock value is...

Okay, this makes a great deal of sense, and as you explain it I almost hear echoes of something I've read along those lines in the past. I will go directly to the server side and run the select in T-SQL and see if I get the same records, and if so I should then be able to do the update there...

I am the proverbial problem child in these scenarios... LOL. The 'test' database is just an older version of the live one moved onto a test server by our data security office so has all the same confidentiality concerns. And it is a linked database - back end is on an SQL server. It does seem...

Thanks, and yes, I had headed down this path. I believe what I have found now by running a dozen different scenarios, is that for some reason, although the yes/no field is showing 0, they are actually null, and thus not being filtered properly. I cannot for the life of me figure out why, but I...

I have the form set up so the record pointer 'should' only be able to see the current record. You can't move off the form to a new record and there is no way to add a new record from this form. It only pulls the single desired record into the form space. The other thing confusing me is that...

Thanks. Unfortunately this is a secure, legacy database with classified personal information in it. It is pretty complex and I'm not sure how I'd remove confidential info and maintain enough functionality. I appreciate the offer but I'd be breaking all kinds of laws by attempting to share even...

I need to update related records after a user updates the core record. Assume there are three related records. The user accesses a form and updates record X. When the user clicks "close" a set of VB scripts runs. A bunch of TempVars are created from information in record X. Two queries are run...

In this case after it was pointed out, I knew exactly what to do to fix, but in many cases I still need an example or assist to get things working just right. However, just being willing to engage with folks and try to help is always a positive. And appreciated. Cheers!

Good grief... you know how sometimes, under stress, you get too close to things and can't see the obvious? I think every other time I've used that type of condition it involved string variables and therefore I just grabbed my pre-existed code and popped it in. Thanks DBguy!

I have an access multiple item form that pulls a list of related cases for the user to view and edit. Selecting a specific record, the user can open that case to edit information on a screen showing the entire record. It has worked smoothly until this morning it didn't. I had it set as an...

And works like a charm now. Thank you much. I can now move along with my Monday to do list...