Search results

Thanks Thanks for all the suggestions. I tried the idea of adding a new report and then deleting it. No luck. In the end, I had made a back-up copy the day before, so I just reverted back to that and imported the new forms and reports from the corrupted version. Thanks for all your suggestions!

Yes I have tried, but I get an object error during the decompile AND compile!

Hello all. I have deleted a Report but the underlying reference in the VBE editor in the CLASS OBJECTS list remains for the report and is giving me errors during run and compile. Any idea how to delete the Class Object once the object has been deleted? Any other suggestions? Version...

Thanks...But, I am not looking to create a link. I am looking to populate the form with the data and save it to the underlying table. I am looking for a import rather than a link.

The underlying spreadsheet... changes. It will never be the same.

Hello. I currently have a data-entry form that users fill-out with data (duh!). The data comes an excel spreadsheet that is created during the work-flow process. I would like to add an "Import" button the field that, when clicked, would prompt the user to select a spreadsheet (different...

My experience with Mail Merge is that you should not adjust formating in Access, but rather in the Word Template. Highlight the field and press ALT+F9 to display field codes, and then add switches to the merge fields.

Thanks. However, I was really hoping to avoid using the print dialog. I have found post that indicate that their is a correction to the code that needs to be made under Windows XP, however, I have not been able to find the correction. Any one have a idea? Thanks again.

Hello all. I apologize in advance if this has been addressed elsewhere, but I have been unable to find a solution. I have been using the DefaultPRT.ZIP modules and code successfully in an Access database (2000) under a WINNT environment for a couple of years to allow the user to change...

Print to PDF...? Hello. Exporting reports to RTF files will always drop much/all of the formating. Have you thought about printing the reports to PDF files?

Follow-Up First of all, thanks all for the responses. Pat, can you give me some help with identifying the control type. That is what I was looking for, however, I am not sure about the logic to do so. Thanks again!

Thanks for the reply. My intent is to disable the controls so that the user can still view the information...But not make any changes. Any ideas?? Thanks.

Hello all. Depending on the logged used I would like to disable every textbox and combobox on a form using VBA. I know that I can use the following code to move through the Control Collection: Dim ctr As Control For Each ctr In Me.Controls DO SOMETHING HERE Next ctr ' Me.Refresh...

...Pat... If you do have time to write some code to rename the controls I would love a copy of it! Thanks.

Thanks... Thanks for the suggestions. Compiling, repairing and compacting did not solve the problem... I was able to "reassociate" the code by coping all of the code out...saving the form...and then pasting it back in. For some reason that worked! And Chris, thanks for the suggestion...

Hello. I have a form with many control and a lot of code associated with the Events of the controls. After making changes to the form the other day I noticed that most/all of the events no longer "fired" and command buttons no longer worked. When I look at the Events list for a control...

Right click on the Menu Bar, select Customize. The Customize Dialoge will appear. At that point you should be able to "drag" the shortcut off of the the Menu Bar. Enjoy!

Thanks Jon...A bit of follow-up. Jon, Thanks for the reply. After a long delay I am finally getting back to this. I took your advice and looked into PDF Factory. I think it will work for me. I do have a follow-up question. I want to be able to print from Access and define the PDF file...

WindowProc I have isolated the problem to the WindowProc function that is called by both. The proble, however, is that I can not follow the logic with regards to where the function is called. As I step through the logic, it jumps from a line of code without being called (at least as far as I...

Hello all. I have a database that has a number of forms for data entry. On some of the forms I have implemented a calender control created by Stephen Lebans. Also on these forms I am trying to disable the use of the mouse wheel (I am using Access 97). Mrabrams2 posted an excellent bit of...