Search results for query: *

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.

I'm not sure if I'm postng this in the proper forum. My desktop and my laptop both have the XP operating system and XP professional installed. I have Cox Communication as my Service Provider (Cable). My cable modem connects to a router. The Desktop is connected via ethernet cable and the...

Hey PHV. Good looking out. I had some other issues with this. One I needed a check to verify if a certain condition existed. I used: If Me.TabCtl0.Value = 1 Then. Then I need to give focus back to the first page so I used: Me.TabCtl0.Value = 0. All is well. I also got rid of subforms on...

I used the Change event of the TabControl now I'm getting action. I revised some of the code so that controls would be recognized. However, now it doesn't recognize the subform of the form. This is how it is written Me![subSiteArea]!Area Is there another way of writing this?

Right now I have two (2) tabs. Tab 1 is is for site info; Name of Site and Area Selection. Tab 2 is for equipment; Select which piece of equipment in that area. There is a tbSiteInfo which has Site Name, Site Address, Type of Site, SiteIDNo (Primary Key), and Contact Information. Then...

I have a form that I designed using a Tab Control. All of the forms work the way I need I just that the tab control would make it easier for the client when moving from form to form. The problem I'm noticing, might not be a problem it could be just my knowledge base, when you move from one tab...