Search results for query: *

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...

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...

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."...

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...

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...

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...

I've tried looking through the threads to find something to lead me in the right direction. I have I made some changes to my database based on information I received in this form. Previously I was concatenating cells to get my primary key. Now I'm leaving the cells or fields as they are and...

I'm taking two fields to make a primary key. The first part of the field will be the same for every record. I.E. BSP The second part of the field is the part that is different. I.E. 1, 2, 3, 4, or 5. In the event the first part of the field has to be changed to, let say, DSP I would like...

I've searched, and still can't find the answer. I have 2 subforms on a form. The form links as such, Main form links to subform 1, and subform 2 links to subform 2. I can trasition into subform 1 with no problem by tabbing. However, I can't tab to subform 2. I've tried code...

Plan and simple. I have two databases that have a ton of information. I would like to be able to open one database by clicking a button. I am also assuming that the way you would pass information between forms [Forms]![FormName]![Control] is the same way to pass between the databases. I...

This is my code Me.ProjectName = DLookup ("ProjectName", "[ProjectInfo]", "[ProjectInfo].ProjectNo = '" & Me.ProjectNumber & "'" And "[ProjectInfo].TaskNumber = '" & Me.TaskNumber & "'") Everything is a text value. I keep getting...

Can this be done? Here is the twist. The records I am trying to update are all different and look like this A154, B982, C717, D559, Etc. Here is how I am thinking. If [Sample].SampleNum = A* Then [Sample].SampleNumNew = * (Where as the * equals the remaining portion of the cell.) Else...

Thus far I have the information set to look like a table. I set the borders to hairline, black. I have 6 rows with 3 columns. One of my columns, we'll call it [Column 1], is setup to grow and on occasion it will grow. The other 2, [Column 2] and [Column 3], are set up to grow, however, they...

I'm losing my mind and I feel like jumping out a window. I've looked through about 150 threads I keep running across this code forms![Form]![SubForm]![control] It claims that I can use it to access controls in the subform. I haven't had any success. It keeps telling my it doesn't recognize...

I have a form with a subform. frmClient and SubfrmOutlook. frmClient list Clients Names with their unique Client Number (Not the names of their employees or representatives). SubfrmOutlook is a table linked to outlook. What I have is this. From frmStart the employee chooses a record...

I've linked to Outlook and perform a search for by the clients name. It takes from 30 seconds to a 1 minute to perform this search. Any suggestions on how to speed the search up? Second problem, the search will find a record for one client but not for another. I've verified the spellings...

Everytime I open my form "DLECContacts" in design view there is a big white box that just has the subform name in it. What's wrong? I've seen this happen before, but all I would do reopen in normal view and then again in design view and everything is fine. Today it just keeps doing...

I use this code in a different Dbase and it works fine. I use it in my new Dbase and it doesnt't perform. What am I doing wrong? I went through the references and made sure they both had the same references checked and in the same priority. I've looked code over word by word, and letter by...

I have multiple lookup tables. Me.Text74 is based on a lookup table also. It's really a combo, started out as text and thought it would be better as a combo. I'll correct the name once it works. Anyway, this is how I thought this was suppose to work. Whatever Me.Text74 equals then perform...