Search results

James, Thanks for your reply. I need this to work for conditional formatting. ex. Me.MyControl.FormatConditions(0).FontUnderline = False 1. If I put the above on the OnFormat it will run for each record. If there are 1000's of records this is not efficient. 2. I get a RunTime error...

Below is the algorithm I require. I am not very familiar with the VBA syntax required to make this algorithm work. The purpose of the algorithm is to add underline to conditional formatting when the report is in Report View to mimic a hyperlink and to remove the underline when the report is in...

It's too powerful to ignore though. Print Preview is not great in certain areas. You can't scroll through the report and you can't select any text into the clipboard. You also can't trigger any events from it like Click etc... making it non interactive.

Hi Pat, The only way to get the Report View working was to remove the duplicates in the SQL as you suggested. Thanks,

DoCmd.OutputTo acOutputReport, strReport, acFormatXLS, strFolderPath & strReportName & ".xls", True Appears to extract whatever I see in Print Preview.

Pat because I am using a user defined predicate for the Where parameter when I open the report. If the predicate is loose it will create duplicates (which is actually correct but I don't want to show duplicates) if the Predicate is fine it will not produce duplicates. This methodology allows...

Dear Access Expert, I have the following code in the On Format Event of the report. It is used to hide duplicates which result from very loose Where parameters when I run Docmd.OpenReport. With tighter Where parameters there are no Duplicates. I am aware that the On Format event does not...

Thanks Spikepl, Your link confirms that Round() uses Bankers Rounding and Ken Getz' custom function doesn't. I also read that in Sage Simply Accounting they calculate the tax on each line item and then add it up. I just calculate the Tax on the subtotal. Others have had problems with this at...

My client has told me that the tax calculations on the MS Access invoice don't always match the accounting software he re-enters the data into. Sometimes the values are off by a cent or two. I looked at how I designed the invoices and I am using the Round(x,2) function. I just read about the...

Dear Access Expert. I am sporadically getting the 3734 error and Exclusive message when I go to design mode or try to save an object. Sometimes everything works as it should and sometimes I get these error messages. I am the only user of the mdb and trying to do development on my local...

Thank you for your response John. Associated labels don't grow/shrink in Access 2007 or less but I did accomplish what I wanted with your suggestion. I made the label into a textbox and kept the label and the deposit field the regular height. When the value was null I used Can Shrink on both...

Dear Access Expert, 1) I am creating an invoice report that has the following summary fields. Subtotal Discount Environmental Surcharge Tax Deposit Final Total If there is no Discount the field should be hidden from the invoice which is easy to do but then there is an empty gap that looks...

Hi Bob, Thanks for your response. I want to change a label in the report Header based on the data in a field that is also in the header. If Me![InvoiceDate] > #1/1/2011# then Me!lblHST = "1234" Else Me!lblHST = "5698" End If Thank you for your help.

Dear Access Expert. I am little confused. When I create a report in Access 2003 there is no On Load Event for the Report? The On Load event does exist in Access 2007. How do I manipulate the report based on the loaded data if there is no ON Load event? If I put the code in the On Open event...

I got the code to read my port using the below code along with David Hitchner's library in my Access Application. Option Compare Database Option Explicit Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Public Function ReadScale() On Error GoTo PROC_ERR Dim...

Pat yes I read the links. They were very informative. Thank you for all the info.

Thank you for your response TexanInParis.

Thank you for the response and information Pat. I am disappointed. I thought transactions were record level locking or perhaps page locking but not table locking. I am using a .mdb / Jet backend and I assume ACE works the same way. Are transactions table locking in MS SQL Server as well...

I am a little shocked and just want to get a confirmation. Pat so if I open a table within a transaction the entire table, not just the record being edited (or record block surrounding the record) is locked? If the entire table is locked then this severely limits the use of transactions in a...

Dear Access Expert. Using a .mdb file as the backend and DAO: When the execution is inside a .BeginTrans ... .CommitTrans / .Rollback block does any table opened in that block become locked for editing in a multi-user environment? I am getting entire table locking issues and I believe it's...