Recent content by mjohnson1105

Thank you Brianwarnock!!!!

Try this: MLabor: (

Hi, I need help writing a very complex 'if statement' query expression. I need to create an alias column based on data from two data fields. Here's the logic: True: If [PP] = "WG" or "WS" or "WL" and If [GR] > 10 Then "Skilled" or [GR] Between 6-9 Then "Semi - Skilled" or [GR] <6 Then...

Thanks Bob! That was easy enough....

Hi, I would like to write some code to validate that when a user enters data into a text field, the user must enter 4 digits. Any help would be greatly appreciated. Thanks.

pr2-eugin, Okay, I will make a note of using the code tags. I would like to understand the code so that I can create the tables and implement the code. I am new to VBA so I don't quite understand the coding. Any help would be appreciated. Thanks.

Hi, I created a database for the HR department, however it contains personal information. I am trying to write VBA code that will only allow certain users certain access. Someone emailed me some coding and I really need help understanding it. The logic is that he created two tables that stores...

Hi I am a beginner programmer (self taught). I'm a 31 year old female looking to learn VBA in Access. So far I have been learning how to write VBA by creating macros and then converting them to VBA so that I can review the coding (clever, right?). I live in New York but I am originally from...