Recent content by Bosch

Thanks Matt.. I tried all that was mentioned in the link but nothing worked. But I could isolate the problem to a single Form..Even this form I could open in the Design view..but unable to view the code. Looks like I will have to redo this form(Luckily I have a backup about 10 days old..so I...

Hi all.. In my access 2003 application, I can open the database and goto the design view of the Forms..but I cannot view the code. I tried both Alt+F11 and Right click on the form and "Build Even" and "Code Builder". In both cases, access application stops responding. Then I have to close...

Hi everyone I searched the forum for help..but couldnt find what I am looking for. I want to run a batch file using shell cmd and wait for it to complete..until then I want to display a hourglass...because my next line of code needs the batch file run completed. Right now, shell command...

Here is the answer for this issue.I know it was very old thread..but still it might be useful to someone who is searching the forum.. http://support.microsoft.com/Default.aspx?id=317708

ADO did the trick. Finally figured out what the problem was and it was what I suspected. All along I have been using DAO in my application. For some reason Crystal reports does not like DAO. I converted my recordset to ADO then it works ok.

Any ideas on this..anyone? If you are using Crystal reports with Access, please post the code here. Thanks

I dont see "Microsoft® Visual Studio® 2005 Tools for the Microsoft Office System" in the list of trial softwares.. I believe they dont have a trial version for this particular product. I simply bought the licensed software. Did not try to find trial software.

FoFa..thanks again.. I tried that..but same problem. I am wondering if I can kill the CRViewer object before closing the form that has it.. I am not sure how to kill an object.. Thanks

This was my first reponse to your question. You need the following software. "Microsoft® Visual Studio® 2005 Tools for the Microsoft Office System" "Microsoft Office Access 2003 Developer Extensions" is part of it. http://msdn.microsoft.com/vstudio/pr...s/default.aspx Dont worry about what...

Dont seem like you are listening to me! I have developer extensions installed in my computer and distribute my access application..What I am telling you is my first hand experience..

FoFA..thanks for the reply. I already have set crxReport = Nothing.. I am not sure if it is anything to do with ADO / DAO objects. recordset that I pass to the report is a DAO object. Let me know if you have any ideas on this. Thanks

You need to get "Microsoft® Visual Studio® Tools for the Microsoft® Office System version 2003" not just Visual Studio. There are several Visual studio products..dont get confused with them. I dont think you get this for free. When you get the CD, there must be a separate setup.exe for...

the following link tells you how to create mde file.. http://www.databasedev.co.uk/microsoft-access-mde.html I didnt read it fully but you will have to compile the code before you create the mde file. Open your mdb file then under view menu select code. Then select Debug / Compile and save...

I believe the error message that you got is nothing to do with emailing. When one of the users of my access application got this error, I found that the user do not have "Write" permission to the folder in which my mde/mdb file exists. If you dont have "Write" permission then access cannot...

Hope someone here can help me with this. I am using access 2003 and Crystal reports XI. I have created some reports using CRXI that access my access database. I use the following code to open the standard reports. MyReportFile is the name of my rpt file. I have no problems here. Set...