Search results

Thanks very much for your replies! Had a busy week so am late responding. - I selected "show add-in user interface errors" but got no error. - Attached the callback code. I'll now remove all buttons but the first two, and remove all callback code except that for the first two buttons. If...

I removed lots of tabs from the xml. When I add the second button (that calls GetEnabled) then the error occurs. <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad"> <commands> <command idMso="Help" enabled="false"/> <command...

Hi, I'm using Access 2010. In accdb all works. In accde I get: can't run the macro or callback function 'GetEnabled'. Make sure the macro or function exists and takes the correct parameters. I click OK six times to get rid of the error message, and after that icons on the custom ribbon can...

Re: mbe works, mde doesn't I imported all objects into a new database, and there is no more crashing. I guess Dave was right at the start when he thought that there was a problem with the references. Now I'll add thorough error handling. Thanks all!

Thanks. I'll put in error handling code, I much appreciate your advise. This project has 200+ forms, 150+ reports so it'll take take time to put it in. I need the program to work tomorrow. The "Payslip Dialog" form has an error indeed. It has about hidden 15 text boxes with calculations, and...

Re: mbe works, mde doesn't Thanks spikepl. I converted the macro, and get: Private Sub Report_Open(Cancel As Integer) On Error GoTo Payslip_Dialog_Open_dialog_Err DoCmd.Maximize MsgBox "1" DoCmd.OpenForm "Payslip Dialog", acNormal, "", "", acEdit, acDialog...

Re: mbe works, mde doesn't Option Compare Database Option Explicit Dim Result As Boolean Dim sFile, sQuery As String Private Sub Report_Open(Cancel As Integer) 'On Error GoTo Err_2075 MsgBox "1" DoCmd.RunMacro "Payslip Dialog.Open dialog" MsgBox "2" sFile =...

Re: mbe works, mde doesn't vbaInet, When I run MDB there is no error message! Error handling: On Error GoTo Err_2075 ... code Err_2074: MsgBox "2074 " & Err.Description

Re: mbe works, mde doesn't Thanks for looking into this again, vbaInet. I spent another 6 hours working on the references without result. I was planning to use a backup copy that worked OK, and import all new objects into it. When running as an mdb there is no error. When running as mde it...

True, I had no error handling - had been in a hurry... It crashes on DoCmd.RunMacro "Payslip Dialog.Open dialog" Since it does run as mdb, I agree with gemma-the-husky it will probably be a reference issue. Thanks all!

My VBA code works when run in mdb format, but after converting it to mde it aborts at multiple places. I use Access 2003. References are all ok. Code compiles without an error. What should I check? Alex.

You're right Pat about duplicating the report writer, and I already have options in all reports to export to Excel... This is going to save me a lot of time! Thanks!

Thanks Pat, Thanks for your replay. A report with all fields wouldn't even fit on a landscape A3 sheet, and a selection of reports wouldn't make my customer happy. I'll be able to code it as per your suggestion 3, but hoped there would be a simple way. I'll assemble strings for both the...

Hello, In a dialog box users select what columns will appear in a report. How to make a report that includes only the selected fields, without having gaps between the columns?

I found this solution: Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("c:\Webinventory\" & sGroup & ".htm", ForReading) strText = objFile.ReadAll objFile.Close strNewText =...

I use DoCmd.OutputTo acOutputTable, sGroup, acFormatHTML, "c:\Webinventory\" & sGroup & ".htm" The resulting table starts with a centered title with whatever the sGroup variable contains. Is there a way to suppress this title?