computer science - project
juicywang
go_a01_grader_h3_construction.accdb| ID | Title | Start Time | End Time | Location | Description | Attachments | mSysRowId |
|---|
| 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 | lcvSHezS+Lp4CQ3M+1T0wYvB7jEeDnD7+QsBA1XaCN0=-~7+RdETpPn6PXQTBUL1Sptg== | ||
| 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 | wOiAf/aIQvP1yLRohtQlt4pH9yAKJcA7GTtryIeB2Kw=-~nc9t0cVq5bvrLoEWPAnmqw== |
| ID | mSysRowId |
|---|---|
| 1 | lejxQptHD6/xQ7RQe2KMwdfqvFSR34lkriT4BTGs2EM=-~LQ6V+jiABKbR2ZUx8whB3g== |
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));
