Search results

Ok, I have a report.. I gave up trying to bring Counts from the Subreport to Sum on the Main Report. Seems many folks are having issues doing that. SO what I have decided to do is when I run my Access report it will automatically open up as a Excel worksheet. OK That part.. I got.. by Opening...

Ok, I have two fields Field 1 is in a subreport (Document Count Summary subreport) and it is called TotDocCount" and if it "HasData" then I want to Divide Field 2 that is called "Tot Prep Err" by Field 1 on the main report to create a percentage rate. If there is no data to divide I want the...

Ok I have a subreport... I have a Count called "AccessTotalsPrepper Error". I am counting the number of errors found in a batch audit. So on my main report I know I need to create a textbox to pull that data to sum up the counts. In that text box I have the source code set as =Sum([Prepper...

Ok, how would I do this? I have a Query (Prepper Error Table Query) that pulls this data: BatchNumber ID Prepper Error Prepper Name Prepper Doc type I have a subreport (Error Counts) where I need to subtotal the total amount of errors per Batch Number ID So In my report(Error Counts) I...

Ok on my report I have a control called Prepper Errors. I have another Control that counts the number of Prepper Errors per Batch Number ID. For Example> "Prepper Name" may have 5 Batches and we are counting each error in each Batch. so for Batch Number 1 I have counted 5 errors...

Ok, I have a Main Report currently named Prepper, I have a Subreport named Prepper 2 Query Data. In the subreport there is a control that is a calculated Count of another control on the sub report (Prepper Error) the calculation is counting the number of Prepper Errors. Ok that works fine...

Ok, look at this report I have created. Tell me how can I get one single total per Batch Number ID? As you see here it adds a total per error. In some cases a user will have several batch number IDs with several errors and I want to total each document count in each individual Batch number Not...

I created an audit database: I have a Batch of documents that are scanned. Per Batch I have a Prepper for each Batch Number ID (actual Batch of documents) I have: Document count, Date of Audit, Prepper Name, Prepper Error (Error they may have made in scanning the documents) and Prepper Document...

Ok, I have these fields from my form: Batch Number ID: Document Count: (for Preppers) Manual Count: (for Indexers) Prepper Name Indexer Name Prepper Errors: Indexer Errrors In my reports I want to take a batch: and have the document count or the manual counts (I wil have two diff reports for...

Ok, I have a querie i am pulling from my sweet form data that you folks assisted me in collecting... I have a Field Called Batch_Number_ID and each batch number I will have a document count. However I can have several errors under that batch but I only want one document count per batch. how...

When you have a combobox in your form and it is rather long. Is there a way to set it up to where if you type the first few letters it will go right to that area? Just to make the form flow faster?:confused:

I followed this process for my report created in Access: http://support.microsoft.com/kb/841779 However it still isn't resetting and it shows up now as Page 1 of then page 2 of it isn't calculating the pages nor is it resetting at the group level? What do I need to show you folks to see what...

Ok I followed this example: http://www.allenbrowne.com/casu-08.html I created a query from my data table. I then followed through to the report and set it up so it will ask for a date range. However I am still getting data for all dates entered in both the query and the Report How do I...

When I click my control buttons to "Close Form" It clears my form but it takes me to click it 3-4 times before it closes. Everytime I click it it enables my first-fourth controls then it will finally close out. I also find if I simply click into any field it will enable it but I want them to...

I placed a control buttont o close my form and It continues to enable a few of my fields before it will actually close. You have to click it several times before it will close correctly. I first had it in my mainform and it was behaving that way and thought perhaps I needed it in my subform...

Ok, I have a save buttong (next record) in my mainform (DIQA). I want to be able to click that save button after all records in both the mainform (DIQA) and subform (Audit_Error_Subform) is complete. but I get an error since my control in the subform has the focus. This is what I have done...

Here is my scenario I want to make a choice in the last combo box in the mainform and then set focus and enable) the first combo box in the subform. (I have the fields disabled till the previous field is entered and it works in mainform with no issues). Now why can't I get focus or enable my...

Is there a way Manual Save and stop automatic insert? YOU FOLKS ROCK! Ok my final question and I am DONE! YAY.. Is there a way to set all of my form so it does not insert data into my tables untill the user hits my "SAVE" button? I know Access automatically moves the data as it is entered...

:(I have successfully created my form and I have my combo boxes and subforms working correctly with pop up messages and my fields are greyed out till the previous one is enabled etc... Now I am having an issue when we are testing the form out if I decide in the middle of the form I want to...

So close to finishing my database.. Question, can my fields be greyed out till each previous one is filled in? What is the procedure to do so. I have found so many ways in some of the forum but no true procdure yet. Ok here is my fields Field one is called Batch_Number_ID (user will enter...