Recent content by Linda2431

We just need a random 5% sample for each UserID. I use this macro for many different spreadsheets. Sometimes there is only one or two UserID's, sometimes there are 20 UserID's. We do a 5% audit for each UserID. Do you think the Top 5% would work? What top 5% would it look at? Thank you for...

If there is code that will give me the needed results, can any the experts on this Forum let me know? :) I have spent the afternoon reading about VBA Code, but haven't become an expert in the last couple of hours . . . .

I've attached a sample database - both in .accdb format and .mdb format. I've also attached a sample spreadsheet to be used for import. 1. Open the database form. 2. Click the first button. That brings up a blank spreadsheet. 3. Copy/paste the 3 columns from the spreadsheet into the database...

Good morning! I am a basic Access user -- unfortunately I do not have experience programming. Our department performs audits. I need to write a query to get a 5% sample per UserID. Each UserID has many records in a table, and I need to pull a 5% sample per User. If a User has only 1 record...

OK - I see where you added it -- I appreciate it very much!!! I can't wait to work on it tomorrow ....:)

That does make sense to me - I'll do some tweaking tomorrow and see if I can get it to run. Thanks so much!!! I don't have enough Access programming experience to figure this stuff out on my own, but usually am able to modify code once I'm pointed in the right direction. I appreciate your...

Thank you! That makes sense to me. Would I need to figure out how many loans to assign to each audior or do you know of a way for Access to tell me? I certainly am able to count and divide before importing, but looking for as much automation as I can . . . . thanks!

Question – I have multiple databases (Front-end, Back-end, Import, Reporting) which enables auditors in our company to audit loans. I use an Import database which imports a random sample of loans (10%) into the Back End database for audit. I import a spreadsheet of loans (let’s say 5000 loans)...

Yes, it did! Thank you!

Thank you!!! I've had issues w/ auto numbering . . . I "inherited" this database so I'm tweaking out the details . . . thank you!

I have a BE database that we have been using for over a year. I imported data from an external database into this database. Now I've found that my Autonumber has reset to a very low number -- that was imported from my external database. Is there a way to change this autonumber BACK to what it...

Thanks - for the form "frmAuditResults-Manual", the auditors fill in the LOB, Review Date, Loan #, Auditor, and click "Review Start". They they fill in the information in the sub-form. After filling out the information in the sub-form, they need to go back and click the "Review Complete" box. If...

Thanks - am creating a DB w/ some test information. This isn't a rush, so next week is fine. I VERY MUCH appreciate your assistance! I'll post something later today - THANKYOU!

I believe I tried that to no avail . . . I will try again though. I will fill in some dummy data and queries if it doesn't work and re-post. Thank you!

I have another question on this - I had to take out the last code for the checkbox for Review Complete. I have included the form in the attachment. For this form, the auditors fill in the top part of the form and select "Review Start". They then jump to the sub-form and use that form to fill in...