Search results

I have currency fields in my reports. I figured out how to round them to the nearest dollar in the query. How do I display them like this but without the .00 on the end? e.g. $123,456.89 becomes $123,457 Thanks.

Now I get "no current record" on thisRecID = rst![txtIDNbr] in the loop.

I followed your suggestions, but now when I click the button to run the subroutine the database locks up.

Fizzio, I tried changing the variables to Variant, but got the error: Update or Cancel Update without AddNew or Edit on the line: !txtSpecCode = SpecCode I realize that but it is very complicated to explain why I am duplicating the data. Two records will have mostly the same data, but some...

I am getting "invalid use of null" error on the following code: Public Sub DupTapeData() Dim prevRecID As String Dim thisRecID As String Dim SpecCode As String Dim CatOfServ As String Dim BillType As String Dim RateCode As String Dim dbs As Database Dim rst As DAO.Recordset Set dbs =...

OK I did a query and a DLookup and it seems to work. Thanks Jon K!

This sounds like what I want to do on my reports. Given the report starting date, I want to look up the contract period starting and ending dates that this date falls between and print them on the report. The contract period is not always a year. e.g. Contract period dates 1998-1999...

This sounds like what I want to do. I have 6 reports, which should be printed with the page numbers continuing from one report to another. Some of the reports have a variable number of pages. Any assistance with this question is appreciated.

OK, I got the answer when I was searching the forum for the answer to a different question! I created another query with columns for the Avg and StDev of the LOS. Then created two textboxes in the Report Footer. I put a DLookup to one of the columns of the query in the control source of each...

The query the report is based on is as follows: Columns are: Group by RateCodeType Count of CaseNbr Avg, StdDev, Min, and Max of LOS RateCodeType, CaseNbr, and LOS are all fields in tblRetroVolumes. I have text boxes calculating the Total Cases, Minimum LOS, and Maximum LOS for all the...

I finally figured it out using the Val() function, with some help from a co-worker. It works well now. Thanks for your help, Mile-O-Phile and neileg. :D

Thanks neileg, but where would I put this?

Thanks Mile-O-Phile, I followed your suggestions and it is working this far: I have created 5 queries each of which extracts a different 5 characters from the error code string, and a Union query which puts them all together. Then I put the query into another query, and displaying the error code...

One of my tables, tblRemitMaster, has a field called txtError. I would like to do a distribution of the error codes in this field. However each record can have up to 5 error codes in the txtError field. There are hundreds of possible error codes. The error codes are concatenated in a 25-digit...

I decided to give up and make it a single form. It works that way, and I added a subform with the detail from tblAdjMaster. Thanks for your responses.

llkhoutx, Can you explain this code? Where should it go? When I replaced my Load event code with this code it gave me a type mismatch message on the OpenRecordset line. Also, is the Dim str as String needed? It is not used in the code.

Hi FoFa, Thanks for your response. How do I include the date in the query? When I added the date to the query it still listed only the first and last dates for the first value of the tape number, on every tape number, and repeats the records over and over.

I am trying to use a field on a form to select records in a table, then find the first and last dates in a field in the table and display them on the form. It is a continuous form. (The table holding the dates is a different table than the one underlying the query the form is based on.) Right...

I tried that but it highlighted that line and said "Compile error: User-defined type not defined". Then I figured maybe it was missing references, so I went into Tools-->References and checked "Microsoft DAO 3.6 Object Library". Then after selecting from the combobox, the message was "Object...

hi casey, Your first suggestion had the same result. The second (specify the form name) brings up the same message, but now "FindFirst" is highlighted in the following code: R.FindFirst "[txtIDNbr] = " & Forms![frmSURProcessing].[cboTapeNbr] This is the same with or without the brackets and...