Replies

Couldn’t you just transfer the contents of 25 different queries run on the one table? I assume you could differentiate each of the 25 groups in some way so that you could run one query for each group? Then a loop would transfer each recordset to XL.
Peter

Charlotte
For some of my fields in formview I’ve created ControlTip text which used to pop up to remind you what you should put in a field. It’s not on a network and only two of us use the db so we probably don’t need them now. I just wondered how they would stop working. I’ve no idea when it happened but it just occurred to me recently that they weren’t popping up any more. It could have been going on for months.
Regardless of how long I point the mouse, move away, come back – they just don’t work.
I really don’t want anyone to ‘bust a gut’ on this, I just thought someone would know the answer from previous experience. I can’t find a ‘switch’ that turns them on and off.
Peter

I think MSP only has a cassette cover in its library but it’s really easy to set up a teplate for CD inserts. I did it some time ago but unfortunately I no longer have it. Just measure the various sections on one of your existing inserts and create the boxes in MSP. You can then fill it with pictures, text, wordart etc.
You can create some really good looking results.
Peter

Francois
Thanks for that.
Unfortunately it wasn’t the answer so they still don’t work. It’s not a real problem – just irritating.
Thanks again
Peter

Wulfgar
If you use two fields you can amalgamate both fields into one to show the number as you want it (IssueNo =Field1 & Field2). If you can automate the entry to the two fields in some way you can then hide them and of course you sort on Field1 assuming this is the one with the number.
Peter

Thanks for your help. I tried your suggestions but it made no difference. My code all works but the code in Word saves even tho’ it shouldn’t, when document’s originally called from Access. I decided the easiest way was to include this sub in Word and call it b4 I make my text insertion. It may not be ideal but it gives the desired end result.
Thanks again.

Sub OverWrite()
Dim myRange As Range
Set myRange = ActiveDocument.Range( Start:=ActiveDocument.Paragraphs(13).Range.Start,
End:=ActiveDocument.Range.End)
myRange.Select
Selection.Delete
Selection.TypeParagraph
End Sub

Peter Herworth

Mark
Why not just open the soource code in Notepad and set the background to the apprproriate picture file. I’m a big fan of Publisher and have created web pages with it but I find it much easier to edit in Notepad.
Peter

William
Sorry about that. Someone else has already posted the right spelling. Good luck
Peter Herworth

Try Helen Fedemas site (http://www.helenfedema.com). She has loads of code samples for free. I’ve amended a few to automate things in Access. One for passing names to Outlook Contacts can be amended to pass dates to Calendar. Give it a try.
Peter Herworth

Hi Andy
If you have Publisher – use it. I’ve been using it for 6 or 7 years for the kind of thing you mention. I’m now on P2K and although I use Word for letters and lots of other things, when it comes to complicated documents with pictures and fancy lay-outs you can’t beat Publisher.
Good luck.
Peter

You may have already looked at this but I have lost the sound twice with no idea as to why (certainly nothing I was aware of doing). Eventually I checked Settings | Sounds and Multimedia. The little speaker in the bottom right was muted so I switched it back on. Still don’t know how it happened.
Peter Herworth

Put this code in your utility functions and then pause your subform code at the appropriate point for as long as you think necessary.

Sub Pause(ByVal nSecond As Single)
Dim t0 As Single
t0 = Timer

Do While Timer – t0 < nSecond
Dim dummy As Integer
dummy = DoEvents()
' if we cross midnight, back up one day
If Timer < t0 Then
t0 = t0 – 24 * 60 * 60
End If
Loop

End Sub
Peter Herworth

I haven’t tried it for a while but I’m pretty sure you can append (say) the first 3 columns (fields) of one table provided they match the first 3 columns of the append table. The query then ignores all other columns. If France and England are different fields try 2 separate append queries doing say France first then moving the England field into column 3 (in both tables) and running the query again.
Peter Herworth

Merc
Thanks. I knew someone would say this but I was hoping there might be a simple answer out there. Looks like I’ll have to dust off the credit card.
Peter

Charlotte and kaplinb
Thanks for the advice. I took it and everything’s still working fine.
This thread seems to have wandered off on its own since my original request but thanks any way.
Peter