Search results for query: *

Thanks kjv1611. Yesterday evening we uninstall Access 2003 and install Access 2007 (previously we try re-install Access 2003 but still does not work) and manage to resolve the issue. Probably register the dll file would resolve the problem. This is a very good advise but now I am not able...

I try run a simple VB script: 'VBScript Example 'create file system object Set fs = CreateObject("Scripting.FileSystemObject") 'create a new text file Set TestFile = fs.CreateTextFile("c:\testfile.txt", True) 'write a line into the test file TestFile.WriteLine("This is a test for file system...

Thanks for your suggestion. Changed Dir to UsrDir. Unfortunately, same problem. Any other suggestion?

OK. Thanks.

I have a simple Access running VB (for file related function). It has been running happily but suddenly today, an error pop up saying: Run time error '-2147024770 (8007007e)': Automation error The specific module could not be found. When using debug mode, it stop at the 'Set FSO =...'...

I have a simple Access running VB (for file related function). It has been running happily but suddenly today, an error pop up saying: Run time error '-2147024770 (8007007e)': Automation error The specific module could not be found. When using debug mode, it stop at the 'Set FSO =...'...

Dear all, Thanks. Now I understand the means for the recording is to examine the actual code being used. I am using VB (within Access) to perform this little function. The problem is now solved. I here share my small piece of VB code for someone else to reference... DocL.Open "DocList"...

Hi Skip, I don't quite understand how the macro recorder would solve my problem. Firstly the list of documents I have is not small and the password for each document is not the same. I have a table contain the word document names and its password. I am hoping to write a small VB code base on...

Hi, I need to remove all the password for a large number of word documents. I already have a table with the document names and password. How do I code in VB to do this? Many thanks in advance. Kar Yan

Hi, I post the same question in another forum and got an answer shown below. I am glad to say, the suggestion works! Below is link to a PDF which explains regarding the picture quality in cr 8.5...

Hi, I am using crystal report 8.5 developer version and MS Access (2003). I have created a report with a JPG company logo inserted. If I manually export the report to PDF. No problem and the picture looks good. However when I run VB code from Access 2003 to auto export to PDF, the picture...