Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 16 of 16
Search took 0.01 seconds.
Search: Posts Made By: tonyrosen
Forum: Excel VBA December 2nd, 2005, 12:29 PM
Replies: 1
Views: 3,578
Posted By tonyrosen
Tab Order Screwy

Okay, first I used this code to "resize" my merged cells:



VBA:

Sub AutoFitMergedCells(Target As Range)
'AutoFits a merged cell range, even though it is technically impossible
Dim...
Forum: Excel VBA November 23rd, 2005, 11:02 AM
Replies: 2
Views: 1,429
Posted By tonyrosen
PERECT! Thanks!

PERECT!

Thanks!
Forum: Beginning PHP November 23rd, 2005, 10:46 AM
Replies: 2
Views: 2,944
Posted By tonyrosen
With your header error: All header...

With your header error:

All header information MUST be before ANYTHING else on the page with no white space above it in the code.


<?
// my header information
?>
<html>
Forum: Excel VBA November 23rd, 2005, 10:36 AM
Replies: 2
Views: 1,429
Posted By tonyrosen
"Pause" Checking ...

I have a macro which runs through my ranges and checks to see if "some" of them are empty. If they are, it "pauses" (exits, but reenters upon the next range change).

This is what I came up with,...
Forum: Excel VBA November 17th, 2005, 09:59 AM
Replies: 2
Views: 697
Posted By tonyrosen
I had declared the variables as String ... once I...

I had declared the variables as String ... once I changed them to Date, it worked great.

Thanks!
Forum: Excel VBA November 16th, 2005, 03:33 PM
Replies: 2
Views: 697
Posted By tonyrosen
New Problem

Which I don't think is anything other than I'm not versed in this stuff well enough ...

Let's say you have two dates (StartDate and StopDate)

'====================================
StartDate =...
Forum: Excel VBA November 16th, 2005, 11:52 AM
Replies: 13
Views: 148,843
Posted By tonyrosen
Figured it out ... I was "finding" the wrong...

Figured it out ... I was "finding" the wrong cells. My "active" cell was REALLY the desired "active" cell plus one ... Here is the piece I fixed:

MyRow = ActiveCell.Row
'This is the Stop Date...
Forum: Excel VBA November 16th, 2005, 10:32 AM
Replies: 13
Views: 148,843
Posted By tonyrosen
On top of that, if I place a button on the page...

On top of that, if I place a button on the page to run the code, it works perfectly as well.
Forum: Excel VBA November 15th, 2005, 06:00 PM
Replies: 13
Views: 148,843
Posted By tonyrosen
Okay, here's my SUB ============= Sub...

Okay, here's my SUB

=============

Sub ValidateStopDate()
MyRow = ActiveCell.Row
'This is the Stop Date Column Number
MyColumn = ActiveCell.Column
'This is the Start Date Column Number...
Forum: Excel VBA November 15th, 2005, 02:23 PM
Replies: 13
Views: 148,843
Posted By tonyrosen
ub Worksheet_Change(ByVal Target As Range) Dim...

ub Worksheet_Change(ByVal Target As Range)
Dim WatchRange As Range
Dim IntersectRange As Range
Set WatchRange = Range("A1:A10")
Set IntersectRange = Intersect(Target, WatchRange)
If...
Forum: Excel VBA November 15th, 2005, 01:03 PM
Replies: 13
Views: 148,843
Posted By tonyrosen
Argh! It won't call my Macro ... The...

Argh!

It won't call my Macro ... The Worksheet_Change works, but it won't call the macro ... is there a syntax for that?
Forum: Excel VBA November 15th, 2005, 09:36 AM
Replies: 13
Views: 148,843
Posted By tonyrosen
Yea! I'm a superstar: Sub...

Yea! I'm a superstar:

Sub Worksheet_Change(ByVal Target As Range)
Dim WatchRange As Range
Dim IntersectRange As Range
Set WatchRange = Range("A1:A10")
Set IntersectRange = Intersect(Target,...
Forum: Excel VBA November 14th, 2005, 10:49 PM
Replies: 13
Views: 148,843
Posted By tonyrosen
Excel VBA Check When Cell Has Changed

Okay, maybe I'm just stupid ...

Let's say cell "A1" and "A2"

I want to check if "A2" changes and if so, run a macro ...

I can't get the event to fire off and, I'm sure it's because I have no...
Forum: PHP How-To November 11th, 2005, 11:40 AM
Replies: 2
Views: 4,089
Posted By tonyrosen
sure it is ... <? // make your database...

sure it is ...

<?
// make your database connection
// grab recordset
// check to see if the recordset is empy
if ($your_record_set is empty) {
header("Location: /page.php");
} else {
//...
Forum: Access VBA November 9th, 2005, 02:14 PM
Replies: 3
Views: 1,094
Posted By tonyrosen
It's a brand spankin' new form, so option 2 looks...

It's a brand spankin' new form, so option 2 looks like it'd work well ... now, i have to figure it out ...

Thanks!
Forum: Access VBA November 9th, 2005, 10:41 AM
Replies: 3
Views: 1,094
Posted By tonyrosen
Read MSWord From Access?

I have a MSWord document that has a table with 8 rows and 2 columns. The first column lists questions (1 per row). The second column is answered either "yes" or "no".

Is there a way to retrieve...
Showing results 1 to 16 of 16

 


All times are GMT -4. The time now is 10:35 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.