Search results

I am trying to educate myself on Access and become a better designer. I have yet to find anything in the books I have bought as to which process is better or when to use ADO and when to use SQL Insert. If someone could please shed some light on this subject I would greatly appreciate it.

namliam - Thank you so much for your help today. I have learned more from you today than I have from all the books I have read.

namliam - That was probably me responding on old post. I use the information from a lot of old post and reply saying thank you, when it worked for me as well. Another question on If Statements. Is this code correct for say all fields must be true or meet the requirements: If (Not...

namliam - Thank you. I wil put it back....

Fredalina - Thank you for the suggections. I have done that in the past, don't know why I didn't think of it this time... You mean like this: Dim t As String Dim s As String t = "Claim already paid/MBR rates no further entitlements/Duplicate Claim" s = "Same city no entitlements / no per diem...

I know, Still working on the DB. In the beginning I knew nothing about how to create a DB, normalization, naming conventions and VBA. So there is a lot of work left to get everything as it should be. I know that catcode should be and actuall code 1A or something that is associated with the...

namliam - so my code is correct? What is wrong with the Catcode????? just curious what your thought was?

dapfeifer - Doesn't work. Now it throws and error in the compiler. is there "" somewhere in there or no. when it is just "_" compiler allows and eveything turns blue like it should.

I have search the site, but obvious I didn't put in the right information. This is a simple question. I have the following code: If (Me.CatCode = "Claim already paid/MBR rates no further entitlements/Duplicate Claim.") Or (Me.CatCode = "Same city no entitlements / no per diem authorized in...

LPurvis - thank you for your help.

Can Someone tell me what "on view change" does. I have searched here and on the web with no luck.

FIgured it out. Just had to use the GotFocus on the next field. Private Sub ClaimType_GotFocus() If IsNull(Me.tblClaims_SSN) Then Me.tblClaims_SSN.SetFocus End If End Sub

I am still having problems with the last statement. [code]If (Me.CompCode = "KM") And ((CurrentUser() <> "cmoratz1") And (CurrentUser() <> "bhoward") And (CurrentUser() <> "kwilliams") And (CurrentUser() <> "bwilliams")) Then MsgBox "You are not authorized to enter this claim. Please take it...

Now I have the issue when the user is not in the list that it throws the MsgBox but will not undo the record and setfocus on the specific field. If (Me.CompCode = "KM") And ((CurrentUser() <> "cmoratz1") And (CurrentUser() <> "bhoward") And (CurrentUser() <> "kwilliams") And (CurrentUser() <>...

KenHiggs - thank you for your help. I would still like to understan how the Dlookup() works.

Thank you for all your help. I figured out what u were telling me and it work....

KenHigg - it worked.... MSAccessRookie, now I get what you were saying... Thanks guys I have learn several new things. Don't "_" after Then and then you can you put an End If at the end of the statement..... As always this forum has great people and they are always willing to help....

The code really looks like this: If (Me.CompCode = "KM") And ((CurrentUser() <> "cmoratz") Or (CurrentUser() <> "bhoward") Or (CurrentUser() <> "kwilliams") Or (CurrentUser() <> "bwilliams")) Then MsgBox "You are not authorized to enter this claim. Please take it to MCRATS."...

KenHigg - how do you do the Dlookup that you were talking about?

I have removed the "_" and now it gives me the MsgBox and It shouldn't. If (Me.CompCode = "KM") And ((CurrentUser() <> "User1") Or (CurrentUser() <> "User2") Or (CurrentUser() <> "User3") Or (CurrentUser() <> "User4")) Then MsgBox "You are not authorized to enter this claim. Please take it to...