Recent content by b31luv

Pretty funny huh? I knew about Validation but I only used it for developing List. Thanks to each of you for your time.

I'm not trying to become a professional programmer in Excel. I just want to make a spreadhseet give a message, if necessary, based on inputted value in a cell. This is what I have If Cell("b9").Value = 1 Then MsgBox ("Please Enter either 1, 2, or 3"), vbExclamation Else End If Actually...

I guess I owe tigerlil3 a thanks also. I only tried the first portion of what he/she had written. I was so engrossed in what I was trying that I didn't even try the second portion. Thanks guys [2thumbsup]

John, Based on your assistance here is what I have. Dim myVal As String myVal = Me.COPProjectNo If DCount("[COPProjectNo]", "tbProjectInfo", "[COPProjectNo] = '" & myVal & "'") > 0 Then Me.COPProjectNo = "" MsgBox "That Number is already being used. Enter...

I revised the code as specified and I still get the same error. I'm using the AfterUpdate event. My intent is to verify whether or not a project number is already logged into the databaswe before the client is allowed to enter anymore information. There is no other operation happening during...

Here is the code I'm using: If DCount "[COPProjectNo]", "tbStoredProjectNo", "[COPProjectInfo] = '" & Me.Text52 & "'") > 0 Then MsgBox "The Project No You Enter already Exist. Please Verify Project No and Re-Enter", vbCritical Else End If It looks proper but I keep getting this...

I got it. I just put the second part of the code someplace else and required the user to save the selection first.

Thanks RoyVidar. Forms.frmProjectInfo.AreaCode = Forms![frmProjectArea Subform]!AreaCode I have this issue here. I need to get this out of my subform. The error message keeps saying database can't find it. I wrote it this way also Forms.frmProjectInfo.AreaCode = Forms.[frmProjectArea...

How can this be done? I have a function that I took from a class module and put in a standard module and I keep getting the "Invalid use of Me keyword" error. The help screens says to "replace the Me keyword with the specifc object or form name to preserve the original reference."...

It's finding my function now; but it is telling me that I have an invalid use of Me Keyword (Complie Error).

AceMan1, I transferred the function to a new module which I named global and it still tells me that the function name can't be found.

I'm sorry, I added the =OpenfrmEquipment to the On Action in the properties and it tells me it can't find the function name. I figure I should make the sub global or public. Please advise how.

I have two (2) forms frmArea and frmEquipment. A ControlButton on frmArea opens frmEquipment based on the current record (or selected record) of frmArea. I decided I didn't want to have control buttons on my forms and decided to customize my menubar and toolbars. I found a really good thread...

Is this possible. I discovered the tab control and I would love to use it. My database had several different forms with subforms and were linked based on selections on the forms. I removed all forms and subforms and made one form using a tbCntrl. When the main form is opened the first page...

Sorry for the post. I just found some information in other post that I will try first. If it doesn't work I will submit another post for additional help.