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 25 of 102
Search took 0.01 seconds.
Search: Posts Made By: bph
Forum: Access VBA October 22nd, 2010, 10:10 AM
Replies: 1
Views: 3,434
Posted By bph
Man O Man, I'm a knucklehead!! After 9...

Man O Man, I'm a knucklehead!!

After 9 hours of banging my head off the wall, I found the problem. The excel file that is created and sent to us had the correct filename, but a different...
Forum: Access VBA October 21st, 2010, 10:56 PM
Replies: 1
Views: 3,434
Posted By bph
The search key was not found

Hi,

I have a problem with and excel 2007 import into Access 2007. I have setup a saved import in Access named Import_Weekly_Terms which appends records to a table in the database from an Excel...
Forum: Access VBA September 16th, 2010, 10:53 PM
Replies: 3
Views: 4,078
Posted By bph
Figured out part of the issue. I cannot put my...

Figured out part of the issue. I cannot put my conditions on the same line as the keywords. I must use the syntax:

If condition Then
statements
ElseIf condition-n Then
elseifstatements
Else...
Forum: Access VBA September 16th, 2010, 10:17 PM
Replies: 3
Views: 4,078
Posted By bph
IF ElseIf Compile Error

HI All,

Getting an error with this code. "Complie Error": Else without IF.

Seems straight forward. Thanks for any thoughts. bph

If tblWeekly_Terms.Department Like "Cana*"
Then Set...
Forum: Access VBA September 1st, 2010, 05:13 PM
Replies: 6
Views: 3,474
Posted By bph
Smile Hi Duff, Awesome!!! Thanks so much for...

Hi Duff,

Awesome!!! Thanks so much for your help.

I put that in, and it ran perfect. Sorry I didn't follow that thought in your first post. I don't understand why it needed the INNER Join...
Forum: Access VBA September 1st, 2010, 04:18 PM
Replies: 6
Views: 3,474
Posted By bph
Hi Duff, You are correct. That piece is...

Hi Duff,

You are correct. That piece is working now, don't know why it failed me before.

Is there a way to not have the prompt for the values appears? If empnum matches, go update EID table...
Forum: Access VBA August 27th, 2010, 03:55 PM
Replies: 6
Views: 3,474
Posted By bph
Thanks OP. I'll check that out. It does seem to...

Thanks OP. I'll check that out. It does seem to be real simple compared to theother stuff I have written.
Forum: Access VBA August 27th, 2010, 01:05 PM
Replies: 6
Views: 3,474
Posted By bph
RunSQL Update with Set

Howdy,

Getting an error 3144. incorrect syntax, but can't figure what is wrong.

I have 2 tables with identical columns. Table Names = tblEID and tblWT_Temp

I want to update the TermDate...
Forum: BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 January 18th, 2010, 11:52 AM
Replies: 0
Views: 1,020
Posted By bph
Transform Available

Is there an SSIS transform available that would help with this issue? I've reviewed fuzzy lookup and term extract, but don't think they will get to where I'm trying to go.

Scenario:
Table1 -...
Forum: SQL Language September 1st, 2009, 01:21 PM
Replies: 2
Views: 922
Posted By bph
Thanks. I'm perusing that info and hopefully can...

Thanks. I'm perusing that info and hopefully can draw a solution from knowledge gained.
Forum: SQL Language September 1st, 2009, 12:10 PM
Replies: 2
Views: 922
Posted By bph
Pivot?

Good Morning,

I have a 2 column table like below, where there is a variable number of procedure codes for hundreds of test codes:

TC PC
1234 ABC
1234 DEF
1234 GHI
1234 JKL
5678 MNO
Forum: Access VBA June 11th, 2007, 01:00 PM
Replies: 5
Views: 1,449
Posted By bph
Excellent help. Went with the second way. One...

Excellent help. Went with the second way.
One piece I left out is that I then delete the record from table1 after the insert is completed.

Thanks for the response! bph
Forum: Access VBA June 11th, 2007, 11:29 AM
Replies: 5
Views: 1,449
Posted By bph
Where does insert query go?

Hi,

I have two tables and one form. (table1, table2, form1)

Once the user updates info on form1 I want to check table1 to see if 3 columns = Yes. If so, I want to insert that record into...
Forum: Access January 5th, 2007, 02:09 PM
Replies: 2
Views: 833
Posted By bph
combo box

I have a form which was created based on one table, basically 13 text boxes displaying information, and I can move from record 1 to record 2 and so on.

I changed one text box to combo box (cbox1)...
Forum: BOOK: Beginning Access VBA January 5th, 2007, 01:49 PM
Replies: 1
Views: 3,054
Posted By bph
combo box

I have a form which was created based on one table, basically 13 text boxes displaying information, and I can move from record 1 to record 2 and so on.

I changed one text box to combo box (cbox1)...
Forum: SQL Server 2000 October 18th, 2006, 09:31 AM
Replies: 11
Views: 26,432
Posted By bph
Jeff, "most phone companies list duration...

Jeff,

"most phone companies list duration either as whole minutes or as decimal minutes with 6 second increments (1/10ths)."

Perhaps due to the fact that the system is working under EPOCH time,...
Forum: SQL Server 2000 October 17th, 2006, 09:38 AM
Replies: 11
Views: 26,432
Posted By bph
Jeff and Jeff, Thank you both for the...

Jeff and Jeff,

Thank you both for the insights into my issue. I have incorporated both sets code into my programming, enabling me to catch the rare occurance where an employee is on the phone...
Forum: SQL Server 2000 October 16th, 2006, 02:29 PM
Replies: 11
Views: 26,432
Posted By bph
Got it. Thanks.

Got it. Thanks.
Forum: SQL Server 2000 October 16th, 2006, 01:46 PM
Replies: 11
Views: 26,432
Posted By bph
Okay Jeff. I went with convert i/o cast and it...

Okay Jeff.
I went with convert i/o cast and it is returning results correctly.

I still have to work on the formatting. For example, if the hour, minute, or second is a single digit, the leading...
Forum: SQL Server 2000 October 16th, 2006, 01:10 PM
Replies: 11
Views: 26,432
Posted By bph
Hi Jeff, Thanks for the response. Appreciate...

Hi Jeff,

Thanks for the response. Appreciate it.

I get an error message "Incorrect syntax near 'CAST', expected 'AS'."

Line 1

Do I put that into the CASE statement, or is the case...
Forum: SQL Server 2000 October 16th, 2006, 12:05 PM
Replies: 11
Views: 26,432
Posted By bph
Convert seconds to HH:MM:SS

Hello,

I’m working in an phone system with EPOCH time representing DateTimeConnect and DateTimeDisconnect and have those columns coded to successfully convert to a date time output.
My...
Forum: Reporting Services August 8th, 2006, 01:44 PM
Replies: 0
Views: 1,404
Posted By bph
Reporting Services Install Issue

Hi,

I have looked in numerous places to see if I can find an answer to the issue I am having installing SQL2k5, Reporting Services.

My system is Windows 2003 SP1, 64 Bit. The entire 2k5...
Forum: SQL Server 2000 January 26th, 2006, 02:04 PM
Replies: 9
Views: 1,656
Posted By bph
You're probably right. thanks for the help...

You're probably right. thanks for the help everyone.
Forum: SQL Server 2000 January 25th, 2006, 03:39 PM
Replies: 9
Views: 1,656
Posted By bph
I exported the data to a test table, and then the...

I exported the data to a test table, and then the properties and the select coutn(*) are the same at 391.

Wierd.
Forum: SQL Server 2000 January 25th, 2006, 03:37 PM
Replies: 9
Views: 1,656
Posted By bph
I'm using select count(*) from tablex and get...

I'm using select count(*) from tablex and get 391.

463 comes from properties in SQL EM
Showing results 1 to 25 of 102

 


All times are GMT -4. The time now is 01:00 AM.


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