Search results

That's what I meant about passing variables! I did not know how to do that and was wanting to figure out how! I know it will take practice, BUT, this is what I meant! Thanks, Josef! And I do appreciate everyone else's responses in trying to help figure out what I was talking about. From my...

OK, I can do that (Adding another distinguishing field) So, I am just going to list off a few that I used from a previous database: Customer Type Phone Type Gender Marital Status Verteran Status Vendor Type Part Type Part Category I have always had these in their own seperate tables. Maybe...

Thanks, Pat. I appreciate the referral. I have book marked the security database thread and will take a closer look.

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, well I do remember from a previous experience that the security issue was quite cumbersome, but in that case we were opening and closing entire forms and the list if IF statements that we ended up having to cover all the various roles got very long! We probably could have done a much better...

BTW, for anyone who is interested, I just now found this website: http://www.shodor.org/~efarrow/trunk/html/rgbint.html You can put in the RGB numbers of the color you want and it gives you the LONG as well as the HEX numbers for that color!

Sorry, maybe I just misread what you said.

This is really cool! I will be interested to see if it will be possible for regular buttons to work with your idea.

Just checking... (I am just learning code here!) If I put these in a module, say called modGlobal, with the way this code is declared I can now use them anywhere in my database without having to declare them over and over. Do I have that right?

Thanks everyone for your replies! I really appreciate it!

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

OK, so probably not to anyone's surprise that this works. BUT, now I want to take this to the next level. What I mean is, I want to make a routine out of it that could possibly end up including other things that will ALWAYS happen at the same time!

Life shows up. I am in recovery and just got elected into a new position helping people in their first few days/weels of recovery, so my attention got diverted for a minute doing that! Just getting a moment to sit back down into my own life again and get back to this... All I was trying to...

While I respect Edgar's answer suggesting the Navigations forms, I am interested in doing this programmatically. I also caught what ebs17 says about doing any and all checks to be sure that everything on the form your on is completed before moving to another form.

What I am talking about is for data entry form. Not necessarily a continuous forms. Such as when entering customer or vendor name and addresses, etc..., but when it comes to continuous forms I get it that this would not work as mentioned previously!

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

Yes, you are right! At first, I was thinking what you all were try to tell me was that everyone goes in the Entity table no matter who they are! So, based on the comment above I made a ContactT and associated tables for that...

I believe I do understand the concept of Entity. I might have some of the terminology used differently than you at the moment, BUT, I am not married to my ideas so I am very open to hearing what you are talking about and how you are looking at this such as how you see the use of type and role as...

Your right! In my other application I did split the different tables dependind on the typecof role they played., etc .... But I do see and appreciate that having them all togeher is best. I guess my only question now would be what fields I would need to make the connections between Entities in...