table filter

[smason]

i am trying to write some code that will open a table and filter it (in this
case all apps where the date in is >=01/01/2008

like this
Public Sub filter()
DoCmd.OpenTable ("[applicant tbl]"), acViewNormal, , "[datein]=>#01/01/2008#"

End Sub

where am i going wrong! i know i can do thisin a query but iam teaching
myself VBA pleae help

 

[Allen Browne]

Tables are just for storing the data. They are not the interface.

Create a form (in datasheet view if you want it to look like a table.)

Then open it like this:
DoCmd.OpenForm "Form1", WhereCondition:="[datein]=>#01/01/2008#"

 

[smason]

excellent thanks for that

Tables are just for storing the data. They are not the interface.

Create a form (in datasheet view if you want it to look like a table.)

Then open it like this:
DoCmd.OpenForm "Form1", WhereCondition:="[datein]=>#01/01/2008#"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

i am trying to write some code that will open a table and filter it (in
this
case all apps where the date in is >=01/01/2008

like this
Public Sub filter()
DoCmd.OpenTable ("[applicant tbl]"), acViewNormal, ,
"[datein]=>#01/01/2008#"

End Sub

where am i going wrong! i know i can do thisin a query but iam teaching
myself VBA pleae help

 

[smason]

Hello

how would i use a filter like this "DatePart("q", [datein]) = 1"

Tables are just for storing the data. They are not the interface.

Create a form (in datasheet view if you want it to look like a table.)

Then open it like this:
DoCmd.OpenForm "Form1", WhereCondition:="[datein]=>#01/01/2008#"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

i am trying to write some code that will open a table and filter it (in
this
case all apps where the date in is >=01/01/2008

like this
Public Sub filter()
DoCmd.OpenTable ("[applicant tbl]"), acViewNormal, ,
"[datein]=>#01/01/2008#"

End Sub

where am i going wrong! i know i can do thisin a query but iam teaching
myself VBA pleae help

 

[Allen Browne]

That should be okay, except you have to double-up the quotes inside the
quotes:
"DatePart(""q"", [datein]) = 1"

If you find it easier:
"Month([datein]) Between 1 and 3"

More details about quotes inside quotes:
http://allenbrowne.com/casu-17.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hello

how would i use a filter like this "DatePart("q", [datein]) = 1"

Tables are just for storing the data. They are not the interface.

Create a form (in datasheet view if you want it to look like a table.)

Then open it like this:
DoCmd.OpenForm "Form1", WhereCondition:="[datein]=>#01/01/2008#"

i am trying to write some code that will open a table and filter it (in
this
case all apps where the date in is >=01/01/2008

like this
Public Sub filter()
DoCmd.OpenTable ("[applicant tbl]"), acViewNormal, ,
"[datein]=>#01/01/2008#"

End Sub