Search results

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

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

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

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

I am a novice user of Access so please be patient with me. J I have a need to occasionally to “kick” users out of Access – for example if our database locks and I need to have everyone get out of the database so I can compact/repair it. At times a user has gone to lunch and is in the database...

Hello - I started a new position within my organization a couple of months ago, and have been asked to create forms, queries, reports, etc. that are quite challenging for me (not having any experience in codes or macros). I have been lucky to find answers to my questions online, but wanted to...