|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
September 29th, 2006, 04:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Form design wizard won't separate fields from form and subform
I have "employeeID" set up as the primary key and this field is in the
properties box for the master and child fields. "Klatuu" wrote: Do you have the Link fields set properly in the subform control? "scubadiver" wrote: that is correct. I have the records I want in the query but in the form I get every record for every employee! "Klatuu" wrote: it should be okay in the query. Are you saying when you run the query by itself it works, but when you use it a a record source it does not work? "scubadiver" wrote: The restriction is in the query. Do I have to put it in the form instead? Whereabouts would it go? "Klatuu" wrote: Where in the form do you have it? "scubadiver" wrote: I am halfway there. I do have another problem. In the query I have the following restriction on the date: =DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date()) It works ok in the query, but in the form it is still producing a record for every week. 
|
|
#12
September 29th, 2006, 04:38 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Form design wizard won't separate fields from form and subform
Sorry scuba, I think my tank just went dry. Without it in front of me to
tinker with, I don't see the problem. "scubadiver" wrote: I have "employeeID" set up as the primary key and this field is in the properties box for the master and child fields. "Klatuu" wrote: Do you have the Link fields set properly in the subform control? "scubadiver" wrote: that is correct. I have the records I want in the query but in the form I get every record for every employee! "Klatuu" wrote: it should be okay in the query. Are you saying when you run the query by itself it works, but when you use it a a record source it does not work? "scubadiver" wrote: The restriction is in the query. Do I have to put it in the form instead? Whereabouts would it go? "Klatuu" wrote: Where in the form do you have it? "scubadiver" wrote: I am halfway there. I do have another problem. In the query I have the following restriction on the date: =DateAdd("ww",-3,Date()) And DateAdd("ww",-1,Date()) It works ok in the query, but in the form it is still producing a record for every week.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
