Search results for query: *

Hi All, I have problem that I am trying to handle in a SQL Server 2000 stored procedure. This stored procedure returns a list of records where the count from a sub-query is greater than 3. In these returned records I need to assign a priority number to groups of the records. Basically every...

Hi all, I have a stored procedure that I would like to have return the created autoid (this is the primary key field, an integer and an identity with an autoincrement of 1). However, when I run the following code I receive the following errors: Error 9 Description: An SQLParameter with...

Hi all, I have several computers running WinXP Pro where the user is a Local Admin (due to several required software packages the user must run as an Admin...). Due to this I keep finding that users are installing unwanted software (games, etc.). Does anyone know of a piece of software that is...

Hi all, I have to replace an aging LJ 4000N printer with a new one after many years of loyal service. After pricing the HP P2015x I cannot find any information about support of PJL. Does this printer have support for PJL? If not can anyone recommend a new HP laserjet that supports it but is...

Hi all, I'm running SQL Server 2000 with all the latest patches. I am backing up all of my databases and transaction logs on weekdays. My maintenance plan that handles this is supposed to delete any .TRN and .BAK that are older than 5 days. So far the .BAK files are being deleted, but not the...

Hi All, I recently depolyed an app. on several computers that I built using VB.Net 2005. All of the computers are running Win XP w/SP2 with all of the latest patches, etc. applied. On one computer whenever I run the application I get the following error: Unhandled exception has occurred in...

Hi all, I am going to split an Access 2002 database frontend and backend. I don't want to use a mapped drive connection for the location of the backend and I'm looking at a UNC connection. Any pros/cons for using this as opposed to a mapped drive connection? Thanks, jbehrne If at first you...

Hi all, I've got two reports that I finished creating recently. One report is a correspondence letter to contacts in various departments that my organization deals with. The second report contains billing data for review by the same contact. Here is the problem that I am facing. I need to...

Hi all, I wrote an application in VB 2003 that interfaces with a MS SQL database. When the user performs various tasks (adding/editing/deleting records) a form (containing 1 label) is displayed that shows the status of the task. For instance, when the user opens a form that displays data in a...

Hi all, I am trying to make a function that clears all values in text boxes on a form (a basic 'undo' option). Several textboxes and comboboxes are on different tabs. However, when I call the function and run the function nothing on the form changes... is there something wrong with the code...

Hello all, I am having problems finding an answer to row conditional formatting in VB.Net 2005 using the datagridview control on a windows form. I am pulling data from a stored procedure and dumping it into a datagridview (NOT A .NET 2003 DATAGRID). Once the data is loaded how do I change the...

Hi all, I am in a bind with a query qryDuplicateITVMatchesCorrectedUS: SELECT qryDuplicateITVMatchesUS.ITandVoucherID, qryDuplicateITVMatchesUS.Entry, qryUnMatchedUSGLData.Entry, qryDuplicateITVMatchesUS.GLSLine_No, qryUnMatchedUSGLData.Line_No, qryDuplicateITVMatchesUS.GLSLupdtdte...

Hi all, I have a report (created in CR 8.5 - connecting via ADO.Net) that runs off of a stored procedure. The stored procedure has two parameters that filter that returned data (both the fields are strings). When I run the report the report prints but no data is displayed (but if I run the same...

Hi all, I have an Access 97 database frontend (the backend is also in 97) that runs on Windows XP. Recently a user has begun to complain to me that occasionally reports are not printing. I have run this particular piece of code and the reports called to print are printing - but every once in a...

Hi all, I have created a form that is used to select a date for reporting purposes. The user selects the date from a datetimepicker and then the date is passed to a stored procedure to be saved in a sql server. After the date is inserted the form is closed and disposed off. However, after the...

Hi all, I have a form that displays data from a stored procedure in a datagridview (VS 2005). On the same form are some text boxes that users can enter values in to filter the data in the datagridview. However, when I run the code to filter the data I get this error: "Value cannot be null...

Hi all, I wrote a stored procedure that pulls data from three tables. Two of the tables are in one database and a third table is in another (database is called coa and the table name in the database is COA). These databases are on the same server running SQL Server 7.0. When I run the stored...

Hi all, I am trying to join three tables from two different sql server 7 databases. I can connect to two of the tables (they are in the same database). However, the third table 'Chart' is in another database on the same server. Whenever I run the connection function below an error is displayed...

Hi All, I have been working with an Access 97 database and have come across a weird problem (as of yet I have found no resolution...)! I have a report that pulls data from a query. The query pulls select department data depending upon what department is selected from a dropbox on a form. When...

Hi All, I am having some problem with this bit of code. I have a BeforeUpdate event that checks to see if a check box is checked. If the check box is checked and a textbox does not have any text then an error message is displayed letting the user know to enter a value. However, if the user...