Search results

Count (grrr...) Hi, all. I don't know why this is complicated, but... I'm trying to count all records for which the value of a certain field is true (the field is a True/False data type). What I get is the total number of records, not just the ones with the box checked. I've tried all...

Hi all. I have a database in which each record has a corresponding MS Word file. I want to create a calculated field in a query that contains the filename with full path. Then, a button on a form to open the Word file associated with the record. I have the second part under control, but I'm...

Hi all. I have a database in which each record has a corresponding MS Word file. I have the code to open Word, but I'm having trouble creating a pathname from the separate bits of data that have to be strung together. What I have so far is: Path: Left([Dockets].[Month],3) & "\" &...

Hi. Here's what I want to do, but I don't know where to begin, and I don't even know if this is the correct forum I am using Access 97. I have a table containing information about articles to be published. The information includes contact info for the author(s), information about the article...

Hi. Another simple question, I hope. I have a field for email addresses. I want to validate the field so that any text placed in it must contain the @ sign. So far, I have had no luck with variations on the InStr function. On the other hand, I have no idea what I'm doing, so my lack of...

Hi. I hope this is a simple question. I am using Access 97. I want to count the number of records in a report. Access help says: 1 Open the report in Design view. 2 Add a calculated text box to the report header or footer. 3 To display the property sheet, make sure the text box is...