Recent content by mlubbs

I am not sure that they way this all was set up will work, but it is most likely that I just do not understand. I did not set this database up. The person that did is no longer here and doing what I am asking to be done was above them as well. When I open the database it brings me to a screen...

Minty, Thanks for the code. This is really above my level of understanding with access. I edited your code to the below. Is there anything else that should be edited? Would I make it an On Click Event or some other type of event? Sub FindFolder(sITMID As String) Dim sFolder As...

Thanks guys. Sorry for the lack of an explanation. Hopefully I can explain it well enough. In our excel worksheet you need to type in a Part Number. Then the above formula looks in the hierarchy of our AutoCAD folder. If the PN starts with a 1, it looks at the 1 folder for the entire part...

I have an excel formula that I have been trying to recreate on my form in access without luck. This works pretty slick in excel and if I can get it to work in access I will be on the road to saving my department about 6 to 7 hours of data entry a weeek. Here is the formula...

I have a table – Department ID DEPARTMENT DEPARTMENT_EXPLINATION I have a table – Employee_Listing This table includes: Employee_ID (Primary Key) LAST_NAME FIRST_NAME INITIALS I have a table – DISCREPANCY_LIST This table includes: DATE (Auto completes to current date) EMPLOYEE_ID (Primary Key)...

Thanks for passing this along. 1. I am not really sure what the combo2 part is doing and am having trouble relating it to my tables 2. I was hoping to cut steps out with what I was trying to do. a. You have to click ok b. You have to double click c. You have to click done d. You...

I am trying to add data to a combo box on the fly using Docmd but seem to be running into an error that I cannot find an answer to. Private Sub Descrepancy_NotInList(NewData As String, Response As Integer) intAnswer = MsgBox("The Discrepancy " & Chr(34) & NewData & _ Chr(34) & " is not...

That worked like a charm! Thank you very much!!!

I am trying to figure out a formula using the iif and isnull function. I am doing an on time report that looks at the Date Received, Date Required, Ship Date, Todays date and a few other things. The formula I am trying to work with is DAYS WORK DONE IN...

As my boss decided to make things more complicated in what he was looking for I have since decided to do this in just the excel worksheet. It should have been 0 instead of 0% Thanks for every ones input Mike

I have an excel worksheet with the following formula =IF(b40<50000,b40*0%,IF(b40<100000,b40*2.5%,b40*5%)) and I would like to convert it for use in access. I came up with the following: =iif([TOTAL]<50000,[TOTAL]*0%,IIF([TOTAL]<100000,[TOTAL]*2.5%,[TOTAL]*5%)) I get the following error...