Recent content by Loolaa

ah, thats a bit different! Never done it and I think you will need to assess the top three in a seperate routine as anything done in the detail section deals with the current record only. Sorry I can't be of more use! L

Have a play around with this..... Option Compare Database Private vardate As Date Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer) Me!txtbox = vardate End Sub Private Sub Report_Open(Cancel As Integer) vardate = InputBox("enter date") End Sub L

have this in the OnOpen event..... dim VarDate as date VarDate = inputbox("Enter Date") you can then pass this value to your query or to a text box hope this is what you were after L

try using VBA, I know that this works Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer) Dim DateVar As Date DateVar = InputBox("Enter Date") Me!Text1 = DateVar Me!Text2 = DateVar + 1 Me!Text3 = DateVar + 2 Me!Text4 = DateVar + 3 End Sub L

try this, it'll turn the backgorund light grey Option Compare Database Private RecCount As Integer Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) RecCount = RecCount + 1 If RecCount <= 3 Then Me.Detail.BackColor = 12632256 Else Me.Detail.BackColor = 16777215 End...

if you want to list the customers and distributors all in one go try a union query.

Write a query based on your table grouping the three fields, I am assuming that there is a transaction id field in your table, just make sure that you miss this out of your query. If you want the actual description of the salesperson, client and fund then link into the query the tables that...

Hi, If you want to print the word document at the end of your report I know that this works..... Private Sub Report_Close() On Error GoTo openerror Dim WordApp As Word.Application Dim WordDoc As Word.Document Set WordApp = New Word.Application Set WordDoc = New Word.Document Set WordDoc =...

erm... not sure, I don't tend to use word for things like this. I have a hunch though that word would only let you print one record per page, which is why you are getting your first record repeated 5 times. Perhaps you could try filling the topic details into an array so you only have one record...

Hi, I would recommend writing a query that links both tables and then using a report based on said query for your mail merge. The topic information will be listed in the detail part of the report and you can put the personal information plus the greeting in either the page header or in a group...

Unfortunatley, yes, each reocrd will have different text so a word document is not suitable. I think I'm going to have to admit defeat on this one! Thanks anyway.

the file and location need to be in a string so try.... "Q:\Paperwork\invoice" & RequestNumber & ".rtf" L

try this... DoCmd.OutputTo acOutputReport,"RptName",acFormatRTF,"file name and directory", etc etc HTH

Hi, I'm trying to align text in a text box. The text string is quite long, a paragraph in fact and I want it to be justified as its for a letter. I am using a text box as the text string changes depending on variables. I am using MS Access 2000 and so far I can only manage to centre, left, right...