Recent content by Lithara

Thanks for the suggestions. I still couldn't get it to work, so I ended up splitting it up into two separate reports. I'll have to do the remaining calculations by hand since I can't seem to get the dang thing to work :mad: . Oh well. Maybe inpiration will come in my sleep. Other that that the...

Sorry, I'm still lost. :( I don't know VBA at all, so that limits me a bit. I would like to keep it all in the control source if I can help it, though the synax in your VBA line to the right of the = sign seems the same as the syntax I was using. But thanks for the suggestion Greg. ~Lith

Do you input a specific date range when you pull up your report (set in the query)? Because if you do then you can create a text box in your header with the control source set to: ="Between " & [Type a Start Date] & " and " & [Type an end date] (or type whatever your prompt wording is between...

Ok, this probably has a super simple fix, but I just can't wrap my brain around it. I give up! :) Anyway. I have a report (rpt_InspSummErrs) with a subreport(sbrp_Subtotalsmry) that displays the sum of items counted in each inspection (in control source labeled sbrp_NoItems, where =...

Thanks! I'll check it out.

Maybe you guys have some good suggestions for me :o My boss has asked me to look into getting software for our HP iPaq PDA's that we (myself and other inspectors) plan to use in the field, instead of taking reams of paper forms with us. I'm not an IT person, I just barely know how to create a...

Hello Elhan, I've had to deal with a similar issue. To keep it in form view, go into the subform properties and change the Default View value to Continuous Forms, to display many lines, or Single Forms to display only one at at time. Form view can hold multiple records, just like datasheet view...

OK, I think I figured it out. :) In case anyone wants to know: For problem 1) I was using the wrong syntax in the control source line found in properties. And for problem 2) I created a query of the table I was using with the calculated fields that I needed. Then I created a new subform based...

Thanks for responding, unfortunately you lost me at VBA. I know nothing about VBA programming except that it's visual basic. Is there a way of creating a control on the mainform and, using the properties function, report what I need? I've tried the following: in sbfmScanInsp form footer...

Hi Everyone! Bear with me, I'm new to Access and I may not understand or use all the terminology correctly. Background: I'm creating a database to track the inspections of many businesses. Each business will have many inspections throughout the year and each inspection has many items. I have a...