Search results for query: *

I have been working on a Training database here at work, and have almost finished it, but am lacking a way to insert and update a bunch of records at once. I am needing to figure out how to insert up to 450 records from an ASP page, but the kicker is that I need for the user to choose an...

I need to know how to backup the SQL Server 2000 databases and then restore them to SQL Server 2005. Our current setup is Windows 2000 with SQL Server 2000, although we need to format and fresh install Windows 2003 and SQL Server 2005. Do I just need to use the Backup Database dialog in EM...

I am trying to help a coworker at a different facility troubleshoot their website. The problem is that in Firefox, the links show up with the link target in the link text, fouling up the design of the page. I am really not sure what is causing this, I can't see anything in the code that would...

I am updating our Intranet from table-based design to CSS and am having problems getting my first/previous/next/last navigation to look right. Basically it shows |< First and <Previous links if the user is not on the first page and shows the Next > and Last >| links if the user is not on the...

I am using AJAX to return a name from the database so that the user inputting data knows that they input the correct register # (a unique number for each person in the db). Here is the interface code, <label for="RegNo" class="required">First Name:</label> <input type="text" id="RegNo"...

I am trying to set a fieldset width to 95%, but this seems to only work in Firefox. Anyone know of a workaround? http://www.swvtc.dmhmrsas.virginia.gov/style.htm\ Thanks, Drew

I have a report that when opened, it opens a form named Months that has a dropdown of all of the months of the year, when the user selects a month and clicks Get Report, the report is loaded and the record source is set to a stored procedure (yes, it is an ADP) with the month as a parameter...

I have an ADP that I am using for reporting. I have been trying to get the ADP to open maximized, so that the user doesn't have to maximize the app themselves. There has been some weird things going on, The ADP is stored on a server, and is linked from an Intranet page. If I open the ADP...

I am very new to Javascript/AJAX, and have been fiddling around with it to make some new interfaces. I have the following js code that I swiped from w3schools.com, var xmlHttp function showName(RegNo) { if (RegNo.length==0) { document.getElementById("txtHint").innerHTML="" return }...

I am very new to AJAX, and have been fiddling around with it to make some new interfaces. I have the following js code that I swiped from w3schools.com, var xmlHttp function showName(RegNo) { if (RegNo.length==0) { document.getElementById("txtHint").innerHTML="" return }...

I need to build an ADP that can be used to print pictures in the form of a contact sheet. I have a SQL Server database with links to my pictures. The pictures are on a server on our local network. I have a view that shows all the data that I need. I assume that I need some kind of For...

I am building an ADP for reporting and have run into some issues passing data from a Form to the report. I have a combobox on my form named ddlSortBy and it contains 5 choices for the ORDER BY clause of the query, the combobox only has 1 column and that is a string. I am trying to detect which...

I have a main report which has 24 subreports on it. If there is data available for all the reports, then everything is fine, but if one of the subreports doesn't have data, then the subreport just doesn't show at all. I have edited the reports to test for the HasData event. The reports work...

I have a report that runs off a Stored Procedure. The SP looks like this, CREATE PROCEDURE spCreditCardLogAllUsers @ImportDate Varchar(20) AS SELECT UID, C.CardholderID, CardholderName, Department, CardNumber, CardType, PONum, PODate, Vendor, Description, Amount, CCCObjectCode, ImportDate...

I have a problem with my DTS package. The way it works is, A SQL Task reads a table, grabs the ExcelLink column and CardholderID. Set the rowset to a GV. It loops through and uses the ExcelLink global variable to change the path of the Excel file(source). It transforms the data to SQL...

I have a Credit Card Log that I am building in excel, and need to find out how to make Excel enter data into a column automatically. The file is really simple, just a listing of all purchase orders in a billing cycle. I need the file to add certain data to A1 if a new row is started. Is...

It's me again... I have come across another problem. This question is for using Access ADP for reporting. I setup my application to run off of the username of the current user. Problem is that some of the users of the database enter data for other users. For an example, one of the ladies...

I have a report that I am building and have gotten to another obstacle... I need to calculate a column total, but only if the column is YES. Anyone have any advice? Thanks, Drew Laing

How can I build a report that shows 10 records on the first page, then the rest of the records on the second page? I have a form that I need to convert over to a report, and it has 10 records, then has some calculations, if there are more than 10 records in the database, then they are continued...

I have the following query, SELECT MAX(DATALENGTH([Members Present])) AS MembersPresentLenMax FROM tblIPPCore2 In the tblIPPCore2 table, there are 20 or 30 ntext fields, I need to find the maximum length so that I can restructure the table. I would like to find out if it is possible to...