Case Sensitive VBA Query (yet another)

It's definitely worth investing some time in your table design before you get too far.
This is an important piece that you're blowing right past. "Relational doesn't apply" is hogwash.

Most of your difficulty here is coming from your non-relational setup.
 
This is an important piece that you're blowing right past. "Relational doesn't apply" is hogwash.

Most of your difficulty here is coming from your non-relational setup.

No, it comes from my application not being syncronised with the server database.
 
I've explained it above.

We've got a web application that stores the same kind of information on a server. That is the true and real database people go look into for information.

My application/form/database is just a tool. Directly on the web application I mentionned above, it is impossible to manually do massive information update. The only way to do it massively is by sending an excel file to the managers of this application and they will then do a massive import in the web database. Other than that you have to load the pages one by one to access the record and click another time to edit it. Many loadings.

To put it simply, the informations that comes into my database come from this server database, and the information isn't always keeping its integrity as people from around the company manualy enters (sometime) random values.
 

Users who are viewing this thread

Back
Top Bottom