Recent content by Zenobia

Hello, Can someone give me any pointers? I am trying to give a link to my already created mail merged letter, however if i just to a followhyperlink command it doesn't work. Access freezes and the data wont link (the mail merge document is coming from the open database) Can any help me get...

Yes i have tried however failed..

I would like a button on my form to open an already existing word document... How do i do this? In either VBA or Macro? Thank you

Great thank you. Is there anything else i need to do but insert this code Option Compare Database Dim WithEvents oApp As Word.Application Private Sub Command0_Click() Dim oMainDoc As Word.Document Dim oSel As Word.Selection Dim sDBPath As String Set oMainDoc =...

I've actually just completed this. Would you mind giving me pointers on my other thread? I.e. is there a way to automatically (via button on a form) query results to a mail merge document?

How do you export query results to outlook for processing?

Sorted thank you

LengthDaysOverDue: Now()-[DueDate] Hello I'm trying to round this up to full numbers in my query however i cannot get it work, Can any one shed any light on how to round this calculation to whole numbers? Thank you

Hello, I wish to create a button on a form that will link to data in a table and create mail merge, or link to an existing mail merge document, what is the best way to do this? Thank you

All complete, thank you

Hello Bob, That didn't work, mainly down to my lack of explanation, of which i apologise This is along the lines of what i want to do: Test: IIf([AOverDue]="OverDue",[LengthDaysOverDue]*0.75,[LengthDaysOverDue]=0) However both [AOverDue] and [LengthDaysOverDue] is already a calculated field in...

Thank you very much.. May I also be so cheeky as to ask help for another one? What I am trying to do is calculate a fine based on my column "AOverDue" and [LengthDaysOverdue] If the text in the box = "Overdue" then calculate the [LengthDaysOverDue] by my fine amount (i.e. 0.75) However, i...

Hello, What is the correct way to state an IIF statement for this.. (in a query) I have a field called "DueDate" (i.e. the duedate return of rental) And i want to say if todays (now()) is greater than due date then ... Yes I cant seem to figure it out, any help would be more than great at always

Id like to ask another question if i may. Why when chose to create this on form as a graph why does it look like this? What do the quarters mean? I have no such data like this

That's brilliant thanks so much