Passa al contingut principal

Visits to the blog on February 16

Hi all
This is my first post for today. The second is in the oven and will be posted soon.
Well, it's less than a month I've decided to publish some posts about programming and databases.
My choice was MS Access because this is the tool I use since 1993, when I discovered the 2.0 version. Of course in the future will be posts of other languages, but by now, it's my developing tool.
I would like to talk about why I use Access to develop, and why this may seem a hobbysts tool but is so far of this definition, but it will be in another post, I don't want to bore anyone.

I started to publish last feb 10, and this last month I've been following the visits to the blog all days.
This is the third time I start a blog, and by now, it's the most visited.
I would like to share with you a graph of the visits. I'm proud of those data, and I hope to increase those numbers.
I have a list of more than 20 posts ready to finish, and this list grows day by day, because there are always new things to tell, specially when you use this tool everyday.
I'm very proud of those results. It seems you like the blog and the posts.
I'll do my best to post more technical posts to increase your interest.

Another time, thank you very much to read my blog.

Comentaris

Entrades populars d'aquest blog

How to export data from access to a text file

Introduction Hi all Today's post is about a set of functions to export data from Access to text files. I wrote the next functions years ago, when working on a big project and I had to export some of my data to another system, by text files, regularly. I needed something easy for the users, and transparent. I will explain what I did, and how. At the end of this post you will find a link to download the example of code. Feel free to modify it. Sometimes it happens that we need to export data. Of course, almost always we may write to another database. As I said before, I wrote this code to cover a need. This is a brief: I've been working for a company who mades canned fish. They had their ERP software, made by a external firm, and mantained across more than 20 years. When I entered, I had to write a software to control the production process and traceability. Of course, my processes (my software) was a subset of all the other software, and they had to communicate th...

How to manage data in forms using only VBA. And why. How to use System Windows and stored files.

Introduction Hi all! Today's subject is about how to use a form to manage data using only VBA. As you know, manage forms with data in Access is very easy, practical, and may be done from the first minute. When you build a data source, a table or a query, you may create a form linked to them. This means that Access will do all the tasks related to manage the data, and when the form will be opened it will show those data automatically. This is very useful, especially when the user is a beginner, or just when neither the time nor security are really important. I will try to explain myself better. When we use the wizard to build a form, it fills automatically the RowSource property for the form, and the same for each field. As I said, this is useful, but may have some problems: When there are a big amount of records (more than 250.000) and/or a big amount of fields, the load process may be a little bit slow, and also if the form shows a large set of records or it has to sel...

Table and form for window Options in your application

Introduction Today I will explain how to do an Options dialog box with parameters for your application in MS Access. An options window is a simple dialog form. It may be linked to a table, but I prefer to do it using VBA, to have a more professional look and a very good maintenance. This post is organized in six steps: the table, the form, the records, the code in a module, finishing the form, and the code for the form. At the end of this post you may download a small Access file with the form options, the table and the code to manage it. First step: The table For the table, I usually create a table with three fields. The name of the table is Options: parName (text, 50, Primary key): the name of the parameter parValue (text, 50): the value of the parameter Details (text, 255): a brief explanation text field to have information about the field, like a comment. Later in this example we will see that there are different types of values, but the field is always a text fiel...