Search results

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

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

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

I hate to ask this question, but I'm getting nowhere fast. I have a straightforward combobox based on a table. I need the values available on the form to be filtered by a second field in the table so that if one condition is met, a tempvar takes on a value, and in all other cases, it takes on a...

Sorry for the long post, but I preferred to try and give enough info to try to head off obvious questions. I have a data table that should be at least two tables, but due to the history and limited future (~2 years) of the database it isn't worth a full overhaul. The table contains Cases...

I'm trying to clean up a long-used database that hasn't been the most well-maintained. One really tedious aspect is the hundreds of queries that have been built, run a time or two, and then just left abandoned like so much scrap. Doesn't anyone know of an automated method for basically...

Hi gang, opinions requested. Maybe I just haven't figured out how to search correctly for this idea... The short: Because of serious constraints on my ability to make structural changes to a database I'm responsible for I'm trying to build ways to modify my data as needed. In my current...

I must create a sequential case number based on the previous case in the series. I have multiple series, e.g., AA, BA, XYZ. Each series is coded by two-digit year, and sequential number. Some series have 4 digit numbers and some series have 3 digit numbers, so the first AA case for 2019 would be...

Hi guys, I'm trying to do what I thought would be very simple, but... I added an unbound textbox to a form. The user will enter the 4 digit year into the box to filter an underlying query. 95% of the time, the year will be the current year, so I'd like to set that as default for the field...

Hey gang. Interesting idea - having everyone introduce themselves. I'm a research analyst and data manager in Oregon, USA. I used to be a bird biologist but shifted into a non-academic analyst position for all the right reasons. I'm responsible for an old, very poorly designed database...