Replies

Correction: Copied/pasted your code – changed the first line to: Sub cmdOpen_PDF_Click()

Ok I tried it, Hans. I’ve done something wrong, though. When I click the command button I get the message, ‘the object doesn’t contain the Automation object ‘Open_PDF.’

I am very very basic when it comes to inserting and using code, so please excuse my ignorance.
here’s what I did:
Clicked on Modules, New
Copied/pasted your code – changed the first line to: Sub cmdOpen_PDF()
Saved it
Closed the window

Created a New Macro (clicked Macros, new)
Under Action, clicked RunCode
Function name at bottom I typed Open_PDF
Saved macro
Closed screen

Created cmd button on form with the command button wizard and picked Miscellaneous, Run Macro and picked the Open_PDF macro.

Tested the button and got an Action Failed screen.
Macro name: Open_PDF
Condition: True
Action Name: RunCode
Arguments: Open_PDF

Pressed the Halt button
received the error message.

Soooo what did I do wrong?

Thanks for your patience.

That all makes perfect sense to me, Hans. Thank you. I’ll let you know how it works. You are right, the admins did not customize the front end. So yep, I can modify it and send it to them. Thank you!!

Thanks. I am the IT Support Trainer, so I will be the one users call to ask why this doesn’t work or that didn’t get copied and how to do this or that in Outlook. I plan to hold many many pre-release training classes as well as ongoing training. So I need to know the gotcha’s ahead of time. What can we do now in GroupWise that we won’t be able to do in Outlook? What processes will change?

Our network team will be doing the actual migration, but I need to know the gotcha’s ahead of time.

Thanks for the links. I’ll take a look at them and see if they help.

So much more elegant than the mess I made. Thank you. I see where my IF statement was messing up too. Thank you, Hans!

Thank you, but I don’t see an attachment, Hans.

Never mind.. I am rescinding this post. In talking with the user, it appears we cannot format the data correctly to do the calculation in the pivot table. Thanks anyway for your time!

These are students attending classes .. some classes are one day, some are a week long, and some are for 3 – 6 hours a week for several months. On this particular line, I know she went to this class two nights a week for several months, but I’m not sure how many hours each night she went. For argument’s sake, let’s assume she went 6 hours a week for 12 weeks = 72 hours of training time.

I have a similar database that tracks computer training and I listed each session separately. Should I have her do that with her database? It’s easier for me to calculate time with each session separately. But, she has something like 600 records and she didn’t want to modify it. However, I don’t see any way around that.

Here it is. Thanks, Hans. I put the sample data in an Excel spreadsheet because I had to modify the names in it for confidentiality. This is a direct pull from a query (with just the student names changed). I can send the db offline if that will help, but I can’t post it. Thanks.

I found this thread and I think it is what I’m trying to do, but I’m having problems getting it to work. I am pretty code illiterate, so please be patient with me.
My file is names “Sustations” and the worksheet is called “Inspection report”. The users will be opening this worksheet as a template, making their edits and then saving it.
I would like to save the workbook saved with a new name each time someone uses the form. I’d like the name to be a combination of data picked from a list in C1 and the date entered in T1.
I’d like it to be saved on our network drive (for example, M:MelanieForms).
How can I modify this code to work? And, how do it put it in the workbook. I know to press Alt+F11 to get to the code, but I don’t know where to put it after that.

Thank you for any help you can give me.

Bingo. Jeesh. Thank you!! I read the help screen in Access, but I guess I misinterpreted what it said. Thank you.

Hans, this worked so well. I’m thrilled with it. The user has shown me, though, that if a letter extends to 2 pages, there is a header on the 2nd page. I can’t see it until after the merge is done, so I can’t edit it for all the records. The user has been deleting the header on each record that has one – a pretty tedious process for a 700-page merge. We either want a way to not have the header on the 2nd page or can you tell me how to edit it on the main document before we merge?

I’m sorry I didn’t get back to this sooner. I’ve recreated the document (it’s going to be a template once I get the TOC issue working). I created each of them using Insert, referece, Table of contents, and the options. I’m attaching it so you can take a look. I have done it this way on many many reports before and have been able to update each one separately before. In the last month, this same issue has happened on 5 other documents that other people have created. They all asked me why it’s different now. I do not have a clue.

The director said she wants a series of tables below one another in one worksheet.

I agree. But that’s not an option. I already asked that question. Long winded reply that amounted to “No.”