Dear Lee V:
If I understand your question, you're trying to find a way to open from
a list of employees a timesheet that will allow someone, or the employee
to enter there punch time into a database and track those punches to
calculate there hours?
If that is what you're trying to do, can you show some examples as to
how you have setup the relationships between the employee table and the
timesheet tables and what fields are you using and what form is it on?
I need a little more information, because the option that you're
speaking of doesn't exist in the form that you're speaking of it in.
When you create a SQL statement within a query, you can use an option
that is at the top of every table that will allow you to put a (*) Star
symbol in the query to allow all Fields in a table to be displayed or
shown in the query that you create. This is not an option that is
selected from any form or macro.
Joe P.
-----Original Message-----
From: Lee V [mailto:
[email protected]]
Posted At: Wednesday, June 07, 2006 3:10 PM
Posted To: microsoft.public.access.macros
Conversation: Outputall fileds
Subject: Outputall fileds
I am trying to create a lookup for employee id to open a time sheet
entry
form using a filter in the open form in a macro. The form contains
several
tables. It says that if you use a filter and not all of the fields are
in
the filter, then to set the outputallfields property to yes. Where do I
find
this property?
