Search results

You guys are the best!!! Thanks!

CREDENTIALATTAINED is actually a date field not a YES/NO....kind of diverted from the topic. Do I need to start a new thread or is it just a simple tweek?

You are both great!!! Since you were so helpful what if sAccessCredentialattained is null. I keep getting an error message. Is there any way that if the date is null to return "" and if it is filled in to return the actual date?

I am slightly new to Access VBA. Would this be an addition to my code or a modification? If it needs to be added where is the best location for this to be added in my code? Thanks for the quick reply!!!

I have the following VBA code that auto populates a word template: Private Sub Command24_Click() On Error GoTo ErrorHandler: ErrorHandler: If IsNull(Me.REASONFOREXIT) Then MsgBox "Reason for Exit needed" Exit Sub End If If Me.TRAININGSTATUS = "COMPLETED" And Me.TRAININGPROVIDER = " "...

[Text42] and [Text44] are not bound to anything. They hold Count(functions based on two fields on the form. Renaming the controls is a good idea. Any other ideas for dividing two unbound text boxes?

I am running in to a brick wall with this. I have an unbound text box with the control source set to =IIF([text42]=0,0,[text42]/[text44])*100 and in continues to return a #name? error. I am not sure how to get this expression to work. I have even tried to put =[text42]/[text44] and I still...

I apologize for the curve ball. When I arrived at the office I tried using -1 and 0 for YES/NO fields and that fixed the issue. I am not sure what you mean by "the field types in the comparison are the same." I am new to access and to forums so I am a little behind on the terminology.

I agree that Brian's expression is the most efficient for the expression that I posted. I unfortunately picked the simpler issue hoping I could then translate it into the more complex expression. The complex expression is as follows: Iif([TRAINING STATUS]="COMPLETED" and [CREDENTIAL...

The fields are yes/no so I will try the =1 and =0 that you suggested today. Thanks for the idea.

Thanks for the response. I have another expression that will require an "and" so I would appreciate if there is a solution that can include the "and" operator.

I have tried this with the following but errors are still returned for any expression that has an "and" operator. Expr3: IIf([EXPR1]=1 And [EMPLOYED]="YES","YES",IIf([EXPR1]=1 And [EMPLOYED]="NO","NO",IIf([EXPR1]=0,"NA","NA")))

I understand what you mean. I took a deeper look into the database and will not require this as it is not necessary and could cause potential problems to the structure in the future. Thanks Pog.

I am attempted to create an IIF AND function in a query field. I have the following expression but for some reason the AND will not work. Expr3: IIf([EXPR1]=1 And [EMPLOYED]="YES","YES",IIf([EXPR1]=1 And [EMPLOYED]="NO","NO",IIf([EXPR1]=0,"NA"))) The last section {IIF([EXPR1]=0,"NA")} works...

If you could elaborate it would be much appreciated. I have only been using access for 2 weeks and taught myself everything from six books and the Internet so any information on structure would be appreciated.

You make a good point Plog. This would not be a feature that I would want me users to have access to, however it is a feature the administrator needs access to and currently I am the only one at my company that knows Access. My fear is that if I do not make this process simple for the person...

I am creating a database for users that no nothing about access nor do they want to learn. So the database needs to be as simple as possible. This being the case I would like to avoid users from creating/editing querys. I would like to have a form that would run the append query. The query...

How do I mark this thread as solved? First thread...

I have my login screen set up the same way Pat. I was not aware of the unload event so I used a different work around. I created a log off button on all forms and disabled the red X as well as the X to close any forms so users wouldn't get stuck in a place that they couldn't close the database...

Thanks for the response Pat. am I able to attach VBA code to the close button (red X) that closes all forms before application is quit? I have created a Logoff button that effectively does this and it works with the Navigation Pane hidden. The problem is my users are so used to clicking the...