Search results for query: *

Thank you. That worked perfectly. I've been trying to use double quotes rather than single quotes.

I have a contacts database that stores phone numbers. The text box where these numbers are added and modified has the following input mask: "(###) ###-####" These phone numbers along with other information are queried to list boxes. Each number appears without the parentheses, space and...

Sorry Steve, I'm a little slow. I'll try to help. What does your existing code look like that queries the list of records that fall within the date parameters? Are you looking for one summary total of the detail queried in the existing list?

Steve There is probably a better way, but I've encountered the same problem and elected to use a list box rather than a text box to display summary totals. A list box has a rowsource property to perform queries unlike a text box. I haven't tried the following code yet but it should be...

Have you check to see if there has been an odbc (Open Database Connection) link created to the database from another file? If the file resides on your local hard drive, you can restart your machine and sever all links to the file. John