# Search:

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

Page 1 of 5 1

1. ## Thread: selecting a filtered cell (Excel2000)

by cpod
Replies
1
Views
339

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

by cpod
Replies
10
Views
686

### Re: Radio Buttons (2K SR-1)

Yet another example.

by cpod
Replies
10
Views
686

### Re: Radio Buttons (2K SR-1)

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

Then in the click event for each of...
4. ## Thread: Multiple SumIF Criteria (Excel 97)

by cpod
Replies
3
Views
730

### 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. ## Thread: Calculate dates with parameter (A2K_SR1)

by cpod
Replies
2
Views
384

### Re: Calculate dates with parameter (A2K_SR1)

To find the last data of the previou month use:

=DateSerial(Year(Date()),Month(Date()),0)
6. ## Thread: Populate Listbox (WIN2000-Acc97)

by cpod
Replies
24
Views
1,276

### Re: It's never easy !!

Try putting the drive letter in:

Dir("C:Documents and SettingsabramsmMy DocumentsMagazines*.jpg")
7. ## Thread: Populate Listbox (WIN2000-Acc97)

by cpod
Replies
24
Views
1,276

### 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. ## Thread: Populate Listbox (WIN2000-Acc97)

by cpod
Replies
24
Views
1,276

### 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. ## Thread: Using forms on websites in conjunction with Access (2000)

by cpod
Replies
9
Views
551

### 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. ## Thread: Using forms on websites in conjunction with Access (2000)

by cpod
Replies
9
Views
551

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

by cpod
Replies
1
Views
370

### Re: Hyperlink Mania (97 SR1)

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

by cpod
Replies
9
Views
551

### 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. ## Thread: Curious results from Database Functions (Excel 2000)

by cpod
Replies
3
Views
418

### 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. ## Thread: On NotinList (Access 2000)

by cpod
Replies
2
Views
461

### 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. ## Thread: Excel automatically adds an = sign to all entries (97/2000)

by cpod
Replies
2
Views
441

### Re: Excel automatically adds an = sign to all entries (97/2000)

Go to Tool/Options/Transition and uncheck "Transition Formula Entry"
16. ## Thread: Unformatting Text (2k)

by cpod
Replies
1
Views
401

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

by cpod
Replies
3
Views
1,122

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

by cpod
Replies
8
Views
619

### 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. ## Thread: Data Validation (2000 SR1)

by cpod
Replies
4
Views
445

### Re: Data Validation (2000 SR1)

The other workbook has to be open for this to work.
20. ## Thread: Date question from query (A2K)

by cpod
Replies
3
Views
368

### 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. ## Thread: Search for Alt-Enter (97)

by cpod
Replies
7
Views
1,259

### Re: Search for Alt-Enter (97)

You could use the Substitute() function:

=SUBSTITUTE(A1,CHAR(10)," ")
22. ## Thread: a string within select clause? (Access 2000)

by cpod
Replies
1
Views
382

### 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. ## Thread: Comparing columns of data (Excel 97 sr2)

by cpod
Replies
3
Views
584

### 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. ## Thread: Fill Special-Work Days (2000)

by cpod
Replies
9
Views
682

### 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. ## Thread: List Box with multiple columns (XL97)

by cpod
Replies
1
Views
501

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