RE: MSACCESS - SUB FORM

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It's not clear to me exactly what you want to show. Your 2 tables seem set
up to track documents and relate them to employees who I assume are
responsible for writing or approving them, and then forwarding them on to
someone else. The 4 buttons you mentioned,
- DUTY TRAVEL
- EXIT RE-ENTRY REQUEST
- REQUEST FOR GOODS
- VACATION REQUEST
, seem to relate to the type of document in "TABLE_2". Is this true? If
so, I suggest adding a field to TABLE_2 that identifies the document. Also,
more suggestive names for your tables wouldn't hurt, for example "Employee"
instead of "Table_1".

If I'm correct, once you've added a field that identifies document types,
you can apply a filter for each of the buttons that will display only the
documents of the desired type. You might want to use the Switchboard Manager
to save time & effort setting up the buttons, each of which could display a
different Form.

"Kutty" wrote:

> I have designed a program in msaccess about file tracking for my office.
> Table_1 : EMPLOYEE ID --------------------------NUMBER
> EMPLOYEE NAME----------------------TEXT
>
> TABLE_2 : EMPLOYEE ID----------------------- NUMBER
>
> DOCUMENT TRACK# AUTONUMBER
> EMPLOYEE DOCUMENT SERIAL#----TEXT
> TYPE OF DOCUMENT-----------------TEXT
> FORWARDED TO ---------------------TEXT
> FORWARDED DATE-------------------DATE/TIME
> NOTE---------------------------------- MEMO
> PRIMARY KEYS: EMPLOYEE ID, DOCUMENT TRACK#
> Table 1 is main form, Table 2 is subform. In Main form I need 4 buttons.
> That is : DUTY TRAVEL, EXIT RE-ENTRY REQUEST, REQUEST FOR GOODS, VACATION
> REQUEST. Once I press the button I have to get a new form. The
> database under every buttons out of 4 buttons will be different. Please
> tell me
> how can I design this four different windows to get once I press each button.
> Would appreciate your great favor.
.

Relevant Pages

  • Re: Ideas or direction needed for approval path
    ... is the organizational hierarchy of your organization currently stored? ... assuming that each person only has to pass their request to one person ... This is the process that an employee would go through to get vacation time ... their supervisor (the supervisor will be notified by e-mail about this ...
    (microsoft.public.dotnet.general)
  • Re: Ideas or direction needed for approval path
    ... allow employees to request personnel actions (for example, ... This is the process that an employee would go through to get vacation time ... The employee would log in to a web site and click on a menu ... their supervisor (the supervisor will be notified by e-mail about this ...
    (microsoft.public.dotnet.general)
  • Re: Risk of Redirecting Email.
    ... I have seen on some clients of mine, that when an employee leaves the ... they request IT to redirect their emails to a particular ... there would be nothing keeping the former employee from sending ...
    (Pen-Test)
  • Re: Missing Fields from report
    ... then created a form based upon the Request table. ... the requesting Employee table are Employee, Extension, Department. ... in my Request table nor in any reports I generate listing the requests. ...
    (microsoft.public.access.reports)