Search results

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

I have a 'lookup' table regarding file types which includes a field for a retention schedule. The CkYear field holds a whole number to be used in calculating the year that the file needs to be reviewed for disposal. I want to add that number (which is different depending on the type of the...

Works like a charm - thank you ! Don't know what I'd do without the quick and accurate responses from this forum !

I have a tab control on my form. I have attached code to my "filetype" field which opens up the respective tab based on the "filetype". This works fine for data entry, but when I use the form for inquiry (based on a keyword in another field) and it returns multiple records, the appropriate tab...

Thank you to all who replied. I had tried NOW() and got the time, but didn't really want that, but also did find another post which made reference to "newer PCs" not handling DATE(). They recommended using =DateValue(now()) which (so far) has done the trick. This is a great forum and has...

I have a file index database. I have a form with a tab control on it with each page representing additional fields tied to different types of files. For example, "claims" is the first page with unique fields specific to Claims, the second page is "collections" with it's own specific fields...