Search results

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...

That worked PERFECT -- thank you, thank you, thank you!!!! I apprecate your assistance very much!

I like the way this works -- much better!! -- however what do you mean by you changed the Null checks as: If Len(theControl & vbNullString) = 0 ThenI copied/pasted the code you provided and I do like the way I get the error messages which gives me an opportunity to enter in the required...

Hi - I have a form that is filled out by users in the front end database. I wrote some code in the form in the "After Update" event procedure to ensure that certain fields are filled out before going to the next form. The code works EXCEPT for the two items in red below. These are check boxes...

It's up and running -- thanks so much to both of you!!!

I may have posted my response too soon -- I added the module to the frmMonitor (which I'm sure where it was supposed to be to begin with). I'm going to continue testing, but I think I may have gotten it right this time. Thank you very much! You have been extremely helpful and I appreciate it...