Recent content by blacktide

Not understanding Ok so maybe I don't really understand what you are wanting. I have made a test db and I am trying to follow the instructions you outlined, however I am not 100% that it will work. Please keep in mind I have to allow for the posibility that more than one Tech worked on 1...

So..... I am taking this with a sense of humor and hope that you do to. So Basically what you are telling me is 1) my database is craparific :eek: (which doesn't surprise me) and 2) I would be better off starting over?

I have a query that has 4 Tech fields and 4 Hour fields and a few other fields that are not pertinent to my question. When the Tech opens the query it will ask for the Tech's initials at each Tech field. The Tech entering his/her initials will appear in only one of the fields at a time and...

Solution Pat, I know it has been months, but I finally got back around to my problem (as you can tell it wasn't that pressing). Here is the solution: =iif( [TotalCommission] <= 500, .04 * [TotalCommission], (500*.04) + ( ([TotalCommission]-500) * .05 ) ) Thanks to clippit at...

forum placement mistake It seems that I misplaced my post. I should have posted this in the Reports Forum. Sorry about that. I also asked the Office Administrator for some clarification on this report and it seems that I was misinformed on how it was supposed to work. It isn't as simple as...

If my total = ................... If my total = $0.00 to $500.00 I need to multiply it by 4% anything over $500.00 I need to multiply it by 5%. Is there an easy way to accomplish this? Mike

Some how the last piece was missing. Sorry. This is all that shows up. SELECT [SERIAL LIST].CUSTOMER, [PART NUMBER ASSOCIATION].DEPARTMENT, [SERIAL LIST].[PO/RO_NO], [SERIAL LIST].[W/O], [SERIAL LIST].SHIP_VIA, [SERIAL LIST].RECEIVED, [SERIAL LIST].REQUIRED, [PART NUMBER ASSOCIATION].MFG...

All right sorry about that here you go. AUTOFILL QUERY, SQL VIEW: SELECT [SERIAL LIST].[CUSTOMER], [PART NUMBER ASSOCIATION].[DEPARTMENT], [SERIAL LIST].[PO/RO_NO], [SERIAL LIST].[W/O], [SERIAL LIST].[SHIP_VIA], [SERIAL LIST].[RECEIVED], [SERIAL LIST].[REQUIRED], [PART NUMBER...

Pat, Thanks for having patience with me. I don't know what I did different, but I went through and made a new query from the two tables, joined them and now my Department, MFG, and Nomenclature Fields show the data that is in the Table, however the Part # Field has a #Name? in it and the form...

I removed them and I still get the same results. Mike

While messing around I added the other two tables and they are not nessecary. The two that I am worried about are the serial list and the part number associaiton. Sorry for the confusion. Mike

Pat here is what I have done. I opened my form: Work Order in design view, clicked the properties button. Under the Data tab I selected the Query builder. This brought up a blank query with just the Serial List table so I added the Part Number Association (PNA) Table and two other tables. I...

Works as advertised. Thank you very much!!!!! Here is exactly how I used it: Private Sub Print_Record_Click() On Error GoTo Err_Print_Record_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.PrintOut acSelection DoCmd.RunCommand acCmdRecordsGoToNew...

I have a form set to be blank when opening it using: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec CUSTOMER.SetFocus End Sub This works great. I also have it set were the last tab stop is a command button that does two things A) it prints the form and B) it brings up a new record...

I am trying to create a combo box in a form that gets its data from one table and saves it in another. I have my main table called serial list. When you use the Work Order form all data entered goes into the serial list table. The fields ranges from the customer to the part number to the...