Replies

I have had problems with Outlook custom forms that reference a database connection in the vb script. No errors given – they just won’t feed the data from the form to the Access database.

Also – Access Snapshot View is gone, so if you have any exports that use it, they will need to be converted to pdf format.

I found a way to make it work!

I moved my code around to look like the following:
Worksheets(“front page”).Range(“BP106”).Select ‘selects the range to be copied into before copying the shape
ActiveSheet.Shapes(“Object 407”).Copy ‘copy the shape without selecting it
ActiveSheet.Paste ‘then the shape pastes into BP106 whether running automatically or manually stepping through this code

Hope I haven’t wasted anyone’s time. Persistence has paid off.

Thanks to all who have looked at and contemplated this problem for me.

Never mind the split screen confusion. I took out the split screen with the same result. It pastes the shape in cell BP106 if I go through the code manually. If I don’t set a breakpoint and let it run, the shape is pasted at the original location instead of in BP106.

I tried putting in msgboxes before and after the select and paste commands, to see if slowing it down made any difference. It didn’t. It still didn’t paste into BP106.

I do have a split screen spreadsheet. The bottom half has input fields that feed into the top half, and the screen is split so the users can see both sections of the worksheet at the same time.

I put a breakpoint at the very last line of code (which moves the cursor to another cell input cell in the worksheet, after the shape has been pasted), and notice that if I scroll the bottom half of the split screen to show PB106 the cell is selected but the shape is not pasted into it. The shape is pasted at the location of the original shape. BP106 in the top half of the split screen does not show selected at this same point.

Adding the unprotect/protect didn’t help on my spreadsheet.

What I did find though —
The shape I’m copying is at the very bottom of the worksheet
When the paste isn’t showing up in cell BP106, I found that the paste is being done at the bottom of the worksheet in the same location it is copying the shape from.
So the selection of the cell BP106 isn’t working, unless I step through the code manually.

I still have not figured out why, but at least I now know it is the selection of the cell that is not working.

Anyone have any thoughts on what I am missing here?

Thanks,
Patty

Update – I tried saving it to a network folder and running the code again and it worked correctly.

I noticed before and forgot to mention:
When I send the form via the email code and it comes in blank
then I look at the file in the directory indicated in the code
the file contains the data from the last correct save and not from the save I just saw run with the code in the document

So maybe it is a problem with the save command – but I don’t get an error on the save.

Patty

The product is Infopath 2007. Since I put Infopath 2007 in the Subject and version line, I assumed I wouldn’t need to repeat it in the paragraph content. Sorry.

We’re getting closer!

I can’t have the Top=0 and the Height=0 or it doesn’t use the numbers in that section for the calculations. It skips them just like it does when I hide the section.

But, if I set Height = .0007 (the smallest it would let me other than 0) and the Top = 0 OR Height = 0 and Top = .0007, the report is real close. There are only a couple of account types that have a little more blank space between them than single spacing. I think this report is only for internal dept use and all accounts now fit on one page, so I will see if it is usable enough for them.

Thanks so much for your help!
Patty

That is how I have it set now and it still leaves blank lines between each account type. There is a different amount of blank lines between the different acount types, so I assume it depends on how many records there are in the detail section being used for calculating.

Thanks a lot! That was exactly what I needed!

Is there a place I could have looked up the value for that symbol? I looked quite a few places and couldn’t find it.

Edited by HansV to provide link to MSKB article using [mskb=839856]

I finally found the answer via Microsoft Knowledge Base Article 839856.

If you apply an advanced rule condition comparing a field for a string, with a form published through Outlook 2002 (or in my case 2003), the string disappears from the rule display, but will actually still work. The workaround says to re-publish the form with Outlook 2000. I did that and it has fixed the problem.

Hope this will help anyone else who runs across the same thing.

Patty

I made a copy of the database, deleted all the tables and forms out of the original, and reimported them from the copy and so far that has fixed the problem.

Thanks so much!

I forgot to mention, I already tried the Compact and Repair and it didn’t help.

In Excel 2003, on Open, when we sort the filenames by date modified with the most recent file on top, it puts all the subdirectory folders at the end of the list.

Is there a way to keep the folders at the top of the list, and still sort the filenames with most recent first?

Thanks,
Patty

Thanks for everyone’s help! I have it working now.

Patty