GO16_AC_CH01_GRADER_1G_AS - Open Houses
Haafi C
go_a01_grader_a3_open_houses.accdb| ID | Title | Start Time | End Time | Location | Description | Attachments |
|---|
| ID | Object Type | Object Name | Filter Name | Filter String | Sort String | Default | Description | mSysRowId |
|---|---|---|---|---|---|---|---|---|
| 1 | 2 | Event List | Start Time = Today | (Year([Current Events].[Start Time])=Year(Date()) AND Month([Current Events].[Start Time])=Month(Date()) AND Day([Current Events].[Start Time])=Day(Date())) | false | zZIiqBHD+XnpeYbFuWKhX3H/QnjN34GPoYd87GiOlyU=-~7bhWiwd6i9R6/ic3gR+U5g== | ||
| 2 | 2 | Event List | Start Time = This Week | (Year([Current Events].[Start Time])=Year(Date()) AND DatePart("ww",[Current Events].[Start Time],0)=DatePart("ww",Date(),0)) | false | XH8qpXo09uzp7tka1EF9+Vg/DPLd52Gz+PyzK0nH6rI=-~L0rMhO6fs/xRz0KIaTzYKg== |
| ID | mSysRowId |
|---|---|
| 1 | nEgyZY5jmMO3xFIb4WG75DYdBx6f/9zNfpak82fO89E=-~X9w09qF8QmJn34SSBANJKA== |
SELECT "-1" as [ID], "(Manage Filters)" as [Filter Name] FROM Filters UNION SELECT "0" as [ID], "(Clear Filter)" as [Filter Name] FROM Filters
UNION SELECT ID, [Filter Name] FROM Filters WHERE ((([Object Name])=[Application].[CurrentObjectName]))
ORDER BY [Filter Name];
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*Subreport*") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;
SELECT Filters.ID, Filters.[Object Name], Filters.[Filter Name]
FROM Filters
WHERE (((Filters.ID)<>Nz([Form]![ID],0)))
ORDER BY Filters.[Object Name], Filters.[Filter Name];
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32768))
ORDER BY MSysObjects.Name;
SELECT DISTINCTROW *
FROM Filters;
SELECT *
FROM Events
WHERE (((Events.[End Time])>=(DateAdd("h",-24,Now())) Or (Events.[End Time]) Is Null));
