Search results for query: *

SELECT TOP 5 PERCENT dbo_FormReportSS.UPC, dbo_FormReportSS.ItemDesc, dbo_FormReportSS.WhseNum, dbo_FormReportSS.PriceOnly, dbo_FormReportSS.CaseCost, dbo_FormReportSS.UnitsCase, dbo_FormReportSS.UnitCost, dbo_FormReportSS.[GM%], Sum(dbo_FormReportSS.LstWght) AS SumOfLstWght...

Hi I am Running SQL Server 2000 on Windows 2000. Backup started at 6:00PM and is still going at 10:00AM. My old backup was part of a "Database Maintenence plan" so i expected it to take some time. The new database maintenence plan is only a a complete backup to the tape drive...

Hi, I am trying to execute a stored procedure in the onclick event of a command button. I already have the stored procedure working, i just need to be able to execute it. Here is what i have so far.. RunDTS is the name of my stored procedure. Private Sub ImportNewItems_Click()...

Is there a way to program a command button to print a report with. 1. 4 pages per sheet 2. A select amount of pages (user defined through a input box or textbox) I have tried to set the print settings on the report and it seems that if i use a button they get reset. Thanks in advance, JF

Hello, I have a query that i thought should be pretty straitforward: SELECT * FROM SEASIA.RUMBA400.FMSV3DB05.ARCUST CustomerList 33 records (it is querying from a linked AS400 server) The wierd think is there are 1500+ rows in the table on the AS400 and the query only returns 35 of...

Hi, I have a SQL server that I was trying to link to another SQL server. When I Removed the link I can no longer view any tables or views! I get a message that there are files missing or not registered. Has this ever happened to anyone else before? The data files and transaction logs are...

Hi, I am trying to link my SQL server 2000(enterprise manager) to an AS/400 server. I was going to use Client access for a ODBC provider, but after I installed client access I no longer have the option to select any Provider Name(combo box displays blank and I cannot type text). Before I...

Hi, I have a query that I want to run that has two tables. The 1st table has an Identifier that is alwaya 13 digits long. The 2nd table contains the same ID's except sometimes they are incomplete. Even though the 2nd table is not 13 digits, they are unique and match up to a unique...

Hi, I have a form that is linked to a table with field Status. The purpose of the form is to have a short list of "Active" orders that have already been entered. Once the status is changed by the user it becomes inactive and will be viewable through another form. When I...

Hi, I am working on a form with multiple input fields, every time I want to set a variable = txtMyTextBox I have to first Me!txtMyTextBox.setfocus Or else i get the message: "you can't reference a property or method for a control unless the control has focus" It works but...

Hi, When ever i run a query on SQL the memory usage quickly jumps to 100%. Yesterday I was running the same exact same queries with no problems. There are only 2 things I can think of that i changed. I rebuild an index on one of my tables and I downloaded a patch from microsofts...

Hi, I have a table in my database that uses more than one field as a Unique ID. The table is growing very large and i would like to index it. However SQL requires a single field as the unique identifier to create an index. Is thier anyway to index the table so without adding a brand new...

Hi, When I try to view my Meta Data underneath Data Transformation Services I get the following message.... Some software (ActiveX controls) on this page might be unsafe. It is recommended that you not run it. Do you want to allow it to run? When i click on No i get a runtime error line...

Hi, I am currently trying to verify if a current Primary Key (UPC) is already in a database then return the status(1,2 or 3). I am using the Dlookup and the code looks like this. UPCf = Me!txtUPC.Text CheckUPC = DLookup("UPC", "dbo_NewItemList", UPC = UPCf) I thought...