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 attached files with access. Options.

Hi all This week's post is about how to manage attached files with MS-Access and VBA. Introduction Sometimes is useful and/or necessary to store attached files in our applications. Let's see some examples: A used car seller may have a database with all the vehicles on sale, and may need to have photos of the cars, to show them to the potential customers before seeing the cars. And also may want to store digitalized the papers of the car. A real state business, has a file with each property, and may want to show the photos to the potential customers before visit, to restrict the number of properties to visit. And not only the photos, but also legal papers about the property. A doctor, may want to save information about their patients, but sometimes this information is not suitable to be stored in a record, for example a bone scan or the results of some tests, but is useful to attach to the patient file to find it more easily. A farmer may need to store data about the

Use of listboxes as a data summary instead data forms

Hi all This post is an extension of the previous post ( how to develop a carousel ). Here I will show how to manage a summary form linked to a detail one, in order to show data and detail them. I want to clarify that this is not "the way" to work with access, this is "a way". This is the way I use. After been developing Access applications, I've found this is a good solution, and I use it almost always. I will improve the previous example, the used cars seller adding a new form. The new form has a listbox and some buttons (add, delete, duplicate and modify) to perform those operations. All those operations are solved using VBA, as you may see. The new form is named Main. You may see in the next screenshot I've added new records. Once the form is loaded, the data are stored in the listbox using the Form_load event. The objects are named as follows: Button Add is named cmdAdd Button Duplicate is named cmdDuplicate Button Delete is named cmdD