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 14 of 14
Search took 0.01 seconds.
Search: Posts Made By: jack123
Forum: Access August 8th, 2007, 04:56 PM
Replies: 3
Views: 1,425
Posted By jack123
Actually I am looking to have this done without...

Actually I am looking to have this done without hardcoding as once I am done with this report format, I need to pass paramter to manipulate few other fields that i do not have here. Any more...
Forum: Access August 8th, 2007, 09:39 AM
Replies: 3
Views: 1,425
Posted By jack123
Grouping with calculated field in report

Hi,
I got a access table which is like the following

Group Description Amount
3000 Net Sales 100000
5000 Total Var Cost 75000
7000 Total Other...
Forum: Access August 2nd, 2007, 02:08 PM
Replies: 1
Views: 1,022
Posted By jack123
Never mind folks. Problems solved. I was not...

Never mind folks. Problems solved. I was not looking carefully enough in the fields where two of those were mismatch with the output from stored procedure. Thanks anyway.
Forum: Access August 2nd, 2007, 01:01 PM
Replies: 1
Views: 1,022
Posted By jack123
How to resolve #Name? Error problem in few fields

Hi,
I am calling a stored procedure from an Access unbound form.I made sure that the control source of the unbound form is named in accordance with the output of the stored procedure. However, in...
Forum: SQL Server 2000 July 27th, 2007, 03:34 PM
Replies: 1
Views: 887
Posted By jack123
Why is multiple record not getting displayed

Hi,
I am using a simple stored procedure from the pubs database to get a resultset. The stored procedure code is as follows:
CREATE PROCEDURE sp_select
@type varchar(40),
@royalty int
AS...
Forum: Access VBA July 26th, 2007, 02:32 PM
Replies: 0
Views: 3,313
Posted By jack123
You can't exit Microsoft Access now

I am having an error in Access 2000 with sqlserver backend. IF you are running a visual basic module that is using OLE or DDE, you may need to interrupt this module. I have no idea why this error is...
Forum: SQL Server 2000 July 20th, 2007, 02:15 PM
Replies: 1
Views: 1,487
Posted By jack123
Simple yet confusing

Hi,
I have a procedure where the following line of code is included:

strTSQL = "EXEC sp_gettitles " & lngParam

However, in the above lngParam is a long value.
How will the code change if...
Forum: SQL Server 2000 July 19th, 2007, 03:57 PM
Replies: 1
Views: 2,175
Posted By jack123
Using stored procedure to open Access reports

Hi,
I am trying to find out how to integrate stored procedure with an Access report. For test purpose, I am trying the following procedure out of pubs database:
create procedure sp_gettitles
@type...
Forum: SQL Server 2000 July 17th, 2007, 09:57 AM
Replies: 3
Views: 588
Posted By jack123
Thanks Vijay, He could connect to the...

Thanks Vijay,
He could connect to the application before. But not right now any more.
Forum: SQL Server 2000 July 16th, 2007, 05:04 PM
Replies: 3
Views: 588
Posted By jack123
Sql Server does not exist or access is denied

Hi,
We have a access sql application that is being used by various users. One of the user is getting the above message and I am not sure why he is getting this message. He cannot connect to sql...
Forum: SQL Server 2000 July 11th, 2007, 05:02 PM
Replies: 2
Views: 1,056
Posted By jack123
Folks This work now. I do not know why it was...

Folks
This work now. I do not know why it was not working before. Anyway,
Thanks for viewing.
Forum: SQL Server 2000 July 11th, 2007, 01:31 PM
Replies: 2
Views: 1,056
Posted By jack123
Code running without any result

Hi,
I am running Access form to pass parameters to a stored procedure in sql server backend in the pubs database to update records. However, the code is working but the results are not. This means...
Forum: SQL Server 2000 July 11th, 2007, 12:09 PM
Replies: 4
Views: 926
Posted By jack123
Hi Folks, I checked my sql server name and sure...

Hi Folks,
I checked my sql server name and sure enough it did not match the sql server name that I have in code. After changing the name the problem got resolved. Thanks a lot guys and especially to...
Forum: SQL Server 2000 July 11th, 2007, 10:18 AM
Replies: 4
Views: 926
Posted By jack123
What's wrong with this code

Hi,
I got an ado code which I am running from Access 2000 front end. THis code is supposed to run a stored procedure on sql server backend by passing parameters to update records. However, I am...
Showing results 1 to 14 of 14

 


All times are GMT -4. The time now is 03:53 AM.


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