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 17 of 17
Search took 0.01 seconds.
Search: Posts Made By: dlandolin
Forum: Classic ASP Basics July 30th, 2012, 11:37 AM
Replies: 0
Views: 1,520
Posted By dlandolin
Get selected value of dropdwon box using postback

Hi,
When an item in my drop down box is selected my onchange event fires and a vb function is supposed to display a msgbox containing the selected value of the box. I know this sounds simple but I...
Forum: Classic ASP Basics July 14th, 2011, 03:28 PM
Replies: 0
Views: 1,437
Posted By dlandolin
Open a PDF from ASP

I'm accepting an invoice number through a text box on a form in an asp. I want to open the corresponding invoice (pdf file) which is located on another server on my network. How can I accomplish...
Forum: Access VBA June 9th, 2011, 08:52 AM
Replies: 4
Views: 2,418
Posted By dlandolin
Thanks - but I would still need to use the Len...

Thanks - but I would still need to use the Len function within the Mid to determine how many characters are to the right of the 4th. Ex: mid(4,Len([ship_via])-4)
Forum: Access VBA June 8th, 2011, 01:40 PM
Replies: 2
Views: 3,109
Posted By dlandolin
I would just use a form with its default view set...

I would just use a form with its default view set to Continuous Forms and its recordsource set to your query. This way I could program events behind each field displayed if I wanted.
Forum: Access VBA June 8th, 2011, 08:45 AM
Replies: 4
Views: 2,418
Posted By dlandolin
Hi gbianchi, Thanks for responding. I am...

Hi gbianchi,

Thanks for responding. I am still struggling with this.
There are no null values in the ship_via field.
As for the code - Our FedEx ship vias looks like this "FGR:332158321". The...
Forum: Access VBA June 7th, 2011, 05:21 PM
Replies: 4
Views: 2,418
Posted By dlandolin
Invalid Procedure Call

Hello,

This query returns an "Invalid Procedure Call" error because of the Len function:
SELECT DISTINCTROW tbl_Launch_L.CO_NUMBER, tbl_Launch_L.FRT_CHG_CD, tbl_Launch_L.Ship_Via,...
Forum: Access June 6th, 2007, 10:15 AM
Replies: 1
Views: 1,063
Posted By dlandolin
Report Displays Only One Record

Hello,
I have a report that should list all records with a particular identifier. If there is more than one record only the first record will show on the report. The query that I am using for the...
Forum: Access VBA June 6th, 2007, 10:12 AM
Replies: 3
Views: 1,004
Posted By dlandolin
Thanks Mccoy. I was neglecting to reference the...

Thanks Mccoy. I was neglecting to reference the columns.
Forum: Access June 5th, 2007, 11:01 AM
Replies: 3
Views: 7,163
Posted By dlandolin
Kevin, Thanks for responding. I wanted to...

Kevin,

Thanks for responding. I wanted to loop through them whether they were selected or not. This is how I got it to work:
For i = 0 To lstCheckOut.ListCount - 1
Me!lstCheckOut.SetFocus
data...
Forum: Access VBA June 5th, 2007, 09:52 AM
Replies: 3
Views: 1,004
Posted By dlandolin
How can I Reference Value in Listbox

Hi,
I've been struggling with this seemingly simple problem for two days now!! How can I reference a value in a listbox? Nothing I try seems to work!! This is my current code:...
Forum: Access June 5th, 2007, 09:50 AM
Replies: 3
Views: 7,163
Posted By dlandolin
How can I Reference Value in Listbox

Hi,
I've been struggling with this seemingly simple problem for two days now!! How can I reference a value in a listbox? Nothing I try seems to work!! This is my current code:...
Forum: SQL Server 2000 September 21st, 2005, 08:06 AM
Replies: 1
Views: 1,414
Posted By dlandolin
When a sproc or table was Last Used

How can I determine when a sproc or table was last used?
I suspect that I have many obsolete tables and sprocs in my database but how can I find out for sure??
Thanks,
DL
Forum: Access June 29th, 2005, 09:35 AM
Replies: 2
Views: 1,190
Posted By dlandolin
Conversion Question

I'm converting a database from Access 2.0 to 2003. This database has
some attached tables. What happens to the attached tables during the
conversion process? I would hope they would remain...
Forum: SQL Server 2000 February 23rd, 2005, 06:18 PM
Replies: 3
Views: 729
Posted By dlandolin
Not sure why that works - but it does. Thanks.

Not sure why that works - but it does. Thanks.
Forum: SQL Server 2000 February 23rd, 2005, 05:59 PM
Replies: 3
Views: 729
Posted By dlandolin
Interesting Data Type Problem

The following query returns .038461 as it should:

select (2.0 + 0.0 + 0.0)/52 as x

However, when the numeric literals are replaced by either variables or field names the result is completely...
Forum: Classic ASP Basics July 18th, 2003, 10:22 AM
Replies: 0
Views: 746
Posted By dlandolin
DTS Quagmire

I am using DTS to export seven tables from Sql to Excel.
The structure and field names of each table are exactly the same.
However, each table has a different name.
I'm using a global vaiable...
Forum: Classic ASP Basics July 14th, 2003, 11:33 AM
Replies: 0
Views: 1,251
Posted By dlandolin
ASP and xp_sendmail

I created a stored procedure which creates some sales reports.
At the end of the sproc I use xp_sendmail to email the reports to specific users.
This works wonderfully.

However, when I execute...
Showing results 1 to 17 of 17

 




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