Search results

Hello all, I am trying to find a way to put a header on my report that extends all the way across the page, while the body of the report maintains 1" margins from the right and left sides. Is this possible? My company really wants their letterhead graphic inserted at the top of the report...

Hello all, I have discovered a very disturbing problem in my project. Some of the memo fields are being truncated when my report is being generated, even though I have CanGrow set to Yes for this particular textbox. The data is retained in the table, and displays perfectly on the form, but I...

I wrote this code to cycle through my table and delete any duplicates. I'm having two problems with it, though. For testing purposes, I've redirected some output to the immediate window. When run it appears to be working, however no dupes are being found. I find this odd, because a find...

I have been searching the archives on this forum for a couple of days now, but I am unable to find a solution to my problem. I have a table that has been imported from FoxPro which was part of a very poorly designed database. There are now 98000 records in this table, many of which are...

I am working on a query regarding billing data. There are 2 date fields in this data: DateEntered, and DateBilled. I have a query which selects both there ranges with parameters. Under the criteria for DateEntered I have: Between [Starting Date?] And [Stopping Date?] Under DateBilled I...

Hello all. I have a database with a number of queries and reports that require date range criteria. I put two unbound text boxes on my switchboard: one for a starting date, and one for a stopping date. I set the default dates to be #1/1/95# and Date() using the properties for those...

Hi everyone, I have a table with an autonumber field as the unique identifier. This field had at one time been set as the primary key for this table. While doing some maintenance today, I noticed that this table's key had become unset. When I attempted to reset it, it said it was unable to...

I am building a report and and subreport which are based off two similar queries. (The second query calculates totals for the fields in the first query.) The parameters for these queries are the same. How can I make the query for the subreport utilize the parameters that have been entered for...

Is it possible to combine multiple fields to be calculated on a single crosstab? For example, I want to show the totals of attorney time, adjusted time, billed time , and amount charged: to be broken down by attorney, and summed yearly. Can any one help me with this? Thanks, Ed

Hello all. I have a report that I am developing which gives a tabulation of the time and money an attorney has billed out over a period of time. It also shows time held, time that has been billed, but is still on hold, and time that has neither been billed or held. The problem I am having...

It was brought to my attention that records are randomly disappearing from various tables on the shared back end of my Access 2002 database. For example, on 9/4 one user entered about 10 new files into the files table. Today, I went to look up some info regarding one of those files, only to be...

Is there a property that can be set to "freeze" a field so that it may not be tabbed over without something being entered? Thanks Ed

I have a query which, for the purpose of generating our company's bills, creates an enourmous recordset. Most of the data comes from the Charges table, but there are 3 other tables involved here. The problem is, I want to have every charge show up in my query, even if some information is...

What can I say, my users are idjits and so the boss is requiring the following of my db: There is a form used to enter charges. The first two fields are FILENO and CLIENTNO. What is the best way to a) ensure that each number exists in their respective tables before accepting the entered...

800+ missing records!!!! HELP, PLEASE!!! I just had some of my users report a back-end corruption. It seemed like no big deal, until she went to see if the last edit she made was there. Well, turns out we're missing the last 800 or so records that were entered. No big deal, I thought, we...

I've got a report where I need to display a combination of two fields in one text box. The first field is a text field, and the second is a memo. I tried setting the control to =[ACTREQD] & " " & [COMMENT] but this only prints "#error" The COMMENT is really an extension for ACTREQD and...

I have a query that my users want to viea in datasheet mode. It it possible to select one or more columns and format them as bold print? So far, I have only been able to make the entire sheet appear as bold. Any ideas would be much appreciated. Thanks, Ed

Is there a way to control the default placement of the ctrl-f find window? Thanks

I have just created my secured, split databse to be run from our small network. Everything works great, except when starting the application from any computer besides the one I developed it on, the user is not even prompted to log in. All of the files are on the server, and I included the...

I hope someone else has experienced this problem. I am ready to deploy my application. When I go to run the packaging wizard, it shows error 429: ActiveX component can't create object. I have looked at msdn, reinstalled MOD, downloaded every SP and patch I could find, but nothing has helped...