Recent content by trstorer

Thank you, plog, for answering my question - spot on! I had explored InStr but wasn't thinking of adding the criteria part. It works perfectly in a normal database; however, it still is not working using c-treeACE ODBC. Ugh !!! So, now it is back on the vendor with a different error message...

I have a MS Access 2010 database linked to Practicemaster (Tabs3) legal case management system using FairCom c-treeACE ODBC - 32-bit version. I use the Access database for queries and reports. When I upgraded from Version 17 to 18 of PracticeMaster (and the ensuing ODBC driver), the software...

jdraw - Thank you for your prompt response, good idea, and valuable link. I started out thinking one way and the reality is I need to revamp my approach (for the better in the long run). Thanks again.

I have a number of reports set up this way. Report - Record Source = qryClosedCases based on two parameters – [Enter BegDate] and [Enter EndDate] I ran into a snag when I wanted to add DCounts to the report footer as a snapshot of activity. DCounts don’t work with parameter variables...

Thank you for the information. You are correct, there was no records in the underlying record source - a query. I had based the subform on a query because I had fields from two different tables displaying on the subform. However, once I reverted back to using the table as the record source...

I have a data entry form and subform (frmGENDataEntry - based on main tabl e with file information + frmGENClaimSubDE - based on sub table with additional information about file if it is strFType=Claim). For lookup and editing purposes, I have a main form (frmGENREsults) which has a subform...

I'm having trouble with a DB that I've been using for four years in a multi-user environment. (Windows XP; Access 2000; Novell Network) Started with one user as she got a new WinXP PC (had Win2K - not totally convinced that she didn't have the problem before the new PC); she wasn't able to do...

I am attempting to send a report via e-mail by using the File - SendTo menu option. I have been able to do this some time ago, but my PC has undergone a number of changes and now I get this message. Civil Litigation database can't send a message for the reason stated in the preceding alert...

I have a hyperlink in a form which is automatically filled in from a previous form field entry (directory structure and extension always remain the same). The hyperlink works great, but opens up a second instance of WordPerfect 9.0 if the user already has WordPerfect 9.0 open. It would be...

Thank You ! That's exactly the "direction" I was thinking of going, but just didn't grasp the logistics of code and where to put it. I did insert the # sign before and after the text to insert and it links just fine. It seems to be working great. Thanks, again!

I have successfully included a hyperlink field in a table which opens up a WordPerfect file. The entry in the hyperlink field identifies the path, filename, and extension. The path will always remain the same as will the extension. The filename is the same as a previous field entry on the...

Thank you, Rich. Just when I thought I had tried everything - even that one! Sometimes the second time is a charm - and probably on the right control helps too. I appreciate your help.

I have a report - based on a query - that needs to be sorted, first by Department; then by Inspector; then case name in alphabetical order. I can get the first sort to work OK as well as the second sort on the Inspector. But, I also need a new page break after each Inspector. I have tried a...

David R. - thanks for your reply. I was afraid it might not work. I appreciate your suggestions. Generally, we aren't ever using the CaseId to find the information. Usually doing a keyword search in the "description of the document" field. Thanks again.

I have a data entry form with a field (casename) that automatically fills in using DLookup (from master table) when a user fills in the Case ID #. However, there are situations where there is not a Case ID # - in which case I want the user to be able to add the casename info manually and store...