Search results for query: *

I have a report that is called from a form to specify parameters for the underlying query. On the report, I want to show the from and to dates which is pretty easy - just reference the value from the form. I reference the site id parameter that is chosen from a combo box...

We have an application that was originally installed in 1998 on version 8.2. The application was upgraded in 2005 but against the old 8.2 database version. The application is now at end of life and will cease to be supported in 2013. Since the app runs, the business unit really has no stomach...

This has probably been answered several times in here before, but I couldn't put my hands on it readily: Generic Issue: I have a resource that is available to work on projects - lets say 50% of the time I have a task that will take 80 hours to do. I want to assign this resource to the project...

We have a system that stores the description of an item with HTML tags for bold, font, etc - normal HTML stuff. Is there a function in access that will allow me to read the field - automatically removing the HTML so I can display it in plain text to a user? Thanks

I have a REQUISITION application that has been in production for several years. However, now the users are want the capability to attach quotes (pdfs), estimates (XLS), contracts (docs), etc to a requisition. I tried to pursuade them to utilize a file server reference solution to no avail...

I have an Access 2003 app that is attached to SQL Server via odbc linked tables. The application is a requisition work flow system. Everything is built and has been in production for several years. However, the users wish a little more convenience. They want to be able to upload a .pdf...

I have created a query that summarizes data across several dimensions. I then created a pivot table based on this query. When I look at the raw data in the query - numbers such as 10.5, 8.83, etc. show up. However, when they are sucked into the pivot table, it seems that the pivot table has...

I am importing data into a staging table and perform several validation checks against the data in the stored procedure prior to updating the production tables. If any logical errors are encountered, the update statements do not process. However, if the update statements do start to process, I...

I want to begin making better use of my server to feed reports. I would like to feed a report utilizing a stored procedure. I know how to do this with a very simple example - i.e. Select Cust_nbr, cust_name from customers .... However, I would like the user to be able to select parameters on...

I want to retrieve the max value of a column or return 0 if it is NULL. I know how to write it in SQL 92 - SELECT CASE WHEN max(loc_csreq_id) IS NULL THEN 0 ELSE max(loc_csreq_id) END FROM csreq Anyone have a quick translation to Access for me? Thanks!!

I have a database that is approximately 5GB; however, the the log space has been increased to about 8GB. I am in the process of upgrading the database from 12 to 15. I want to re-create the database with a reasonable size log segment, but when I recover, I can't seem to figure out how to...

Does anyone have any idea how to create a dynamic calendar in Access that can be utilized to display who is scheduled to be out of the office. I'd like the user to be able to scroll through the calendar and be able to view an entire month and have the people's names appear on the appropriate...

I have a report that we run and it auto-highlights rows based upon programmed conditions. However, I can't seem to figure how how to maintain the background colors on the rows when I export the report to distribute to the user community. Any ideas? Thanks,

I have several tables linked to SYBASE 12.0 via ODBC. I also have several tables linked to SQLServe 2000. The following is the code I use to connect to them - I'm only pasting in one example since the code is identical for both except for the connect string. strConnect =...

I am migrating an application from a windows 2000 file server that has all of our printers and customized form sizes installed on it. I am moving our accounting application from that server to its own Windows 2003 server on which I wish to install the specialized check printer. The check...

I am migrating an application from a windows 2000 file server that has all of our printers and customized form sizes installed on it. I am moving our accounting application from that server to its own Windows 2003 server on which I wish to install the specialized check printer. The check...

I have a list box from which I allow a user to select multiple rows. One action that the user is allowed to do once the selections are made is to delete the underlying data. All of this works fine except that after I requery the list box, the lit box rows are still highlighted as selected...

Although I've written some complex reports and graphs, I seem to be missing something that should be simple. I want the report to break each time a group changes. i.e. The report is as follows: Transportation Type Salesperson Ship Dt Freight MBF From To...

I want to retrieve data from two tables using a join; however, the sql statement is over 255 characters long. I can break it into two different statements, but I wanted to know if there is a method to execute the statement without breaking it into two different queries. Thanks,

Is there a method of testing a flag within the database and setting the value all within one instruction. I want to create a semaphore so two users don't try to the same logical thing in an applicaiton at the same time. While the likelihood of this actually happening are VERY remote, we all...