Size# Error, Repost from Report Section

[tarab87]

I'm sorry. I posted this in the "Report" section. After looking through the questions, though, I wasn't sure if that was the appropriate place for my message about errors. Now...


First of all, I am an extreme novice (have only been trying this for a little over a week). I have created a form for work orders. The work orders contain 2 tabbed subforms, one for Labor and one for Parts Used.On each subform, I have an "Extended Price" field that calculates the total for each Part used and the total for Labor for each task. Then, in the footer of each subform, I have a formula that sums the ExtendedPrice fields. In the form, I reference back to the SumExtendedPrice for each subform, and then, total the two. To return a 0 on null fields, I use the Nz function on the Form's references to the fields. This is successful (seemingly so) on the form. When I click the button I set up to take me to each Work Order's invoice, I have a "SIZE#" error in the report's references to null Labor or Part totals. On the form, this is not so; it only does this on the report. However, when I do a "Print Preview," the field will read $0.00, and it will total. Why, oh, why does it do this? Help me, please! Thank you!

[June7]

Here is possible cause https://www.accessforums.net/access/...ize-34736.html

That is a circular reference.

If you want to provide db for analysis, follow instructions at bottom of my post.

[tarab87]

Here is possible cause https://www.accessforums.net/access/...ize-34736.html

That is a circular reference.

If you want to provide db for analysis, follow instructions at bottom of my post.

Hey, I don't think that it is a circular reference. Oddly, it reads SIZE# in report view (well, besides the fact that my subforms disappear); in print preview, it shows $0.00. This happens when the subforms are blank.

[rzw0wr]

Tarab,
Can you post what forms and reports you are have a problem with.

Dale

[tarab87]

Tarab,
Can you post what forms and reports you are have a problem with.

Dale

Yes, of course! I'm sorry. I can't believe I forgot to mention that. The problem is with the "Invoice" report. Parts Used and Labor are subforms on the report. I need the totals (I have text boxes in each of the footers) to be placed on the report. When the subforms are empty, it gives me the #Size error.

[tarab87]

You can access the invoice through the WorkID form.

[rzw0wr]

How do you get parts into you parts form?

[tarab87]

How do you get parts into you parts form?

I enter them into the Products form. I named it Products for some absurd reason. I'm not sure why. Anyways, I linked an "Add Part" button to the Orders form (which is how I enter in orders we place for parts). Please don't laugh at my lack of Access skills. I've only been doing this for a week or two (the most frustrating weeks I've ever had, if I must say so myself).

[rzw0wr]

OK, I figured that part out.
The form is set for "No Additions"
After I select "Add Part", how do you get them on the form?

[tarab87]

Yes, I've just fixed that. On the work form? The invoice is linked to the WorkID form. To place an order, I add the parts via the products form (We reorder a great deal of the same parts, so this isn't always necessary). Then, I use the combo to select the product (this is set up to automatically enter the price and quantity). I detail quantity. To do the work order, I open work ID, enter the types and specifics of work, select the parts used in the WorkParts subform, and enter labor details in labor details. This sums fine in the form. Then, I select the Report, which brings me to the WorkID's invoice.

[rzw0wr]

OK, I have the WorkID form opened. I can enter labor in Labor Details.
How do you enter parts on the Parts Used form? There are not parts in the WorkParts form.
WorkParts is also set for No Additions.
Dale

[tarab87]

It should allow for additions. I don't know why it sets itself back to that.

[rzw0wr]

tarab, If you would, please set up the form you are having problems with, include the data with this form.
Then upload the database again.
If we can not get the data into the forms we can not check for the report problems.

Dale

[tarab87]

Ok. Sorry about that. I'll try again. All of my forms seem to be working correctly now. I'm uploading it again.

[June7]

I have never use forms on reports. Will the form grow to accommodate display of all records?

I am not seeing #Size error, I get #Error.

Might have to handle with IsNoData event and/or property.