Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SimRick
  • Content: Threads
  • Order by date
  1. SimRick

    macro error

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

    Outlook public calendar html and printing problem

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

    Count Unique Records in Query

    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))...
  4. SimRick

    Log Attachments?

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

    bold Counting Records

    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]...
  6. SimRick

    ASP Query Parameters

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

    Data Access Page Parameter Question

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

    Simple Query Not Working

    The parameter query looks like this: SELECT [Orientation and Med Course].Name, [Orientation and Med Course].[Class Name] FROM [Orientation and Med Course] WHERE ((([Orientation and Med Course].[Class Name]) Like [Please Enter A Class Name])); I can see the results I want when I filter by form...
  9. SimRick

    One Report From Several Queries?

    I want to create a report that shows the result of 5 different parameter queries, each from a different table. The parameter is the same (last name, first name)in each query. How can I do that without entering the parameter 5 times? Thanks

Part and Inventory Search

Back
Top