Search:

Type: Posts; User: cpod; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    290

    Re: selecting a filtered cell (Excel2000)

    Try something like this:

    Dim rng As Range
    Set rng = Worksheets("sheet1").Range("a2:a100").SpecialCells(xlVisible)
    rng(1).Select
  2. Replies
    10
    Views
    596

    Re: Radio Buttons (2K SR-1)

    Yet another example.
  3. Replies
    10
    Views
    596

    Re: Radio Buttons (2K SR-1)

    Assuming you have:
    a user form called Userform1
    a group of radio buttons for your products
    another group of radio button called Red, Blue, Green and White

    Then in the click event for each of...
  4. Replies
    3
    Views
    621

    Re: Multiple SumIF Criteria (Excel 97)

    If I understand what you are trying to do then:

    =SUM((A3='date-aging'!$A$12:$A$24)*(NOT(ISERR(SEARCH("C",'date-aging'!$B$12:$B$24)=FALSE)))*'date-aging'!$C$12:$C$24)

    This sums all values in...
  5. Replies
    2
    Views
    323

    Re: Calculate dates with parameter (A2K_SR1)

    To find the last data of the previou month use:

    =DateSerial(Year(Date()),Month(Date()),0)
  6. Replies
    24
    Views
    1,157

    Re: It's never easy !!

    Try putting the drive letter in:

    Dir("C:Documents and SettingsabramsmMy DocumentsMagazines*.jpg")
  7. Replies
    24
    Views
    1,157

    Re: Populate Listbox (WIN2000-Acc97)

    I was mistaken when I said Access help files. It's actually under "Row Source Type" in the Visual Basic help files.

    No, you have the right control. You have to choose an image file when you add...
  8. Replies
    24
    Views
    1,157

    Re: Populate Listbox (WIN2000-Acc97)

    This really isn't too difficult. The function below is from the Access help files. All you have to do is insert a module into your database and paste the ListJPGs function into it. You will have to...
  9. Re: Using forms on websites in conjunction with Access (2000)

    Yes, you can do this. I'm not saying it's easy but it can be done.

    Essentially, the webbrowser control (through the Document property) exposes the webpage HTML, and by changing elements of the...
  10. Re: Using forms on websites in conjunction with Access (2000)

    Yes, HansV is correct. I did mean to say the Toolbox not Tools on the menu. Sorry for the the error.
  11. Replies
    1
    Views
    313

    Re: Hyperlink Mania (97 SR1)

    I have one spread sheet with some 800 hyperlinks in it with no problems.
  12. Re: Using forms on websites in conjunction with Access (2000)

    You can use the WebBrowser control (on the Tools menu click on the additional tools button and scroll down to "Microsoft Web Browser").

    This control allows you to access the web a page, enter data...
  13. Re: Curious results from Database Functions (Excel 2000)

    I'm not sure what your question is. Your function seems to work. I did get #Value in the functions referencing A4:A5. That cleared up when I copied A8:A9 and pasted to A4:A5 (bizzare). If this...
  14. Replies
    2
    Views
    369

    Re: On NotinList (Access 2000)

    Access doesn't like odd charaters in field names. Just put brackets around it:

    ![IN_Cut#] = Forms![frmEnter_Cut#].[WCut#]
  15. Re: Excel automatically adds an = sign to all entries (97/2000)

    Go to Tool/Options/Transition and uncheck "Transition Formula Entry"
  16. Replies
    1
    Views
    319

    Re: Unformatting Text (2k)

    First determine whether the phone number is stored as (999)999-9999 or whether it is actually stored as 9999999999 by adding "0000000000" to the format property of the field in your query. Now run...
  17. Replies
    3
    Views
    898

    Re: Adding up sheets (Excel 97)

    The syntax to sum the same cell on multiple sheets:

    =SUM(Sheet1:Sheet5!A1)

    This will add the values in cell A1 for all sheets from sheet1 to sheet5.
  18. Replies
    8
    Views
    467

    Re: If...then (2000-2002)

    You could use the Switch function:

    : Switch([score] Between 90 And 100,"A",[score] Between 80 And 89,"B",---and the rest---)
  19. Replies
    4
    Views
    380

    Re: Data Validation (2000 SR1)

    The other workbook has to be open for this to work.
  20. Replies
    3
    Views
    311

    Re: Date question from query (A2K)

    Just add this to the criteria for EndDate to return records for the last day of the next month.

    :DateSerial(Year(Date()),Month(Date())+2,0)
  21. Replies
    7
    Views
    907

    Re: Search for Alt-Enter (97)

    You could use the Substitute() function:

    =SUBSTITUTE(A1,CHAR(10)," ")
  22. Replies
    1
    Views
    323

    Re: a string within select clause? (Access 2000)

    You just have the quotes a little off:

    strLondon= " SELECT products.Productid, products.code, products.grade, products.size, products.pack, " & strNest & " FROM products ORDER BY products.code;"
  23. Replies
    3
    Views
    488

    Re: Comparing columns of data (Excel 97 sr2)

    I would add a column a formula to compare the two columns, something like:

    =if(A1=B1,0,1)

    This will give you a 0 if they match and a 1 if they don't, you can then sort on that column which will...
  24. Replies
    9
    Views
    562

    Re: Fill Special-Work Days (2000)

    If you put your starting date in A1 and copy down this formula:

    =IF(WEEKDAY(A1)=6,A1+3,A1+1)

    It will return just weekdays. Holidays would be a bit more difficult
  25. Replies
    1
    Views
    415

    Re: List Box with multiple columns (XL97)

    Just set the second column to length 0:

    lstCountry.ColumnWidths = "100 pt;0pt"
Results 1 to 25 of 120
Page 1 of 5 1 2 3 4