Same form, Different Input

[Phoenyxsgirl]

Odd question. I'm again trying to do what seems impossible but I know there has GOT to be a way.



I need to track attendance on multiple worksites. I need each worksite to get a form via email that they can fill out to let me know who worked and what hours.

The problem is that, if possible, I would like to make all the input to go to one table - instead of a different table for each worksite. So one table would keep track of each worker and the hours they worked. Where it gets complicated is that I need only those workers who are at the worksite to be available in that worksite's email form. Any ideas?

Oh, I also need this to be something where the worksite doesn't have to fill out a separate form for each worker and send me 20 emails. If possible.

[ssanfu]

This is another case for a junction table. My suggestion: you need at a minimum:

table: Job_sites
Job_sites_PK (AN)
other fields


table: Workers
Workers_PK (AN)
other fields

table: JobSiteWorker
JobSiteWorker_PK (AN)
Job_sites_FK
Workers_FK
HoursWorked
DateWorked

A query would select all of the workers at a job site.

[Phoenyxsgirl]

Ok so maybe I don't know enough about queries. Every time I make a query, it selects all workers and all jobsites. How do I limit it to just one worksite and all the participants working there?

[Phoenyxsgirl]

Ok UPDATE. I got the form figured out and it is working just perfect. Problem is that the Create Email option is not there. How do I send a CURRENT form out by email? If I could just get THIS form into their hands it would work - but its a subform of another form and I'm clueless.

[ssanfu]

Ok so maybe I don't know enough about queries. Every time I make a query, it selects all workers and all jobsites. How do I limit it to just one worksite and all the participants working there?

In the query design grid, there is a row for CRITERIA. In that row for the job site column , enter the the PK for the job site.

To automate this:
You have a form called "Form1" (real creative, no?)

I was going to write all of this out, but I decided to make a MDB (A2K). See attached.....

[Phoenyxsgirl]

Ok so now I have encountered a new problem. I created a query and then created an email form to send out --- but when I go to process info from the form, the data doesn't show up in my database. I've checked every table and every query. Do I need it to be an action query in order to do this? or am i doing something else wrong? right now, its a simple query (I think LOL)

[ssanfu]

Ok so now I have encountered a new problem. I created a query and then created an email form to send out --- but when I go to process info from the form, the data doesn't show up in my database. I've checked every table and every query. Do I need it to be an action query in order to do this? or am i doing something else wrong? right now, its a simple query (I think LOL)

I haven't done anything with email from Access. You might look at

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

by Tony Toews


There are many other sites that have info about Access and email.