Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 18 of 18
Search took 0.01 seconds.
Search: Posts Made By: markw707
Forum: Javascript How-To December 29th, 2006, 12:28 PM
Replies: 0
Views: 1,146
Posted By markw707
Keep track of checkboxes checked in one CASE stmt

I want to keep track of checkboxes checked or unchecked in a page that has hundreds of checkboxes. My approach is to name each TD, then capture the name and the checked or unchecked status of each...
Forum: Access September 13th, 2005, 03:53 PM
Replies: 18
Views: 5,116
Posted By markw707
I don't think it's that difficult: 1. Make 3...

I don't think it's that difficult:

1. Make 3 queries that will each pull one column from the table.

2. Open a new query in SQL view.

3. Make a union query as follows:

SELECT * from Query1...
Forum: Access September 13th, 2005, 03:02 PM
Replies: 10
Views: 1,515
Posted By markw707
Here is a good book for tips on upsizing that...

Here is a good book for tips on upsizing that will save you a ton of time: Microsoft Access Developer's Guide to SQL Server by Mary Chipman and Andy Baron

Chapter 1 is worth the price of the book...
Forum: ASP.NET 1.0 and 1.1 Basics May 13th, 2005, 09:10 AM
Replies: 0
Views: 1,380
Posted By markw707
Need DSN Connection Code to Access DB

Hello. My ASP.NET web hoster, NetworkSolutions requires a DSN to connect to an Access database. My Wrox book, Beginning ASP.NET 1.1 using C# only has the code for a DSN-Less connection to the...
Forum: Access February 15th, 2005, 07:14 PM
Replies: 1
Views: 837
Posted By markw707
Does Replication Kill Crosstab Queries?

I replicated my Access database. Afterwards, I noticed that my crosstab queries BLOW UP Access when I try to run them (Access terminates with prejudice). I tried to look at one of my crosstab queries...
Forum: Access January 19th, 2005, 05:59 PM
Replies: 1
Views: 1,389
Posted By markw707
Determine logged on users

I want to determine logged on users. I tried the code at MS Support http://support.microsoft.com/kb/198755/EN-US/#2, but it didn't work. Any help is greatly appreciated!

Mark J. Weisberger
Forum: Access November 19th, 2004, 10:55 AM
Replies: 0
Views: 910
Posted By markw707
Test for completeness of last record in cont. form

I'm using a continuous form to obtain input. I use If IsNull(Me.Field1) to verify existence of input in each record's OnUpdate event. In the footer I have an exit button. I want this button to verify...
Forum: Access September 17th, 2004, 12:15 PM
Replies: 1
Views: 3,061
Posted By markw707
Need to set paper orientation and size in code

I want to set the orientation of a report to landscape and the paper size of the report to Legal in code. Is it possible? Thank you for your help.

Mark J. Weisberger
Forum: Access August 25th, 2004, 09:02 AM
Replies: 5
Views: 6,652
Posted By markw707
I'm not sure what you mean, but I got the...

I'm not sure what you mean, but I got the solution using CurrentRecord. I added a field to the underlying table called RecordCounter. Then I put this field in the input form as a bound text box. In...
Forum: Access August 24th, 2004, 06:10 PM
Replies: 5
Views: 6,652
Posted By markw707
I want to display record number in data entry form

I've made an input form with a Data Entry setting of Yes and a Default View of continuous forms. I want the sequential number of each record to show in the form. That is, record 1 has a 1 in it,...
Forum: Access June 10th, 2004, 09:02 AM
Replies: 4
Views: 2,118
Posted By markw707
Awesome!!! Kudos to you Steven and to the...

Awesome!!!

Kudos to you Steven and to the person at Microsoft who wrote the code.

Life is good.

Mark J. Weisberger
Forum: Access June 9th, 2004, 04:07 PM
Replies: 4
Views: 2,118
Posted By markw707
Need to dup a whole record in a data entry form

Is there an easy way to duplicate a whole record when entering data in a data entry form? I know I can use Ctrl ' to dup a field, but I want to dup the whole record. Is there a way to do this?
...
Forum: Access June 9th, 2004, 04:03 PM
Replies: 3
Views: 2,115
Posted By markw707
Thank you Ray and Greg for your help. I used...

Thank you Ray and Greg for your help. I used Greg's solution because it was more concise. Thanks again.

Mark J. Weisberger
Forum: Access June 9th, 2004, 09:48 AM
Replies: 3
Views: 2,115
Posted By markw707
Want Combo Box first item if only 1 item

Assume an Access form with two combo boxes, ComboBox2 is based on a query. When the user makes a choice in ComboBox1, the choices in ComboBox2 are updated by ComboBox1's After Update Event Procedure...
Forum: Classic ASP Basics December 18th, 2003, 10:16 PM
Replies: 0
Views: 1,212
Posted By markw707
JMail: How can I deal with a bad e-mail address?

I test for basic problems in the email address such as @ sign and period in the previous page, but if the email is still bad, it fries the server when the email is sent by JMail. Here's the code I'm...
Forum: Classic ASP Basics August 21st, 2003, 11:41 PM
Replies: 4
Views: 2,006
Posted By markw707
Thanks for link. I agree now with the author when...

Thanks for link. I agree now with the author when he/she says: "this variable cannot be relied upon for many situations." It's weird how HTTP_REFERER worked okay in most cases, but not in other...
Forum: Classic ASP Basics August 21st, 2003, 08:01 AM
Replies: 4
Views: 2,006
Posted By markw707
Thank you for your help. Originally posted by...

Thank you for your help. Originally posted by pgtips
The referrer is in the HTTP header and it is the user's browser that decides when/if to send it - you have no control over this.
[/quote]
...
Forum: Classic ASP Basics August 20th, 2003, 05:07 PM
Replies: 4
Views: 2,006
Posted By markw707
HTTP_REFERER Tester Sometimes Redirects OK Visitor

I use the following ASP code in pages of my site to redirect visitors to the main page of the site if they did not come from a link:

If(Request.ServerVariables("HTTP_REFERER")="") Then...
Showing results 1 to 18 of 18

 




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