Search results for query: *

I have a series of orders for some products. There are multiple rows per order sorted by date. The status changes in each row. I am trying to figure out whether an order is closed (sold) or open (on order) in the last row. Then sum the quantity sold or the quantity on order by product. Item...

I am doing some maintenance for a client who has an Access database and some Crystal reports. They have an annual sales program and each year the views in Access and the Crystal reports are updated for the new year. The when viewing the 2007 Sales report in Crystal, it has an alias on the from...

Hi - I have the following code that links to a specific location on my server. But the linked to location does not always exist and because of the way the link name is built I will not know that until the user clicks the link they want to go. So I have: <script language="javascript"> // use...

I have javascript code that I use with Coldfusion to load a second drop down that is related to a selection made in a first drop down. The code works but (isn't there always a but?), it depends on the quantity of items returned by the query. The results of the query are about 40K entries...

I am working on a browser based application. It runs on a "secured" intranet. The work station OS is Win XP Pro and the browser is IE 6. I am looking for an ActiveX control that I can use to get the user id of the person logged on to the client machine for logging purposes and that I can...

I am working on a browser based application. It runs on a "secured" intranet. The work station OS is Win XP Pro and the browser is IE 6. I am looking for a script I can useto get the user id of the person logged on to the client machine for logging purposes. Any ideas? All help will be...

Hi - I am just starting to use ASP.NET 2.0 and am running thru the examples. I am trying "creating a web site with membership and login". I have actually gotten the appropriate tables added to the Northwind sample SQL database and all the configuration stuff in web.config to work. The...

I am trying to connect to a dBase file, select some data from that file, drop the link and move on with Access processing. If I try to Link to the file using the regular Access File/Get External Data/Link Tables and select the DBF file I get a message that says "The Microsoft Jet Engine could...

I have an Access VBA process that reads a table and creates a bunch of e-mails. Fairly straight forward. ***************************************************** Dim objOutlook As New Outlook.Application Dim objOutlookMsg As Outlook.MailItem On Error GoTo ErrorMsgs ' Create the Outlook...

I have CF module that may or may not be passed a parameter in the URL. I want to check and see it the parameter is there otherwise use a default. <cfif isDefined("URL.SelectDate") > <cfset lnSelectCYCYMM = #URL.SelectDate#> </cfif> This code produces "This page cannot be displayed" message...

I just upgraded to MySQL 5.0.16, PHP 5.1.1 and phpMyAdmin 2.6.4-pl4. I had older versions running fine. They all run on a Windows 2003 standard server with IIS 6. All works fine sort of. For the older version of phpMyAdmin I had a bunch of SQL Selects in text files that I would use the file...

I want to create a pie chart and based on an Assessment an item in the database will be marked as green, red or yellow. I always want the green items to appear as a green color in the pie chart, the red as red, etc. So I wrote a query and pass it a 'G', 'R' or 'Y' and it returns the correct...

I have an application with a number of forms. The system admin has a form to select the data and software location. That is saved to a table and is accessed when the application starts. At start up time a list of public variables is built concatenting the data location and the table names...

I have an Access database with an Autoexec macro that runs code that reads Outlook/Exchange information and populates a table. It runs nightly and the table is read by ASP code for display on an intrannet site. All works fine. When Access runs nightly (or you run the database by double...

I have a number of Crystal reports for Peachtree. We have Crystal Enterprise 9.0 (standard edition) installed and patched to SP2. Under P-tree 2003 I was able to use the basic Report Application Server (RAS) and publish the reports on the Intranet site. They worked fine in an on-demand basis...

We have been running P-Tree 2003 and I wrote some Crystal Reports which worked both in Crystal 8, 8.5 and 9. I installed Crystal Enterprise 9.0 on the web server and we run the reports across our Intranet using Crystal Enterprise RAS. The reports all worked fine. We have just upgraded to...

I have client who is running Outlook 2000 and Exchange. Their server is running IIS and I am trying to open Outlook in a specific folder from their Intranet. On my test server with Outlook 2003 and no Exchange the following works fine: <a href="outlook:Public Folders/All Public...

I have an Apache/Tomcat web server listening for requests on Port 80. There will also be some ASP web pages that need to be passed through to IIS <localhost> for processing. Is there an easy way to accomplish that? Thanks for your help.

Has anyone used the Paperport 9 controls to scan a page (or 2 or ...), save the results in a table (memo field or other suggestion) and then displayed the saved image later? Any hints on using the Active X Controls or any other source would be greatly appreciated. Thanks for your help.

I am looking for a way to read an Outlook calendar on a local machine and write a database (I only need date, time, text). I would like to select all items within a specified date range that will be provided from another source? I have seen a number of articles about writing to an Outlook...