Search results for query: *

I have an order worksheet that engineers choose parts from. The Vendor name is called out in cell H5. There are other worksheets with the names of the vendors on the tabs for each sheet. I would like to program a button that would look down through the front master sheet and sort the items that...

I have an order worksheet that engineers choose parts from. The Vendor name is called out in cell H5. There are other worksheets with the names of the vendors on the tabs for each sheet. I would like to program a button that would look down through the front master sheet and sort the items that...

I have a spreadsheet that I need to find rows with values entered by an input box. If the value is found, then delete the row. I want to be able to enter wildcards so that any value containing the text will result in deletion of the row. I used snippets I found on the web to get started, but I...

Here is my solution: =IF(C9="Yes",IF(B9<=2,"LT VFD",IF(B9<=5,"ClassicVFD","Powerflex")), IF(B9<=5, "LT Contact", IF(B9<=10, "Classic Contact", "Powerflex"))) Thanks for your help.

It was difficult to get the columns and rows to line up in the post. So I had to manipulate it to show you the spreadsheet. LT VFD is a non "Contact" model. Classic VFD is a non "Contact" model. "VFD" is a variable frequency model. There is a "Contact" model that is non VFD. So if the VFD column...

Here is an example of the table, I am trying to determine the values for H and I based on the values in B and C. [tab]A[tab][tab]B[tab][tab]C[tab][tab]D[tab][tab]E[tab][tab]F[tab][tab][tab]G[tab][tab][tab]H[tab][tab][tab]I 1 Unit[tab]Hp[tab]VFD[tab]Brake[tab]FLA[tab]BRFLA[tab]Branch[tab]A/S...

I have a spreadsheet that lists motors with HP and options like brakes and VFD. I need to look at the horsepower, and the VFD option and select a type of drive to use. The HP is in cell B9, the VFD option (which says "Yes" or "No") is in cell C9, the type of drive used will go in cell H9. The...

Yes that is exactly right. Thanks for the help![dazed]

The first one is controlled externally and is not calculated for the cabinet. I should have left that one out. These are circuits that must be limited to 24.5 amps per branch. I just want to go down the column adding up the full load amps till I reach 24.5 then assign it to a branch and continue...

Sorry I was not clear in my question. I have values in the column for full load amps (FLA). I need to check the sum of the values cells in the column until I reach a threshold of 24.5. Once the threshold is reached, then I have to start summing the values again from where it left off, and...

I have a column of values in I3 that I need to check the sum until I reach a threshold of 24.5 (full load amps). If the value exceeds 24.5 the cell J3 (branch number) needs to increment by the value of the previous cell in the row above plus 1. The first row will always start at 1. So if rows...

Ok, I got it. I have to have the line: rs.update just before rs.close.... duh... Thanks for all the help guys :)

Thanks Remou, Now the connection is opening fine. But.... I get an "Operation is not allowed in this context" error when I hit the rs.close line in my code. Do you know what causes this? When I try to go the the help file (F1) I get a blank screen.

Ok, I changed it, no effect. But thanks :)

Yes project is a text field. The sql string works fine if I put it in the query design window in sql view (from the debug.print). it's when it gets to the rs.open that I get an error.

Thanks guys, I tried this: Sub UpdateMasterDb() Dim cn As ADODB.Connection, rs As ADODB.Recordset Dim intResale As Integer Dim intHours As Integer ' On Error Resume Next intHours = Worksheets("Project pricing summary").Range("G60").Value + Worksheets("Project pricing...

I have some VBA code that takes field values from an excel worksheet and dumps them into a table in Access. I need to check if the record in the table exists first, and if it does than only update it. If it does not then add a new record. Here is the code I have so far. Sub UpdateMasterDb()...

Ok here is what a coworker has come up with, and it appears to be working: Straight time: =IF(E4<=8,E4*1,"8")+IF(F4<=8,F4*1,"8")+IF(G4<=8,G4*1,"8")+IF(H4<=8,H4*1,"8") +IF(I4<=8,I4*1,"8")+IF(J4<=8,J4*1,"8") Time and a half...

John, I tried your solution and it looks pretty good other than I always get time and a half unless it is Sunday. Any idea why? And thanks for your time. :)

Well, like I said before, I can't seem to post the actual spreadsheet. but the data is outlined like this: column headers A1 - Employee name (data entered by employee) B1 - Mon hours (data entered by employee) C1 - Tue hours (data entered by employee) D1 - Wed hours (data entered by employee)...