dbswdevelop

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