Search results for query: *

the legend that is PHV.

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.

So if i cant remember any of the LOCAL user accounts nor the ADMINISTRATOR password then whats my options?

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?!

In case it helps others here is a solution I have just done: Dim imagepath As String Part = Forms!frmPart!PartID imagepath = "c:\temp" & "\" & PartID & ".pdf" Me.pageDrawing.SetFocus objWebBrowser.Navigate imagepath

Product A 1 2 3 4 5 1,2,3,4,5 are unique IDs to identify a part name. e.g. 1= Front Grey 2= Back grey 3= Red front 4= Black Sides 5= White Front These 5 parts make up Product A. Product B 1 2 3 4 6 Part 6= Yellow Back If we compare Product A to Product B there are FOUR...

Each product uses 10 unique parts. All that I am intested in is comparing the differences between the 2 sets of 10 numbers. It needs to loop through comparing all nine products to product A (starting point) and output this. It will then find the lowest difference and copy this product into...

Hi Bong, Each product has 10 UNIQUE parts.... So if Prod_A uses 1,2,3,4,5 Prod_B uses 1,2,3,4,6 Prod_C uses 1,3,6,7,8 Id make Prod_B after Prod_A as they share 1,2,3,4 whereas Prod_C only uses 1,3. if you catch my drift..... :)

Hi Glenn, Thanks for the tip! Sorry to ask, but am I going about this in the right way? To explain what I want to achieve is this: I have 10 products(rows) in a spreadsheet with 10 columns. Each cell contains an integer to identify a part which makes up that product. I want to find the...

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 Skip/All, Ignore my previous post, I have been playing about with it... I now get the error in MS Query: Could not add the table ''c:\tool\Book1'.Sheet5$''. any idears....?

Skip, Mnay thanks for the heads up on Query. Its not something I have used before, it would be much appreciated if you can point me where I am going wrong... in order for your query you shown me to work how was the spreadsheet constructed? Like this? Col A Col B 1 1 2 2 etc?

hi formerTexan, How do I conctenate the two fields?...>>> strName = Me.PriceList ; Me.PartID it doesnt like that.... :(

Hi Bong, Not really, as each cell contains a PartID, with parts going up to 250, summing them will not work?

Hi Bong, All i want to know is the number of different parts are different, what parts they are doesnt matter. From the number of differences i can work out downtime etc.

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