Search results

I spent the day yesterday redoing all of those short text fields in the various tables, their references in queries, and the associated things on forms and reports, and everything seems to be operating as desired. thank you for pointing me in the right direction.

I'm looking around access world here, and apparently I shouldn't be using lookup for clean text in tables, just forms, i'll putz with that for a bit.

Yes, i've run into that; I may re-engineer that. So I think my brain is starting to recall; I had this problem before, which is why I switched it to short text, not realizing that I broke it in the process. That RoleID field below is a test field I made in order to try it out. Unfortunately...

This is the problem here, yes? The Short Text being the datatype rather than the number?

Agreed. I thought I was doing this, but just displaying the description. This will need to be changed in the tables, right? How can I start untangling this?

Hey everyone. I've been working in and out of Access for a few years now with varying degrees of knowledge and know-how, but not consistently enough to retain a lot of the more advanced stuff, unfortunately. Anyway; I recently made a database in order to better keep track of employees and...

Any way to plug that into an expression, or otherwise use it in a query?

Is there an expression that captures the above logic statement?

I'm definitely open to a design change, however, I'm afraid i don't know how to do anything of what you just said. I go so long between database creation that I have to relearn things as I do them; and this is a bit more complex than I've ever made up before. That said, the role-based scheme...

I appreciate the feedback. I literally just started putzing with Dlookup yesterday, and i'm not sure that I have for over a decade since, so don't have any idea what you're saying, regarding the string variable. I left the domain name prefix on there mostly for my benefit, since I'm still...

Hi Minty, see if this works: I want my 'Manager' field to fill in based on the managing role. If the 'managing role' is 'branch manager', then the Manager field must fill in with the name of the person that has been assigned as a branch manager at the same location. So in the above example...

Good morning, everyone. Here's what I have going on. I'm building a database that, among other things, contains an employee database. Aside from the usual first name, last name, username, etc, we have employee roles, which is one of my records that needs to be searched, as well as location. I...