Search results

Alright! Yes I see where it's headed. Great that it can be contained within the same query (I keep reading to make several queries and then combine, which I want to avoid at the moment). Thanks for the explanation, I think I can figure it out from there. Come to think of it, it might be...

Hello! I'm resurrecting this to see if I can get pointed in the right direction. :banghead: The solution above has been working great, but now that we have more data and more time has passed, we want to see how these numbers change month to month. So, I added a new column [Opened Date]...

Whoa! There's no way I was gonna get that. Yup, that worked perfectly. Thanks! -JC

It did!...but the numbers are off. I'm getting 85.02% for Issued which was 1566/1723 = 90.95% -JC

Hello! I have a table that records the status of cases submitted. I was able to count how many of each there are, and get a percentage, but it's wonky. The way I did it was by counting the number and adding a Totals row. Then I manually copy that number into the percent expression (literally...

Yes, fOSUserName is the one. I'm testing it on a copy of the database before I roll it out to the minions later tonight.

AHHHHH! IslaDogs: I see how that works. That form helped a lot. Micron: yes, it is bound. We don't care much if they manipulate this value (I doubt they would know where to even start), we just want to be able to follow up. TheDbGuy: I had gotten stuck creating the function, it gave me the...

Yes. Just like this.

Awesome, thanks. I open the form in Design View, select the field where I want the info and enter that snippet in "Default Value".

Yeah, that's what I'm tying to do. I put it there and I get the error.

Huh. That simple? Would that go in the default property for the field? If I do that I get a #Name? error.

Hello! Currently, in the database I'm working on, there is a field in the Cases table to document the initials of the person handling a case. |Policy | Client | Initials | Date Open |Category| Date Closed |Etc.| When a case needs to be opened, they open a form, enter the pertinent...

I...should've seen that. Why does it want me to type the whole thing? is it because the field is in two tables? Would it have been better to call one "Policy" and another "Policy Number" or just something different? Thanks, by the way, works like a charm. The minions are gonna love it. -JC

The first one: Private Sub Touchpoint_Click() On Error GoTo Err_Touchpoint_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Phone Calls Log" stLinkCriteria = "[Policy]=" & "'" & Me![CORREO INTERNACIONAL.Policy] & "'" ' DoCmd.OpenForm stDocName, ...

TheDBguy: It's giving me a compile error: "method or data member not found" and it highlights Me.Policy

Thanks! here's the code: Private Sub Touchpoint_Click() On Error GoTo Err_Touchpoint_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Phone Calls Log" stLinkCriteria = "[Policy]=" & "'" & Me![CORREO INTERNACIONAL.Policy] & "'" DoCmd.OpenForm...

Hello! I have two tables, one is the "Cases" which has a ton of fields, including: Policy, Name, Date Opened, Date Closed, Correspondent, etc. No duplicates allowed. The other table is "Phone Calls", which has, among others: Policy, Who Called, Relationship, Date/Time, Who Took The Call...

Good morning! I work in underwriting for an insurance company but also help develop solutions for modernizing the business. In short, we have gone from using paper, rubber bands, and manila folders to a digital, paperless environment. Part of that is maintaining several Access databases to...