Search results

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

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

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

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

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

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

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

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

I have a data entry form that I want the current date to be automatically added. When I add this function to that field it returns the following error: ---------- You may have used a DoEvents, LBound, UBound, Spc, or Tab function in an expression. You may have used an SQL aggregate function...

I have a form that displays the filtered results of a search for a keyword - there is code that uses a where clause in a memo field. The keyword comes from a form that "collects and holds" the variable information. I want to be able to have a command button on the form to click and print a...

I want to use the "order by" property within a form. However, I want it to sort in descending order. How do I make that designation? I've tried adding DESC after the fieldname to no avail. Any other ideas? Thank you.

I have a subform which reflects all the action associated with a particular case. The main form (main case information) is sorted in reverse chronological order by the query that brings up those records that satisfy the search, i.e. keyword search based on file name. The subform is based on...

I have a Main form based on a parameter query for a keyword within a filename field. Within the query I sort by caseno=D as the query may return more than one record. Within the form itself, I have a subform which lists all the action associated with that caseno (master and child link is the...

I have a report that prints based on the results of 5 queries. The third query prompts w/ a parameter for the first day and the last day of the report period. Is there a way to get these two dates to automatically print in the page header of the report? FYI - Query 1 - Pulls all info...

I have several fields within my page header that can shrink and grow (mostly grow)- they are memo fields which include a filename and issue of the case. When these grow, the page header does not grow so therefore some of the fields below the growing fields are not displayed on the report. I...