Search results

Thank you. Let me give it a go.

I understand your point here, and yes, maybe I was not specific enough. My Access files are multiple and have the same structure simply because they hold a lot of data. I am seriously considering learning SQLServer, but for the moment this is what I can do. The database files are not meant to be...

Hello everyone, it's been just a few days since I became a member here and I gotta say, what a nice site! Great people, great ideas! I'm asking for a bit of help with a minor issue with Access. Is it possible to write VBA code to autofit fields and to alternate row color? My main code creates...

In the 19th century the Chinese in the US and Canada had also a semi-slave status. They are famous for having built railways with minimal pay and plenty of abuse. Not that different from the cotton plantations from the South. So the idea that only black people had a major social disadvantage...

I live really far away from the US, namely in Romania (and sadly too close to Comrade Putin) but along the years I took a great interest in the US society. I actually travelled a lot, including in the US, I spent 17 years in Japan and I would like to consider myself an objective intellectual. I...

Thank you for the welcome, I hope I can contribute to the site, not only learn a trick or two.

Thank you, I already got some precious help and solved a minor but very annoying issue.

Thank you!

Thank you everyone for your thoughts and inputs. While no individual solution helped entirely, they all pointed me in the right direction and in short time I fixed the problem. For future reference, let me share what I did. So, to recap, I have an ACCESS Database file saved somewhere. In the...

I forgot to mention. My entire code is run in Excel 2010 VBA. That is why I don't/can't use the CurrentDB syntax as I want to make reference to an external database file, not opened.

No luck:( But thank you.

Thank you! Yes, 2000 databases is a lot and in the future I want to migrate them to SQL Server. But for the moment they are well indexed, I juggle with them in no time with ADODB. Read, write, updatebatch etc, very easy. Unfortunately I didn’t have much luck with the solution you suggested but...

Hello everyone, after browsing and browsing for a solution to the {most likely simple] issue below, I decided to throw in the towel and ask those more versed in Access. So, the issue I have is very basic. I have a table with 6 fields, the first is a date and the rest "doubles". Now, this table...

Hello everybody, I just joined this forum with the hope to learn and teach:) I have vast experience with VB/VBA, automating statistical reports, generating graphs and so on. I work on projects that involve large data sets and hence the need for SQL. I used to be an Excel addict but now I use...