Subform problem

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Guys,

I posted on the forms group but didn't get an answer yet, maybe I didn't give enough information. This is related to my "Hours people worked...." post below. Using Access 2000. I have a subform on a form. I used tabs on the form so this subform is on a tab. I have the subform set to the datasheet view. I can't add records but the records I entered in the table view do show up. Is there something in the properties of the subform I need to enable or do I need to go back to my tables and query set ups to find the problem?


Thanks,
Linda
 
LMB said:
Hi Guys,

I posted on the forms group but didn't get an answer yet, maybe I didn't give enough information. This is related to my "Hours people worked...." post below. Using Access 2000. I have a subform on a form. I used tabs on the form so this subform is on a tab. I have the subform set to the datasheet view. I can't add records but the records I entered in the table view do show up.
Click to expand...

******************************
You most likely have the additions property of the form set to no. Open the
subform in design view, click the properties of the form, on the Data tab,
ensure that the 'allow additions' is set to yes. You should now be able to
enter new records.
*******************************************************

Is there something in the properties of the subform I need to enable

(see above)

or do I need to go back to my tables and query set ups to find the problem?
Nope.
 
Hi Guys,

I posted on the forms group but didn't get an answer yet, maybe I didn't give enough information. This is related to my "Hours people worked...." post below. Using Access 2000. I have a subform on a form. I used tabs on the form so this subform is on a tab. I have the subform set to the datasheet view. I can't add records but the records I entered in the table view do show up.
Click to expand...

******************************
You most likely have the additions property of the form set to no. Open the
subform in design view, click the properties of the form, on the Data tab,
ensure that the 'allow additions' is set to yes. You should now be able to
enter new records.
*******************************************************

****************
****************
Edit, Additions, Deletions, and Data Entry are all set at yes. The record source is a query, does that matter?
***************
***************

Thanks,
Linda
 
Hi Guys,

I posted on the forms group but didn't get an answer yet, maybe I didn't give enough information. This is related to my "Hours people worked...." post below. Using Access 2000. I have a subform on a form. I used tabs on the form so this subform is on a tab. I have the subform set to the datasheet view. I can't add records but the records I entered in the table view do show up.
Click to expand...

******************************
You most likely have the additions property of the form set to no. Open the
subform in design view, click the properties of the form, on the Data tab,
ensure that the 'allow additions' is set to yes. You should now be able to
enter new records.
*******************************************************

****************
****************
Edit, Additions, Deletions, and Data Entry are all set at yes. The record source is a query, does that matter?
***************
***************

I think it has something to do with my query. I am posting the sql...I don't really know how to read it but I see that you all do and hopefully it will help. The add a record button is not available in the query either.

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate, TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas INNER JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID = TBLAreaWorked.WorkAreaID
GROUP BY TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate, TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID;

If something is wrong in here, if you could explain how to fix it using the query grid or the relationships window, that would be how I work at this point.

Thanks,
Linda
 
Nope shouldn't matter.

Can you add records when you open the subform by itself? Ie: not as a
subform of the parent?
 
NO : (

Linda

Nope shouldn't matter.

Can you add records when you open the subform by itself? Ie: not as a
subform of the parent?
 
are you sure you have checked the property of the subform and are not looking
at the properties of the parent form. Open the subform by itself (in design
view) and check its properties.
 
yes, the problem is in the query, and you used a good way to test it -
opening the query that underlies the form, and seeing if the same problem
shows at the query level.

my guess is that the GROUP BY clause is preventing changes to the query
dataset. suggest you open the query in design view, and on the toolbar,
click the Totals button (funny-looking capital E) once. or, in design view,
click View on the menu bar, and click Totals on the drop menu to remove the
checkmark next to it.

hth




LMB said:
Hi Guys,

I posted on the forms group but didn't get an answer yet, maybe I didn't
Click to expand...
give enough information. This is related to my "Hours people worked...."
post below. Using Access 2000. I have a subform on a form. I used tabs on
the form so this subform is on a tab. I have the subform set to the
datasheet view. I can't add records but the records I entered in the table
view do show up.

******************************
You most likely have the additions property of the form set to no. Open the
subform in design view, click the properties of the form, on the Data tab,
ensure that the 'allow additions' is set to yes. You should now be able to
enter new records.
*******************************************************

****************
****************
Edit, Additions, Deletions, and Data Entry are all set at yes. The record
source is a query, does that matter?
***************
***************

I think it has something to do with my query. I am posting the sql...I
don't really know how to read it but I see that you all do and hopefully it
will help. The add a record button is not available in the query either.

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas INNER JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID
GROUP BY TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID;

If something is wrong in here, if you could explain how to fix it using the
query grid or the relationships window, that would be how I work at this
point.

Thanks,
Linda
 
Yes. The properties of the parent are set at No for edits but the subform are all set to yes when it comes to data entry properties.....Linda
are you sure you have checked the property of the subform and are not looking
at the properties of the parent form. Open the subform by itself (in design
view) and check its properties.
 
Tina,

Thanks a million. That worked and the query I made to total up the times each employee works in an area is working too!

Linda


yes, the problem is in the query, and you used a good way to test it -
opening the query that underlies the form, and seeing if the same problem
shows at the query level.

my guess is that the GROUP BY clause is preventing changes to the query
dataset. suggest you open the query in design view, and on the toolbar,
click the Totals button (funny-looking capital E) once. or, in design view,
click View on the menu bar, and click Totals on the drop menu to remove the
checkmark next to it.

hth




LMB said:
Hi Guys,

I posted on the forms group but didn't get an answer yet, maybe I didn't
Click to expand...
give enough information. This is related to my "Hours people worked...."
post below. Using Access 2000. I have a subform on a form. I used tabs on
the form so this subform is on a tab. I have the subform set to the
datasheet view. I can't add records but the records I entered in the table
view do show up.

******************************
You most likely have the additions property of the form set to no. Open the
subform in design view, click the properties of the form, on the Data tab,
ensure that the 'allow additions' is set to yes. You should now be able to
enter new records.
*******************************************************

****************
****************
Edit, Additions, Deletions, and Data Entry are all set at yes. The record
source is a query, does that matter?
***************
***************

I think it has something to do with my query. I am posting the sql...I
don't really know how to read it but I see that you all do and hopefully it
will help. The add a record button is not available in the query either.

SELECT TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID
FROM TBLWorkAreas INNER JOIN TBLAreaWorked ON TBLWorkAreas.WorkAreaID =
TBLAreaWorked.WorkAreaID
GROUP BY TBLWorkAreas.WorkArea, TBLAreaWorked.WorkAreaDate,
TBLAreaWorked.WorkAreaHours, TBLAreaWorked.EmployeeID;

If something is wrong in here, if you could explain how to fix it using the
query grid or the relationships window, that would be how I work at this
point.

Thanks,
Linda
 
Back
Top