Search results

As I noted though, the database is very old (i.e. I didn't design it, just inherited it) and has a limited future use window as we bring a new system online over the next two years. I've been directed specifically to just increase efficiency for the users, but don't overhaul the system. I...

A case will always, by default, have an 'A' incident. It may then have 1-many more incidents that are ultimately wrapped in the same case, thus Inc.A is first, and sequentially Inc.B, Inc.C, etc. for as many incidents as are warranted. A good analogy is a court case. There are can be multiple...

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

It is funny that I had the same issue with another routine I'd built today, and the suggested "MS DAO 3.6" fix resolved that specific issue. So now I opened up the DatabaseObjects app it works like a charm. I think I'm dealing with front-end :: back-end differences. I built a mockup of the...

Wow, thanks. What a great tool. I need to dig around a bit - due to my older database, when I open the tool I get a Compile error: User-defined type not defined which points at: Public Function SetListBox(ObjectType As Integer) (highlighted) with the selection on Dim db As DAO.Database...

Some great and helpful thoughts. I have used the Dependencies function for those few which made me scratch my head, but I know that 96% of the queries are old and unused, so I'm very selective about adding that extra step - especially since, as a couple of you have suggested, I have a backup I...

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

A last thought to those of you who provided really helpful materials and feedback here. I've decided to keep the tables separate and just deal with the hassle of building out multiple lookup tables. My main concern isn't that I can't make it work for me, but I'm not 100% certain if I'll still be...

Thanks for the feedback. I don't quite follow everything here, but appreciate the overview as it allows me to think about best ways to achieve my desired outcomes. Cheers!

Exactly - and I've done this already in another context and it wasn't a headache to pass a short conversion after the filter and selection is made, before applying the value wherever I'm taking it. Definitely one of the drawbacks of the approach.

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

Thanks sxschech for the response and code. It looks very similar to what I ultimately cobbled together, though yours appears to be a bit more... elegant? I am just learning vb so don't even know a lot of the calls you include. Basically though, and I literally just finished working this out...

Brilliant. I think that will work. I'll have to monkey around with the code a little to make it flexible for the various different formats but I think I can make it work. Thanks!

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

Thanks. I wish I could as it would make some of my tasks so much easier, but I'm working behind serious security walls because it is very sensitive personal data. Worse, it is a very old database that was very poorly designed. I'll have to content myself with posting questions and trying to be...

SorryDBGuy, meant to include that I entered those expressions into the default value property of the textbox. As noted, this is a brand new text box that I've changed nothing about except the name. On a lark, I just created a second new textbox, and used the =Year(Date()) suggested by arnelgp...

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