Passa al contingut principal

dbswdevelop

Hi all.
Mi name is Tomas Eroles.

Professional

At this moment I'm unemployed, and, of course, available for a job on programming, also for freelance projects.
My main skill ara databases and develop software with MS Access and VBA (I'm an expert using this tool), but what matters is to know about programming and analysis. As a (almost) Systems Engineer, I may learn others languages.
I know VB.NET, HTML+PHP, GAMBAS, and other programming languages, but I'm not so good than with Access.

Personal

I was born in the city of Barcelona in 1974, and moved around 200 km to south with my family when I was 5, to the nice city of Vinaròs.

I'm finishing my studies on Systems Engineering.
I'm married, and we have two little daugthers.
I love computers, technology, travel with my family, and cook.

This is a blog about Databases, Software, and Development.

The main tag will be MS Access. I've been using this software since 1994, after some years using the xBase products (dBase III+, dBase IV from Ashton-Tate and Clipper from Nantucket).

I will appreciate your comments, and I will try to answer them.

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...

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...

How to develop a carousel

Introduction Hi all! This week's post is a mix of part of the previous made practical. I will make grow the present example in following posts. We have seen how to organise an application, how to manage attached files, and how to work with options. This week we will join some of those characteristics to develop a Carousel. This is an example I've made some years ago to help a user with a carousel for used cars. It's made thinking on the spanish market, and I've used the plate number usual in Spain, that is, a number between 0000 and 9999 and three characters B-Z (avoiding the vowels). It's made with Access 2003. What is a carousel and when may be useful? A carousel is a form to show images, pictures, and when is loaded shows, automatically, a picture each time. In this case is each 5 seconds (5000 milliseconds). This may be useful, for example, in a business where you want to show photos of your goods to your customers: used cars, real estate..., that can...