Recent content by sjs94704

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!