Search results for query: *

Hi All Quick Question I have this calculation Per: [SM]/[TW] What i want to do is before i do this, check if TW is zero- if it is then Perf=0 else carry out the operation.. Whats my best way of achieving this? Many Thanks to all.

hi all I noted the pc was still joined to an old domain that no longer existed. I changed this to workgroup called HOME and then rebooted as requested. Previously I accessed the PC with username QA and password QA. HOwever after the PC rebooted successfully this username or password no longer...

Apolgies if this is in the wrong forum, but I am hoping someone can help. In Internet Explorer when I open a page that contains a java applet that displays a graph I can see the graph ok. However when I go to Print Preview the graph disappears and i only see a blank space where it should be...

Hi all, As title states... Cell A6= TEST If i enter =A6 into cell B1 I get returned =A6. and NOT 'TEST' as I would have hoped. Am sure this is a simple one but cant find whats wrong?!

Hi all, I have this macro: Dim r As Integer, c As Integer, n As Integer For r = 2 To 5 n = 0 For c = 1 To 10 If Cells(1, c) <> Cells(r, c) Then n = n + 1 Next c If n Then MsgBox "Row 1...." & r & "=" & n & " Parts different" Next r Rather than output it in a MsgBox is it possible...

Hi all, I ahve this macro: Dim r As Integer, c As Integer, n As Integer For r = 2 To 5 n = 0 For c = 1 To 10 If Cells(1, c) <> Cells(r, c) Then n = n + 1 Next c If n Then MsgBox "Row 1...." & r & "=" & n & " Parts different" Next r Rather than output it in a MsgBox is it possible...

hi All, Is it possible to use two fields and pass using OpenArgs? Dim strName As String strName = Me.PriceList DoCmd.OpenForm "frmPriceAdd", DataMode:=acFormAdd, WindowMode:=acDialog, _ OpenArgs:=strName Currently I open frmPriceAdd and PriceList is passed across. However I would like it...

Hi All, I created the following query: SELECT ListContent.* FROM tblListContent INNER JOIN [SELECT ListID, PartID, Max(EffectiveDate) AS MDate FROM tblListContent GROUP BY List, PartID]. AS q1 ON (tblListContent.ListID = q1.ListID) AND (tblListContent.PartID = q1.PartID) AND...

hi All, I have a spreadsheet with 5 rows and 10 columns. Each row details which 10 parts makes up that product. Each cell has a numeric input. What i want to do is compare Product 1 (Row 1) to Product 2 (Row 2) and COUNT the number of different parts between the two Products. I want to record...

hi all, i wish to carry out some detailed analysis of ROWS of data in excel. Each row has 10 columns on data. There are 5 rows. What i want to do is compare row 1 with row 2 and count the number of differences between the 10 columns of numbers. I will then count the differences between rows 1...

Hi All, I have a table that contains info about products: Product: Product 1 Price: 6.99 Effective From: 01/01/2002 Product: Product 1 Price: 9.99 Effective From: 01/01/2006 As you can see I record any changes in price so that we have an historical record of price increases. What i want to...

Hi All, I have a particular problem that I have not seen before nor know the best approch to solve. TO explain... User_1 creates a list of items that makes up a product. Each item has a cost, so I created a query to look up the corresponding cost. User_2 is responsible for costs. All he does...

Hi All, We have some CAT5 in an office running back to our cab. However we have re structured the office somewhat and now need the CAT5 to run to the other side of the office. Is there a way of simply extending the cable or do I need to run new cable from the cabinet down again? Many thanks...

Hi all, im having some trouble getting the timer func to work in a macro in excel. What i want to do it set it up to run automatically every 10 minutes to refresh the links in the worksheet.. ActiveWorkbook.UpdateLink Name:="C:\Master.xls", Type:= _ xlExcelLinks How can I achieve this...

hi all, when i complete an input form, i want the form to reload with the primary key ProductID to be increased by 1. ProductID is an integer field (Not AutoNumber due to reasons elsewhere). What I want is when i complete input for record with ProductID= 1 and click on finish I want the form...

Hi All, I wish to create forms to add a record to a table. The user wil be asked to fill in several fields, then click Next to progress to the next form until they have completed all the necessary fields. i wish to break it up due to the sheer volume of fields required. The records are unique...

Hi guys, Just a quick one.. i have my own navigation buttons on a form- the user cant add records to a form, what i want is when the user clicks the Next button and if there are no more records to display then it shows a custom error message? Cheers

Hey all, I have a query that i need to sort- BUT it needs to be sorted on a field ReferenceNo . The ReferenceNo is a text field- it contains letters and numbers. If I click to sort this Ascending, i get the following sorted output: 1a 10 2a 2b 20a 23a 3 What I need is obviously: 1a 2a 2b 3...

Hi all, I have a form that allows edits via a pop up form. When a user changes something on the pop up form, and clicks save, I want the main form to reflect these changes immediately. The main form is filtered so I would want it to update and stay on the record the user was last at. I tried...

Hi, Im running a form that opens a pop up form and filters results. Main form gives Product Details, pop up form allows editing of price. The main form has: ProductID Price Effective Date Pop up form opens this record for modification- it does this by taking the productid, price, date as...