Base issue, is I'm trying to define a basic application to assist in the calculating the approximate weld length for reporting purposes for our project mangers.
For example:
Size 200 pipe schedule 30 has the following attributes:
Wall thickness = 7.04 mm
Outside Diameter = 219.1 mm
Inside...
select table2.field1,tabel1.field2
from table1,table2
where instr(table1.field1,table2.field1)>0
try this, should give you the basics
Technological progress is like an axe in the hands of a pathological criminal
We looked at software packages around but decided to create our own, where we receive 98% of our drawings in electronic format we then stamp them via our software and then merge them into a database for cross reference, since we introduced this we reduced our lead time and all documents are now...
Best method would be to create a new table:
Addressbook_temp
run a script thus:
insert into Addressbook_temp
select ID,FirstName,LastName,City,State,Zip from addressbook
group by ID,FirstName,LastName,City,State,Zip
delete the old table addressbook and then rename Addressbook_temp to...
try this:
Sub DeleteEmptyRows(DeleteRange As Range)
' Deletes all empty rows in DeleteRange
' Example: DeleteEmptyRows Selection
' Example: DeleteEmptyRows Range("A1:D100")
Dim rCount As Long, r As Long
If DeleteRange Is Nothing Then Exit Sub
If DeleteRange.Areas.Count > 1 Then Exit Sub...
