Re: Trackinng Volunteer Hours

Thank you Steve. At the risk of sounding like a dufus again.... I am
assuming I need to create the relationships betwen the tables first. Any
advice? I'm going to owe you!!!!

"Steve" wrote:

1. Use a form/subform to record the dates any volunteer worked on a
project. Base the main form on TblProject and base the subform on
TblProjectWorkDate.

Create the main form based on TblProject. Create another separate form based
on TblProjectWorkDate. Click on Windows - Tile Vertically so you see the
main form in the left pane and the other form in the right pane. Click on
the form in the right pane and drag and drop it on the form in the left
pane. Close the right pane. Open the form/subform in design view, select the
subform control in the main form, open properties to the Data tab and make
sure the LinkMaster and LinkChild properties are set to ProjectID.

Use same routine for other form/subform.

Steve



"BamaGrad2000" <BamaGrad2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F08F26C-5056-42E3-812F-0DC69CFE5391@xxxxxxxxxxxxxxxx
Thank you Steve. At the risk of sounding like a total dufus..... Is
using
the forms and subforms fairly self explanatory? I used to a lot of work
in
Acess, but it has been a while and I fear that I have gotten quite rusty.

"BamaGrad2000" wrote:

I am the Treasurer for a Habitat for Humanity affiliate. I am trying to
create a database to track the hours worked by our volunteers. I have
already creaed the Volunteers table, but am unsure of next step. Can
anyone
help?



.

Relevant Pages

  • Re: Trackinng Volunteer Hours
    ... Base the main form on TblProject and base the subform on ... Create the main form based on TblProject. ... main form in the left pane and the other form in the right pane. ... already creaed the Volunteers table, but am unsure of next step. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: adding sub forms using existing forms
    ... Go to Window - Tile Vertically. ... right pane, find the form you want to make into a subform on the form in the ... Click and drag the subform and drop it on the main form. ... Click on the subform control, open properties, go to the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sorting addresses in preview pane
    ... composition window, when you click the TO icon you get the pop-up address book. ... > ..uuhhh <steve thinks fast while trying not to look stoopid> What name ... All I have in the pane is the column of names and no other columns. ... >> Ascending Last name, Descending Last name, Ascending First Name and Descending First ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Sorting addresses in preview pane
    ... ..uuhhh <steve thinks fast while trying not to look stoopid> What name ... All I have in the pane is the column of names and no other columns. ... > Ascending Last name, Descending Last name, Ascending First Name and Descending First Name. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: LoadLibrary failed with inetcomm.dll
    ... "Patrick E. King" wrote in message ... pane or the full message and in an effort to restore normal ops I used the following:- ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
Loading