Recent content by jco23

ideally, that would work, but users have gotten in the habit of using short names while others are using long names (e.g. IBM vs. I.B.M vs. International Business Machines vs. Int' Bus. Machines). we're in the process of cleaning some of that up, but this method works. this group deals with...

good suggestions - i'll make sure to do that. thank you!

this is helpful, but I already got something similar in another portion of my app. thanks!

I'm limited to just two characters for the start range, but I can make this work. FYI, I had to remove two double quotes from your code (the one after [start_range] and the one before AND). but after making that adjustment, I got it to work as expected. this was very helpful, thank you!

yeah, I've suggested that, but they want certain folks focused on specific companies as some are more complex than others.

thanks for the quick responses, CJ_London and GPGeorge! I suppose I should also mention that my current lookup method is just a dlookup: Dim companyF As String companyF = Left([Company_Name], 1) Me.Assigned_To = DLookup("[Analyst]", "[tbl_company_analysts]", "[first_char]...

the users of my app would like to auto-assign someone to a task based upon the first two letters of a company name. I currently have a table with each letter of the english alphabet (including numbers 0-9) and the corresponding assignee. for example: A: Stan B: Kyle C: Timmy D. Cartman E. Kenny...

that's a good thought, and just now tried that, but no changes. i have FireFox, Chrome, Edge (Default). I did not see a setting in Edge to change the default PDF app (only whether or not to open an online PDF vs. downloading it). this is very frustrating.... I am noticing that Adobe Reader DC...

thanks for the detailed explanation. i confirmed that the default pdf app in settings-> apps is Nitro (see attached screenshot). I doubt that I need to adjust the others? I would be fine with the shell approach, but I don't know why Nitro thinks I want to convert a PDF to a PDF. the hard part...

right, I tried numerous methods, but to no avail. i'm not giving up though. i appreciate the follow up!

understood on sendkeys not being optimal, but it works. i tried the sendkeys {ESC}, but that did not work either.

100%. the Nitro icon appears next to all PDF files. perhaps there's some sort of registry key? but I may not be able to edit it since our company locks it down.

I built an Access database app for hundreds of users. one functionality they want is to be able to extract certain text based upon keywords from a PDF document. my company uses Nitro Pro instead of Adobe (significantly lower cost for basically the same functionality). I was able to achieve...

just the standard mm/dd/yy hh:nn format. the XML output does give me that. thx.

ah, I was leaving out the "xml" from there. that does help, thank you. but still would rather NOT save the file to the user's CPU or network....