Search results for query: *

We're looking for a way to select a record from a list of records on a search form which will then open a record detail form. The issue is having the record detail form display the current values for the fields, but also be a drop-down with other relevant options for each field. For example...

I have a SUM(CASE expression that is not working when I run it in our new SQL 2014 (Windows Server 2012) environment. I run the same EXACT expression in our old SQL 2008r2 servers and it works. Any idea what might be causing the issue? SELECT AA_Category, SUM(CASE WHEN...

I have a vendor software that stores files in folders in the gui. In the actual db (SQL 2005), the files and folders are stored as Node_Name (varchar(128)), Node_ID (int) and Node_Path (varchar(900)). Here's an example of the data: Node_NameNode_IDNode_Path Mortgage 20044.1.2.4...

Is it possible to export to a specific worksheet in Excel and overwrite the existing data using the transferspreadsheet method in VBA? I need to export a query to a worksheet that holds the raw data in an Excel workbook. There are several other worksheets in the workbook that connected to the...

We are in the middle of a migration from MS Access 2003 to SQL Server 2000/WebFOCUS 7.6.1. Everyone I speak to outside of my employer tells me that I should be writing SQL Stored Procedures to get my report results, and then connecting WebFOCUS Dev Studio to that result to display/format it...

The pre-reqs: I have a db that stores project requests by the department that requested them. Each request has an unique ID (project_num) and a priority number (dept_priority). I have never had more than 10 open requests for a given department at a time. I have a priorty form that includes a...

Does anyone know of a way to track user log in and log out times in MS Access 2003? I can write a vba script to track when they log into the system and the main form opens, but I can't come up with a way to track when they log out. Any help would be greatly appreciated.

Good afternoon - Myself and another developer in my department have been tasked with converting an environment containing over 200 MS Access 2003 databases to a SQL Server backend - MS Access frontend environment. I would like to know if anyone knows of a good training course that we could...

We have a Citrix environment that our MS Access world resides on. There are approximately 220 Access 2002-03 databases on the server. The server itself has corruption issues, so we are in the middle of a migration to a much bigger and better one. In testing the new server/environment, we've...

Good morning/afternoon and happy holidays. I have a process in which a set of data is loaded to a database each month. The new file is appended to an accumulative file which is the main table in the database. Each record contains an Application Number, Loan Number and File Date field (among...

We have converted about 200 Access 97 dbs to Access 2003. In one of them, a report that had the width set to fit on one letter landscape page in 97 now has trippled in size in 2003. The 97 version of the file still has the correct report width. Does anyone know how to get my 2003 file to show...

I writing a vba script to import an excel spreadsheet to an access database so the data can be reconciled to another system. The spreadsheet is created and maintained by another group, so I don't have the luxory of reformatting it. I'm using the transferspreadsheet method, but when I do I've...

We are converting all of our Access 97 databases to Access 2003. While testing them, I found one where the report size is way off in the 2003 version. In design view, the report looks the same, so I'm not sure why it gets so large when it's opened. It's currently set to be a landscape report...

I have a Access 97 database that was built by someone else a long time ago. The main form has several command buttons that allow users to move through the database. The person that developed the system used macros to open the new forms called from the on click event of the command buttons...

I'm using Crystal XI. Backround Info - I have a main report with several subreports inserted into it. Each of the subreports is grouped by state (as the outermost group), and state is how my main report links to each of the subreports. Because I need each subreport to display different page...

I have a report that is distributed all over the place. It was in excel which allowed everyone to sort the data how they wanted to see it. Now it's in MS Access 97, so the report is built into the database and accessed by a command button on a form. I would like to allow them to sort it how...

I'm using crystal XI and trying to insert some reports as subreports to a main report that links to them by state. I have gotten as far as creating fake page headers in the subreports using a "" grouping, and that works just fine. My issue is in creating the fake page footers. Does anyone...

I have 15 or so reports I built that all have different data sorted by State. I would like to build a process that pulls all 15 of them together by state. In other words, I would like to select the state, and then have a process pull together all 15 reports for that state in one document so...

I have a report that groups geographic areas by state and then by the significance of the area within the state. Areas in a given state can be classified as "full review" or "limited review". I have to show the full review areas before showing the limited review areas on the report. My...

I'm trying to change the font color of some fields on a report I built in CR XI. I'm using the format editor to the right of the font. Here's my formula: IF {qry_OandU_report.TotLoans} > {?TotalLoans} and {qry_OandU_report.TLOA} > {?PGTotalLoans} and tonumber({@DM_AO}) > {?DiffOvgMean} then...