dbswdevelop

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

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

Access is a powerful tool not only to manage data, but also to develop professional software. Due to its powerful structure, it is possible to work with it in some diffent ways, while the application grows up. For the rookies, I will expose, first, a brief of the objects you may find in an Access file. Objects These are the main objects and their meaning: Tables: where the data live. You may imagine them as sheets organised by rows and columns, where the columns are named fields, and the rows are named records. Each field has a data type, that is, all data contained on a field is always the same. Queries: these objects are very useful when you want to combine data of tables. Forms: to show and to enter data, those objects may contain text fields, check boxes, command buttons, text areas, list boxes, and other type of controls. Each form may have linked a module where to write code in VBA programming language for automate its behaviour. Reports: similar to forms, but only

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

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 xB