Search results for query: *

Hi, If this isn't in the correct forum, I apolgize, but I am not sure which forum would be appropriate as I think I am dealing with an early version of exchange server (from windows 98). I have a client who has a 4 PC local network (users access the internet via individual dial up) that was...

Hi, This is probably a simple question, but I can't seem to get it to work. How can I resize a named range to be one row less that it was previously defined as? I have a name "Trav" in a sheet that and this name is defined as ='Trav Data'!$B$4:$Q$6, a macro inserts rows from 5 to xxx, which...

Hi, This may be something simple, but I am having problems getting it to work in Access. I have a master product list in one table (with a autonumber primary key). I want to set up a data entry page that selects a subset of the data (based on Project and Account fields in the table), and...

Hi, I am fairly new to VBA, I know what I want to do, I am just having some problems getting there. I am creating a routine to automate inserting some data in to an Excel Spreadsheet. I have a "template" set up in Excel that contains format, layout, macros, etc. I want to find the...

Hi, I am working on modifying a crystal report (that is used to print checks), and I would like to be able to modify the crystal report to print VOID across the check if it is not run out of our production database. I know how to do this in the crystal report, but I don't know how to get the...

I am working on a project where I have to take large amounts of data, analyze it to find sections that are not zero, and prepare entries to correct those. I have 46K+ lines of data that rolls up into approximately 4000 lines in a pivot table. The problem is that to create the entries I need...

I have created a database that opens my excel file as a linked table, but now I need to insert values into two "cells" in the table (row 5, col 3 and row 6, col 3). These values will come from another table that holds the month date and year of the current data. I then need to insert...

I am trying to rename a file and save it based on some data in one of the queries contained in Access. I have the Database built, and most of the functions are in Access itself, but I want to set it up to open a file from a specific folder (which I have done with no problems), then copy the...

I have created a crystal report from a query (in PeopleSoft - Oracle) and the query passes 2 paramaters in one of the columns (the Fiscal Year entered in the Prompt, and the Accounting Period entered in the Prompt). I am trying to figure out how to get the Crystal report to show these...

I am new at Crystal and am still learning. I have several queries (in our PeopleSoft system, on an Oracle Database) that require paramaters before they are run. I have built the reports in Crystal and can run them and get the results I want, but when I try to display the paramaters on the...

I am new at Crystal and am still learning. I have several queries (in our PeopleSoft system, on an Oracle Database) that require paramaters before they are run. I have built the reports in Crystal and can run them and get the results I want, but when I try to display the paramaters on the...