Search results

Hey everyone! Just wanted to provide an update as I was able to correct the issue relatively painlessly. Firstly, I should explain how the DB is set up, and also specify that I did not build it but I am in charge of maintaining it. There is a "back end" .accdb which contains all of the tables...

Hello everyone! A database user was filling out a form and entered a quotation mark into one of the fields. This caused the record to become corrupted: It also removed the auto-generated primary key in the LabNum field. I've tried editing the record to remove all the data, replacing the...

Yes, that would be ideal but unfortunately this is data coming from a third party. :/ I'm going to try CJ_London's suggestions and see how it turns out.

Hey jdraw, They are ratings. I guess a better example would be the student scores in different subjects, and I want to find which subject each student excels at the most. Ex: Student A got a 55.4% in Math and a 78.2% in Science. So I'd highlight Science as Student A's top class.

Hi all! I have a table with ~200 records and I need to compare 11 different fields to find which field has the largest value. Here's an example table: State Name Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 Value 7 Value 8 Value 9 California 20.22 94.2 74.0 75.9 33.33 67.4 60.5 92.1...

Yikes! That's all I'm going to say about what this thread became. At least I had some early morning entertainment to wake me up! I ended up using MajP's original post, solely because it resonated with me the most and I knew how to implement it. As someone who only uses Access on occasion, it...

Hello MajP, Thanks for replying! Are you asking about what I wrote here? What I mean is that I will have to group records based on the "State" field, and then compare the first record's "End Mile" to the next record's "Start Mile", like so: If the End Mile and Start Mile do not match...

Hello! Sorry it has taken a month to get back to you. I got sidetracked with other projects that popped up, as well as a health emergency in the family. I tried your queries, but as far as I remember, they did not work. The database kept crashing without any errors. I ended up completely...

Hello everyone! I'm attempting to do a "Gap Analysis" where I look for gaps in our data. Here's an example table: State Start Mile End Mile California 2.6 3.5 California 3.5 4.7 California 5 6.1 Florida 0 1.4 Florida 1.6 2 For California, there is a gap between 4.7 (end mile of...

Hey Buddha, Thank you so much for your help on this. I ran the query and Access crashed without displaying an error. Not that I am aware of.

I've attached the error that occured with this new code

It happens on the first pass. I was wondering if it was a reference issue (they seem to happen quite often), and I checked earlier, but nothing was missing. It is currently using version 2.8. I will be honest: I'm not sure what ADODB & DAO are exactly. Is there a way I can clean up the code...

This does have linked tables, it is linking to an .mdb that I can open. While Not rsPCIAGE.EOF This is the line that it crashes on.

I checked and Option Explicit is declared for each module. I clicked Compile and I believe it worked? I've never compiled in Access before. Everything froze for a few seconds and then went back to normal. The Compile option is now greyed out.

Did as you requested and got the same result as when I click the button on the form. Access crashed without any errors.

Hi Cheekybuddha, I place my curser in front of "Private Sub" and click Run.

Hello! Let me start by stating that I'm pretty much a novice when it comes to Access, so please let me know if I can explain things more clearly or use different verbiage. I have an Access database that was created by someone else years ago. Its purpose was to take Access data from a piece of...