Recent content by karmahum

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...