Recent content by SimRick

I have a database that uses macros that open forms. One one specific form I get a message that network access was interrupted. I'm sure that it isn't t the network because it only, and always, happens with this form. Thanks for reading this, Rick It is a simple macro: Option Compare Database...

Thanks for your response, but unfortunately it is not a browser issue. I have tried IE, Mozilla, Chrome and Safari and it looks the same. I look at the code in Front Page and the second or third entries for the day are not in the calendar code, although they are in the details page. The code for...

Is the f: drive mapped locally or is it mapped for everyone? If it is mapped for everyone it shouldn't cause a problem. In Outlook, I can use the insert...hyperlink dialog and click the browse for file icon, then my network places, then entire network, etc. and it displays as the UNC. More often...

Is f: a mapped drive? Is it possible that links to mapped drives are displaying the drive letter and links to shares that are not mapped are displaying as a UNC? Rick Otto

We use Outlook 2003 and Exchange 2007. I developed a public calendar to publish a training calendar for the year. When I use the file...save as web page option it does not display anything after the first activity in a day in the html - I even looked in the code. The other problem is that...

Perfect, Thanks a lot. This forum is irreplaceable!

Thanks, but it didn't work. it should return 1 [Resident Involved 1] who had 3 reports, but didn't return any.

I have the following query: SELECT tblreport.[Resident Involved 1], tblreport.[Report Number], tblreport.[Report Date] FROM tblreport GROUP BY tblreport.[Resident Involved 1], tblreport.[Report Number], tblreport.[Report Date] HAVING (((tblreport.[Report Date]) Between Date() And Date()-30))...

Thanks- I hadn't thought of a public folder; I set the permissions so that everyone had write permissions but only administrators have read permissions. I created rules to forward messages with attachments to administrator and then delete all messages from the public folder. I really only wanted...

I would like to monitor outgoing attachments, especially .doc and .xls. I only need to log them by name and sender, not forward them. Has anyone figured out how to do this with Exchange 2000? I have tried GFI Mail Security, but the current version doesn't support logging, only blocking. I would...

I'm not sure why, but this query did not return any records even though I verified that it should return about 120 given the parameters I entered. Thanks for the ideas!

Thanks - the first query returned all records, as the [resident involved 1] field, which contains a name, always has a total value of 1. The second of your ideas generated an "Invalid SQL SDtatement - expected Delete, Insert, Procedure, Select or Update" message. I've tried many ways...

Thanks for the response...I get a syntax error - missing operator when I run it.

I want to alter the following query so that it only returns records for those [Resident Involved 1] who have more than 3 (or any number) records during the date range. Can anyone help? THANKS! Red TextSELECT tblmedreport.[Report Number], tblmedreport.House, tblmedreport.[Report Date]...

I got a lot of help with a question a few months ago and I'm back again. I am publishing some reports as data access pages on IIS server for our intranet. When I use a report that is based on a parameter query, I want the user to be able to enter a parameter much as they would do in Access...