Search results

Hello, can anyone tell me if we can nest IIf(null) statements? Im using ACCESS 97 thnaks

hmmmm Hello and thanks SO much again for the help... I was playing around with this and discovered that when i formatted this button (the one that automates to the WORD template) onto a form with all the fields in question listed, it worked fine. WHy?! I feel like i hit a problem and then...

Even with With?? Hey and thanks for helping.. Do i need to add wrd. to identify even if i have sandwhiched prefaced the entire series of replacements with With wrd.activedocument.bookmarks etc. End With ?? Thanks mcvayman

Hello I hope it's ok if i simply ask how you transported the fields to the template? Are you using bookmarks and VB code to do so. If so, then in what manner are you referring to the fields? Thanks Sorry this is not a direct answer to your question... it's jus that you kind of asked a...

Hello there anyone who can help... I'm trying to open a query in ACCESS and replace bookmarks in a WORD.DOT (template). Please see the code below: DoCmd.OpenQuery "qry1370frm4" 'Declare an instance of MS Word. Dim wrd As New Word.Application Set wrd =...

Preserve headers? Thank you. Is there any way to have the headers published in Word RTF as headers?? That would cure cancer for me. Thanks, Allen

Can anyone tell me if it is possible to email a report and allow the user to edit the report and print is back. Best deal: Export a report to Word (with formatting preserved!) and "disconnect" it from MS Access. Thanks so much mcvayman :confused:

Thank you Hey i appreciate this. I'll go and try it. m

Hello, I'm a novice database builder but know the basics pretty well. No SQL or VBA training though-- just learning code recently. Can someone please help with this problem: I just need data fields within my report to expand or shrink HORIZONTALLY. The data i pull from my source is largely...

Thanks I appreciate your advice. Your point regarding my boss' changes being reflected in the database source is very important. I think i will end up forgoing this line of pursuit and simply construct a report. I'm going to mount the database on our "shared files" (we're on a LAN) and make...

Hello, I've built a database to track individuals but also to try and make reports faster. I'm pulling data from Access to fill in fields in a common template and then writing the body of the report. The problem comes when i then save the document and email it to my administrator. She must be...