Recent content by ReportMan

I went thru and did a saveas on every form, query and macro. Then I rebuilt the forms, queries and macros with the new names. To my utter suprise it now works. I still don't know what the problem was but it seems like it must be mis-spelling of something like that. I appreciate you help....

Yes, that is the main form which the subform is attached to...

When the Results Form is called with the Query as the Data Source, Access puts up a Enter Parameter Value message box with the criteria statement shown.

Yes it is.. It is called thru a macro...

I used the build function in the query to generate the criteria statement but I get the same result...

I am having a problem getting my Query to use the SubForm value as search criteria. I have: Access version 2003 Mainform - Location Master Browse - Location Number Subform - Location Account Browse SubForm - LocMast - Location Number Query - Bank Master Browse Query - LocMast - Location Number...

No such luck.... am using ADO.NET (XML)... I just thought of another way to tell if I am not at the highest level. Is there a way to tell if your have indented the value because that is what the hierarchical sorting is doing.

I am using CR 10 and have grouped by data hierarchically to produce a Table Of Contents. The TOC is perfect as far as the data being correct but I need to format the various levels of the TOC different based on what level it is. My question is how do I determine what level I am at so I can...

Reread her messages, she found the problem..

AirCon, You must have missed the messages that went out today. The problem has been found and corrected. Read the posts and let us know if you have any questions.

I finally found some Microsoft documentation that actually explains why you need the path.... Wish I had found it sooner... Adding pictures Pictures are added to the Shapes collection with the AddPicture method. The syntax is as follows: oSheet.Shapes.AddPicture(cFileName, lLinkToFile...

I just tried it with the full path using a JPG file and it worked just fine. I appreciate all the help that was given.

Thats the same error that I am getting.

I just ran a test where I put the JPG signature into a newly created Excel workbook and e-mailed it to myself. The e-mail attachment is just fine. The Excel file is OK. Don't really know what that proves but it does work.

It doesn't bomb... It just doesn't place anything into the cell. Here is the code being used... * Update Sheet 14 (Declaration) SELECT .aPagePrintOptions[tcFileId, PPO_RESULT_CURSOR] GO TOP toWorkbook.Sheets("Declaration").Select toSheet = toWorkbook.ActiveSheet...