Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rjm65
  • Content: Threads
  • Order by date
  1. rjm65

    Wireless Routers

    I see most wireless routers have 4 ports for ethernet, but one thing I'm not sure about is how many wireless computers can utilize the router?
  2. rjm65

    Dell Computer and New Hard Drive Install

    I have a Dell Dimension 2400 computer that I want to install a new larger master hard drive. The computer currently has a 30GB hard drive. I would like to remove the 30GB hard drive, reformat, and use as a slave on an older computer. Will I be able to reinstall the XP operating system that...
  3. rjm65

    Beginner FrontPage Database Question

    I have a website that I created with FP2003 that shows our product line. Each item gets it's own page. I would like to display the selling price for each item on it's respective page, but have it linked to a database so that I can update prices via the database and not have to go to each page...
  4. rjm65

    Database Beginner Question

    I have a website that shows our product line. Each item get's it's own page. I would like to display the selling price for each item. Can I set up a database to do this with FrontPage? It seems that future price increases would be easier to update one database file rather than having to go to...
  5. rjm65

    Layer within a Cell

    Can a layer be contained within a cell of a table using FrontPage 2003? I have a table 2 rows x 3 columns (fixed width at 800pixels). The top row is merged, the bottom row has a menu in the left cell, a picture in the middle cell, and text in the right cell. Is there a way I can add a layer to...
  6. rjm65

    Excel - Formula Loses Reference After Sort

    Area G10:AP122 has it's cells filled with a simple formulas like =K8*6. The formula in the cells always references row 8 (Quanity Required) in their respective column. The *6 can vary from cell to cell, it is not a fixed value. The problem is I should've written the formula(s) as =$K$6*6...
  7. rjm65

    AutoCAD R14 Calculations Possible?

    Hello, First off let me start off by saying I have no knowledge of AutoCAD other than being able to print out a drawing. Our in-house guy that does our CAD drawings has a somewhat limited knowledge of AutoCAD 14 that we use. My basic question is, can dimensions be calculated based upon user...
  8. rjm65

    Excel -- Can A Drop Down List Select A Graphic

    I have a worksheet that has a drop down list with 6 choices. I would like a graphic (jpg, gif or bmp)to appear on the worksheet that matches the choice selected in the drop down list. Is this within the capabilities of Excel?
  9. rjm65

    Excel - Woodworking Cut Sheet Possible?

    I'm wondering if this is possible to do in Excel. We make bookcases and would like a quick way of creating "cut sheets" based on the sizes of bookcases on order. I can get our sales order program to export into excel a list of bookcases on order, model numbers in column A, and quantity on order...
  10. rjm65

    SBT 5.0i - Printing SO to SBS 4.5 Fax Server

    Not sure if this is an SBT or SBS fax server issue. All works well when I manually enter the receipientfax number when using the SBS fax server, but if I use the address book to select a fax number, after clicking on "finish" to begin the faxing process, the following error message appear from...
  11. rjm65

    Formatting Number in Excel

    In Cell B1, my formula is ="Traditional Bookcase (Flush Cut $"&(ROUND(F1*10),2)&" per side)") F1 has a multiplier the user enters, F1 is formatted as a number with 2 decimal places. Depending on the number I enter in F1, I get answers that vary in length, I would like them to always appear...
  12. rjm65

    Data Validation -- Drop Down List on Error

    I have an order form, column 1 is quantity, column 2 is item number, column 3 is description, and column 4 is cost. Columns 3 and 4 are automatically filled in using VLOOKUP. I use Data Validation in column 2 so that the part number must be typed in correctly. We have about a thousand different...
  13. rjm65

    Uploading Pictures to Discussion Board FP2002

    I am using FrontPage 2002. I found a template for creating a discussion board in the FrontPage wizards. Is it possible to add an image upload capability? That is, we want the users to be able to post a message and if necessary upload a picture that can be seen below the message. Also, I didn't...
  14. rjm65

    Excel Unprotect/.Protect Properties

    When using the following: ActiveSheet.Protect Password:="my password" Is there someway to set it up so that only unlocked cells can be selected? Thanks, Raymond
  15. rjm65

    Delete Toolbar on close of Excel

    How can I delete a custom toolbar that I have created on the close of Excel? I have a macro that saves as , closes the saved workbook, and opens the original workbook. I need to delete the toolbar when Excel is closed so that it only appears when my user is working with the file I created for...
  16. rjm65

    Excel File Save As using Cell Value Info

    I have the following code so that the file save name will be the contents of cell B1, plus the date and time: SuggName = Left(Sheets("PO").Range("B1"), 5) _ & ("_") & Application.Text(Now(), "mmddyy") & "_" & Application.Text(Now(), "hhmm") & ".XLS"...
  17. rjm65

    Formatting Autofilter Results in Excel

    I have 4 columns, A is quantity, B is part#, C is description, D is cost, E is my extended cost and all together about a thousand rows worth of product information. The user inputs a number in column A. I then run the following so that only those rows with a qty appear: ActiveSheet.Unprotect...
  18. rjm65

    Excel Vlookup Error

    I found the following in Excel VBA Programming for Dummies. Sub GetPrice() Dim PartNum As Variant Dim Price As Double PartNum = InputBox("Enter the Part Number") Sheets("Prices").Activate Price = WorksheetFunction. _ VLookup(PartNum, Range("PriceList"), 2, False)...
  19. rjm65

    Excel Autofilter Question

    Whenever I apply Autofilter to an area, a small drop down arrow icon appears at the top of the column, is there anyway to not have this appear? The autofilter is applied by a macro activated by a button, and I don't want the user to accidently further filter the results. Thanks, Raymond
  20. rjm65

    Excel Print Area Adjust

    This is my first time ever using a macro, so I'm not sure of what's possible or not. I have an Excel spreadsheet with 4 columns, Column A is quantity, Column B is item code, Column C is item description, and Column D is item cost. I have placed a button on my sheet that uses the code found...

Part and Inventory Search

Back
Top