Recent content by Lloyd1313

As long as I run Access 2000 there is no problem with the output, I only have a problem if I want to run it under 2002. This wouldn't work either if the permissions were a problem. Lloyd.

I checked my database and those references are not selected. Is there anything else you changed ? Lloyd.

I have a program that works fine under Access 2000, my client has purchased some new computers with Access XP on them and the OutPutTo command doesn't work under the new version. The line of code looks as follows: DoCmd.OutputTo acOutputReport, stDocName, acFormatRTF, sPath & sStudent &...

Thank you very much. Either way that should solve the problem. Lloyd.

Tried that and it asks for the database password. Thanks. Lloyd.

I have a client that brilliantly put a database password on an Access 2000 database and doesn't know what it was. Does anyone know if there is any way to get past the password ? Thanks. Lloyd.

Your code appears to print the report twice. I need both copies to printed together. It looks to me like the code will produce one run with one footer and the next run with the other footer. Thanks. Lloyd.

I have a report that sometimes needs to have each page printed twice with a different footer on each page, the two pages need to print together. I haven't been able to find any way to do this. I'm using Access 2000. Thanks. Lloyd.

I'm running an Access 2000 app. In a query I'm using a sum function on a number defined as single. The sum function is not returning the correct total for the numbers, it's adding in decimal places that don't exist in the orginal numbers. The numbers have a max of 4 decimal places and the number...

Finding the record is no problem. The pdf is embeded not linked so a path doesn't exist. There is a text field to search on. In my code I've used a snapshot recordset and have the record and field I want to launch from. It's just launching from the embeded object that is giving me trouble. Lloyd.

Option three woun't work as the pdf object is embeded in a table. I'm using Access 2000 and Acrobat 5.0. The path to Acrobat is d:\Program Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe Lloyd.

Thanks for the reply. I don't think it really answers my problem though. The pdf is embeded in a table. I want to be able to find the record I want in a recordset and launch using the ole field in the table. I've tried option 2 and the application opens fine but I couldn't find a way to...

I have a table with a field that is an ole type. It stores a pdf. I'm trying to launch the pdf using VBA and haven't been able to find a way to do it. Thanks. Lloyd.

Thanks. I used their services. It was quick, fixed well and not expensive. I have a feeling my client is giving a little more priority to a good backup protocall now :-). Lloyd.

Thanks for the idea but all I get is a message saying "error compacting the database". Lloyd.