I am trying to set things up so that the user can use the PageUp and PageDown keys when viewing a report in the CR Viewer Control in a VB app. However, even though KeyPreview is set to true in the underlying form, the form's KeyDown event isn't being fired. Does anybody know how to capture the...
I use the following stored procedure to assign the next invoice number in my applcation:
CREATE PROCEDURE InvoiceNewInvoice
@nextinv int output
AS
set nocount on
while 1=1 begin
select
@nextinv = nextinv
from
system
where
pkey = 1
update
system
set...
One of my clients is running SQL2K with a database maintenance plan that runs daily specifying that the data backup (.BAK) files and transaction log backup (.TRN) be deleted after 1 week. The problem is that they are just piling up and not being deleted. Anybody have any insights as to why this...
Using CR 8.5 and the RDC I'm printing a report based on data generated by a SQL Server stored procedure. Sometimes there is no data but Crystal still prints a blank page, even tho Suppress Printing If No Records is selected in the report options. Does anybody have any insights as to why this...
I want to create a report in an Access 2000 ADP project that is based on the results of a stored procedure. The stored procedure name appears in the RecordSource dropdown list, but when I select it I get the error message "Microsoft Access can't find the object FamilyBarCodes". I...
I have a need to print a picture (actually either an Autocad .dwg or a .jpg) as part of each detail section in a report (the picture file name is part of the data record). Crystal Tech support says CRW doesn't provide such a capability. I have done it several times in reports using Videosoft's...
I am trying to (re-)attach a notebook machine running Win2K to my office network. After going through the wizard I get the following message: "The computer could not be joined to the domain because the following error has occurred: The credentials supplied conflict with an existing set of...
When logging on to an NT 4 (SP6) Workstation attached to a domain we sometimes get the following message: "The operating system was unable to load the locally stored profile. A new local profile will be created. (1450)"
Rebooting the machine and logging on (as opposed to just logging...
Is there any way in SQL 7.0 to find out how often a stored procedure has been run? I could clearly do this myself but before I go to the effort I want to find out if maybe SQL Server is doing it for me already.
Given a username I need a list of groups that the user belongs to. This is on a network managed by an NT Server set up as a primary domain controller.<br>
<br>
The function NetUserGetGroups does exactly what I want: given a PDC name and a user name it returns a list of groups that the user...
I need information on how to set up a VB program to communicate with an AS400 system. Is there, for instance, an ODBC driver available that will let me access data from an AS400 or is it more complicated than that? Any information will help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.