Search results

Hi, All. I am just beginning to get into the area of passing variables as needed. I have a good grasp of the concepts, it is just the code to make it happen that is where I am just getting going. For this I have several pictures so you can see exactly what I have set up and I will do my best...

OK, we know that for colors, Access used things like vbYellow, vbRed, vbBlue, etc.. WBUT, I have my own custom colors that I have represented here as RGB statements. Private Sub SaleDate_GotFocus() Me.SaleDate.BackColor = RGB(133, 258, 375) End Sub Private Sub SaleDate_LostFocus()...

Here is a picture of my form. As you can see there are several buttons on in. Let's say that that there are forms frmForm1, frmForm2, frmForm3, frmForm4, etc that can correspond with each button. Let's say that the subform itself is just called SfrmSubform The goal is as each button is pushed...

All I want to do is create a VBA module that causes the border of a control, like a text box, to slightly change when it has the focus to prompt the user to help them know where they are on the screen. So, very simply, when a control gets the focus the border changes slightly but enough for the...

Here is a picture of my relationships of my database. At the top left you will see that there is an "Entity" (The Customer). They make a transaction. One type of transaction is just a single work order to do a small job, such as going to someone's house to fix their sink. The second type of...

Access defaults field size to 255. Can anyoneplease shed some light on the importance of this property and how to set it right? What happens if I don't change it? For example, a field for the 2 letter code for STATE does not need 255 charcters! Is there a benefit to changing this property?

I am literally at the very beginning of my database planning. As a result of another thread I got turned onto an article with some interesting ideasfor database structure so I decided I am going to use at least part of it. So, to have less tables, all customers, vendors, contacts and anoth...

Hi: Doing what I am asking below will be a brand new skill for me to learn! I am in the beginning stages of developing my application. So, for this example I am going to use CUSTOMERS. So, the beginning of my customer table looks like this: CustomerID FirstName Middle LastName In also have...

I am new to working with calculating times, so I would appreciate a code example with the following in mind: I am doing a database for sporting events. three of the events are timed. For example, there would be a race of runners, so I need to record precise times including milliseconds. First...